S_NJ_USR_X (ver 17.3.0)
This table is an extension of the [Users] table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| UsersDCID | 17.3.0 | Number(10,0) | Foreign Key to [Users] table. |
| Local_Teacher_ID | 17.3.0 | Varchar2(20) | Migrated from: [Teachers]NJ_Local_Teacher_ID |
| SMART_First_Name | 17.3.0 | Varchar2(30) | Migrated from: [Teachers]NJ_SMART_First_Name |
| SMART_Last_Name | 17.3.0 | Varchar2(50) | Migrated from: [Teachers]NJ_SMART_Last_Name |
| StaffMemberID | 17.3.0 | Varchar2(8) | Migrated from: [Teachers]NJ_StaffMemberID |
| SMART_NamePrefix | 20.6.2 | Varchar2(11) | Name Prefix |
| GenerationCodeSuffix | 20.6.2 | Varchar2(3) | Generation Code Suffix |
| FormerName | 20.6.2 | Varchar2(50) | Former Name |
| SMART_CertificationStatus | 20.6.2 | Varchar2(1) | Certification Status |
| SMART_DistrictBeginDate | 20.6.2 | Date | District Employment Begin Date |
| SMART_DistrictEntryCode | 20.6.2 | Varchar2(2) | District Entry Code |
| SMART_DistrictExitDate | 20.6.2 | Date | District Employment Exit Date |
| SMART_DistrictExitReason | 20.6.2 | Varchar2(2) | District Employment Exit Reason |
| SMART_Salary | 20.6.2 | Number | Salary |
| SMART_LanguageSpoken | 20.8.2 | Varchar2(3) | Language Spoken By Teacher |
| SMART_MigrantEdProgramCat | 20.6.2 | Varchar2(1) | Migrant Education Program Staff Category |
| SMART_MEPSessionType | 20.6.2 | Varchar2(1) | MEP Session Type |
| SMART_TitleIProgramCat | 20.6.2 | Varchar2(1) | TitleI Program Staff Category |
| SMART_HighestLevelEd | 20.6.2 | Varchar2(2) | Highest Level of Education Completed |
| SMART_NationalBoardAward | 20.6.2 | Date | National Board Award |
| SMART_SEProgramContrCat | 20.6.2 | Varchar2(2) | SE Program Contracted Services Category |
| SMART_ELLInstructorCredType | 20.6.2 | Varchar2(1) | ELL Instructor Credential Type |
| SMART_YearsOfExp | 20.6.2 | Number | Years Of Prior Experience |
| SMART_YearsInNJ | 20.6.2 | Number | Years In NJ |
| SMART_YearsInLEA | 20.6.2 | Number | Years In LEA |
| SMART_TraditionalRouteProg | 20.6.2 | Varchar2(3) | Traditional Route Program |
| SMART_AlternateRouteProg | 20.6.2 | Varchar2(3) | Alternate Route Program |
| Excl_Frm_SMART_STF_SUBMISSN | 20.8.2 | Varchar2(1) | A New field to Include/ Exclude the NJ Staff information and save the same for extract. |