S_CA_USR_X (ver. 16.2.2)
This table is an extension of the [Users] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
JobClassification | 16.2.2 | Varchar2(2) | Job Classification. Migrated from [Teachers.CA_ClassDesig]. |
ELInstructor | 16.2.2 | Varchar2(2) | EL Instructor. Migrated from [Teachers.CA_ELInstructor]. |
| EmploymentEndDate | 17.4.0 | Date | The first date of employment. Migrated from [Teachers.CA_EndDate]. |
| EmploymentStartDate | 17.4.0 | Date | The day after the last date of employment. Migrated from [Teachers.CA_DateOfHire]. |
FormerFirstName | 16.2.2 | Varchar2(20) | Former First Name. Migrated from [Teachers.CA_FormerFirstName]. |
FormerLastName | 16.2.2 | Varchar2(50) | Former Last Name. Migrated from [Teachers.CA_FormerLastName]. |
FormerMiddleName | 16.2.2 | Varchar2(20) | Former Middle Name. Migrated from [Teachers.CA_FormerMiddleName]. |
HighestDegree | 16.2.2 | Varchar2(1) | Highest Degree Earned. Migrated from [Teachers.CA_HighestDegree]. |
InstructionLanguage | 16.2.2 | Varchar2(2) | Instruction Language. Migrated from [Teachers.CA_InstructionLanguage]. |
PartTime | 16.2.2 | Varchar2(1) | Part Time Indicator. Migrated from [Teachers.CA_Parttime]. |
PositionStatus | 16.2.2 | Varchar2(1) | Position Status Code. Migrated from [Teachers.CA_PositionStatus]. |
SEID | 16.2.2 | Varchar2(10) | State Identifier. Migrated from [Teachers.CA_SEID]. |
| State_ExcludeFromReporting | 17.4.0 | Number(1,0) | Exclude the staff member from specific California reports. Migrated from [Teachers.State_ExcludeFromReporting]. |
YearsInDistrict | 16.2.2 | Number(10,0) | Years in District. Migrated from [Teachers.CA_YearsInDistrict]. |
YearsOfService | 16.2.2 | Number(10,0) | Years of Service. Migrated from [Teachers.CA_YearsOfService]. |