S_NJ_USR_StaffAssignments_C (ver 20.6.2)
This table is an extension of the [Users] table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| Assignment_Number | 20.6.2 | Varchar2(1) | Assignment Number |
| SMART_CountyCodeAssigned | 20.6.2 | Varchar2(2) | County Code Assigned |
| SMART_DistrictCodeAssigned | 20.6.2 | Varchar2(4) | District Code Assigned |
| SMART_SchoolCodeAssigned | 20.6.2 | Varchar2(3) | School Code Assigned |
| SMART_FTE | 20.6.2 | Varchar2(4) | Full Time Equivalency |
| SMART_JobCode | 20.6.2 | Varchar2(4) | Job Code |
| SMART_JobCodeSubCat | 20.6.2 | Varchar2(1) | Job Code Subcategory |
| SMART_AgeGroupTaught | 20.6.2 | Varchar2(1) | Age Group Taught (required for SubCategory 3,4,5) |
| SMART_CredentialType | 20.6.2 | Varchar2(1) | Credential Type (required for Job Codes 0100-4001, except 0700, 0701, 0702, and 0703.) |
| SMART_TeacherPrep | 20.6.2 | Varchar2(1) | Teacher Prep (required for Certified Staff) |