S_ND_USR_X (ver 15.11.0)
This table is an extension of the [USERS] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
UsersDCID | 15.11.0 | Number(10,0) | Foreign Key |
| BachelorDegreeCountry | 23.1.2 | Varchar2(4) | Bachelor Degree Country. |
| BachelorDegreeInstCode | 15.11.0 | Number(11,0) | Bachelor Degree Educational Institution Code. Migrated from [SchoolStaff.ND_BachelorDegreeInstCode] |
| BachelorDegreeYear | 15.11.0 | Number(11,0) | Bachelor Degree Year Received. Migrated from [SchoolStaff.ND_BachelorDegreeYear] |
| DaysContractPeriod | 22.5.2 | Varchar2(3) | Days Contract Period. Migrated from the same field in the S_ND_SSF_X table. |
| FirstYearTeacher | 24.3.1 | Number(1,0) | First Year Teacher. |
| HighestDegreeCountry | 23.1.2 | Varchar2(4) | Highest Degree Country. |
| HighestDegreeHours | 15.11.0 | Number(23,10) | Highest Degree Graduate Semester Hours. Migrated from [SchoolStaff.ND_HighestDegreeHours] |
| HighestDegreeInstCode | 15.11.0 | Number(11,0) | Highest Degree Educational Institution Code. Migrated from [SchoolStaff.ND_HighestDegreeInstCode] |
| HighestDegreeTypeCode | 15.11.0 | Varchar2(2) | Highest Degree Educational Degree Type Code. Migrated from [SchoolStaff.ND_HighestDegreeTypeCode] |
| HighestDegreeYear | 15.11.0 | Number(11,0) | Highest Degree Year Received. Migrated from [SchoolStaff.ND_HighestDegreeYear] |
| LEPPlanManager | 22.5.2 | Number(1,0) | LEP Plan Manager. Migrated from the same field in the S_ND_SSF_X table. |
| Maiden_Name | 17.11.0 | Varchar2(25) | The Maiden Name for the staff member (if applicable). |
| MandatedReportingTraining | 24.3.1 | Number(1,0) | Mandated Reporting Training Completion. |
| NonLicensedNumber | 15.11.0 | Varchar2(7) | Non-licensed Staff PER2 Number. Migrated from [SchoolStaff.ND_NonLicensedNumber] |
| PositionCodeMajor | 22.5.2 | Varchar2(2) | Position Code Major. Migrated from the same field in the S_ND_SSF_X table. |
| PositionCodeOther1 | 22.5.2 | Varchar2(2) | Position Code Other 1. Migrated from the same field in the S_ND_SSF_X table. |
| PositionCodeOther2 | 22.5.2 | Varchar2(2) | Position Code Other 2. Migrated from S_ND_SSF_X.PositionIDOther2. |
| PositionCodeOther3 | 22.5.2 | Varchar2(2) | Position Code Other 3. Migrated from the same field in the S_ND_SSF_X table. |
| PositionCodeOther4 | 22.5.2 | Varchar2(2) | Position Code Other 4. Migrated from the same field in the S_ND_SSF_X table. |
| PercentDevotedKinder | 22.5.2 | Number(11,0) | Percent Devoted to Kindergarten. Migrated from the same field in the S_ND_SSF_X table. |
| PercentDevotedSpecEd | 22.5.2 | Number(11,0) | Percent Devoted to Special Education. Migrated from the same field in the S_ND_SSF_X table. |
| PercentGrades14 | 23.1.2 | Number(11,0) | Percent Grades 1 thru 4. |
| PercentGrades16 | 22.5.2 | Number(11,0) | Percent Grades 1 thru 6. Migrated from the same field in the S_ND_SSF_X table. |
| PercentGrades5 | 23.1.2 | Number(11,0) | Percent Grades 5. |
| PercentGrades6 | 23.1.2 | Number(11,0) | Percent Grades 6. |
| PercentGrades78 | 22.5.2 | Number(11,0) | Percent Grades 7 and 8. Migrated from the same field in the S_ND_SSF_X table. |
| PercentGrades912 | 22.5.2 | Number(11,0) | Percent Grades 9 thru 12. Migrated from the same field in the S_ND_SSF_X table. |
| PercentTimeMajor | 22.5.2 | Number(11,0) | Percent Time Major. Migrated from the same field in the S_ND_SSF_X table. |
| PercentTimeOther1 | 22.5.2 | Number(11,0) | Percent Time Other 1. Migrated from the same field in the S_ND_SSF_X table. |
| PercentTimeOther2 | 22.5.2 | Number(11,0) | Percent Time Other 2. Migrated from the same field in the S_ND_SSF_X table. |
| PercentTimeOther3 | 22.5.2 | Number(11,0) | Percent Time Other 3. Migrated from the same field in the S_ND_SSF_X table. |
| PercentTimeOther4 | 22.5.2 | Number(11,0) | Percent Time Other 4. Migrated from the same field in the S_ND_SSF_X table. |
| PreviousEmployment | 15.11.0 | Varchar2(1) | Previous Employment Type Code. Migrated from [SchoolStaff.ND_PreviousEmployment] |
| ResponsibilityCodeMajor | 22.5.2 | Varchar2(3) | Responsibility Code Major. Migrated from the same field in the S_ND_SSF_X table. |
| ResponsibilityCodeOther1 | 22.5.2 | Varchar2(3) | Responsibility Code Other 1. Migrated from the same field in the S_ND_SSF_X table. |
| ResponsibilityCodeOther2 | 22.5.2 | Varchar2(3) | Responsibility Code Other 2. Migrated from S_ND_SSF_X.ResponsibilityIDOther2.. |
| ResponsibilityCodeOther3 | 22.5.2 | Varchar2(3) | Responsibility Code Other 3. Migrated from the same field in the S_ND_SSF_X table. |
| ResponsibilityCodeOther4 | 22.5.2 | Varchar2(3) | Responsibility Code Other 4. Migrated from the same field in the S_ND_SSF_X table. |
| Salary | 22.5.2 | Number(11,0) | Salary of the Staff Member. Migrated from the same field in the S_ND_SSF_X table. |
| SchoolYearPeriod | 22.5.2 | Varchar2(1) | School Year Period. Migrated from the same field in the S_ND_SSF_X table. |
| TeacherLicenseNumber | 15.11.0 | Varchar2(9) | Teacher License Number. Migrated from [SchoolStaff.ND_TeacherLicenseNumber] |
| TeacherSubmissionDate | 22.5.2 | Date | Teacher Submission Date. Migrated from the same field in the S_ND_SSF_X table. |
| YearsAdminExperience | 15.11.0 | Number(11,0) | Years Administration Experience. Migrated from [SchoolStaff.ND_YearsAdminExperience] |
| YearsEdExperience | 15.11.0 | Number(11,0) | Years Educational Experience. Migrated from [SchoolStaff.ND_YearsEdExperience] |
| State_ExcludeFromReporting | 17.11.0 | Number(1,0) | Indicates is the Staff member is excluded from state reporting. |