S_ND_SSF_X (ver 15.10.0)
This table is an extension of the [SCHOOLSTAFF] table.
Important: As of May 2020, the North Dakota School Staff fields are migrated to the North Dakota extension of Users (S_ND_USR_X) for state reporting beginning in the 2022-23 school year. This table is now considered obsolete.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SchoolStaffDCID | 15.10.0 | Number(10,0) | Foreign Key |
| DaysContractPeriod | 15.10.0 | Varchar2(3) | Days Contract Period. Migrated from [SchoolStaff.ND_DaysContractPeriod]. |
| LEPPlanManager | 15.10.0 | Boolean | LEP Plan Manager. Migrated from [SchoolStaff.ND_LEPPlanManager]. |
| PercentDevotedKinder | 15.10.0 | Number(25,10) | Percent Devoted Kindergarten. Migrated from [SchoolStaff.ND_PercentDevotedKinder]. |
| PercentDevotedSpecEd | 15.10.0 | Number(25,10) | Percent Devoted Special Ed PK. Migrated from [SchoolStaff.ND_PercentDevotedSpecEd]. |
| PercentGrades16 | 15.10.0 | Number(25,10) | Percent Devoted Grades 1 - 6. Migrated from [SchoolStaff.ND_PercentGrades16]. |
| PercentGrades78 | 15.10.0 | Number(25,10) | Percent Devoted Grades 7 - 8. Migrated from [SchoolStaff.ND_PercentGrades78]. |
| PercentGrades912 | 15.10.0 | Number(25,10) | Percent Devoted Grades 9 - 12. Migrated from [SchoolStaff.ND_PercentGrades912]. |
| PercentTimeMajor | 15.10.0 | Number(25,10) | Percent Time Major. Migrated from [SchoolStaff.ND_PercentTimeMajor]. |
| PercentTimeOther1 | 15.10.0 | Number(25,10) | Percent Time Other 1. Migrated from [SchoolStaff.ND_PercentTimeOther1]. |
| PercentTimeOther2 | 15.10.0 | Number(25,10) | Percent Time Other 2. Migrated from [SchoolStaff.ND_PercentTimeOther2]. |
| PercentTimeOther3 | 17.11.0 | Number(25,10) | Percent Time Other 3. |
| PercentTimeOther4 | 17.11.0 | Number(25,10) | Percent Time Other 4. |
| PositionCodeMajor | 15.10.0 | Varchar2(2) | Position Code Major. Migrated from [SchoolStaff.ND_PositionCodeMajor]. |
| PositionCodeOther1 | 15.10.0 | Varchar2(2) | Position Code Other 1. Migrated from [SchoolStaff.ND_PositionCodeOther1]. |
| PositionIDOther2 | 15.10.0 | Varchar2(2) | Position Code Other 2. Migrated from [SchoolStaff.ND_PositionIDOther2]. |
| PositionCodeOther3 | 17.11.0 | Varchar2(2) | Position Code Other 3. |
| PositionCodeOther4 | 17.11.0 | Varchar2(2) | Position Code Other 4. |
| ResponsibilityCodeMajor | 15.10.0 | Varchar2(3) | Responsibility Code Major. Migrated from [SchoolStaff.ND_ResponsibilityCodeMajor]. |
| ResponsibilityCodeOther1 | 15.10.0 | Varchar2(3) | Responsibility Code Other 1. Migrated from [SchoolStaff.ND_ResponsibilityCodeOther1]. |
| ResponsibilityCodeOther2 | 15.10.0 | Varchar2(3) | Responsibility Code Other 2. Migrated from [SchoolStaff.ND_ResponsibilityIDOther2]. |
| ResponsibilityCodeOther3 | 17.11.0 | Varchar2(3) | Responsibility Code Other 3. |
| ResponsibilityCodeOther4 | 17.11.0 | Varchar2(3) | Responsibility Code Other 4. |
| Salary | 19.5.1 | Number(11) | Salary. Migrated from [SchoolStaff.ND_Salary]. Changed from Number (25,10) to Number(11) in version 19.5.1. |
| SchoolYearPeriod | 15.10.0 | Varchar2(1) | School Year Period. Migrated from [SchoolStaff.ND_SchoolYearPeriod]. |
| TeacherSubmissionDate | 19.5.1 | Date | Captures the date when the Teacher Portal version of the Staff Information page is submitted. |