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. |