S_CA_USR_StaffAssignments_C (ver 17.9.0)
This is a child table of the Users table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AssignmentCode | 17.9.0 | Number(11,0) | Assignment Code. Migrated from [CALPADS_StaffAssignments.user_defined_integer]. |
Cert_Class_Desig | 17.9.0 | Varchar2(75) | Job Classification Code. Migrated from [CALPADS_StaffAssignments.user_defined_text2]. |
EffectiveDate | 17.9.0 | Date | Effective Date. Migrated from [CALPADS_StaffAssignments.user_defined_date]. |
EndDate | 17.9.0 | Date | End Date. Migrated from [CALPADS_StaffAssignments.user_defined_date2]. |
ForeignKey | 17.9.0 | Number(11,0) | Reserved for future use. Migrated from [CALPADS_StaffAssignments.foreignKey]. |
ForeignKey_Alpha | 17.9.0 | Varchar2(31) | Reserved for future use. Migrated from [CALPADS_StaffAssignments.foreignKey_alpha]. |
FTE | 17.9.0 | Number(25,10) | Full Time Equivalency. Migrated from [CALPADS_StaffAssignments.user_defined_numeric]. |
Job_Code_1 | 17.9.0 | Varchar2(4) | Job Code 1. Migrated from [CALPADS_StaffAssignments.Job_Code_1]. |
Job_Code_2 | 17.9.0 | Varchar2(4) | Job Code 2. Migrated from [CALPADS_StaffAssignments.Job_Code_2]. |
Job_Code_3 | 17.9.0 | Varchar2(4) | Job Code 3. Migrated from [CALPADS_StaffAssignments.Job_Code_3]. |
Job_Code_4 | 17.9.0 | Varchar2(4) | Job Code 4. Migrated from [CALPADS_StaffAssignments.Job_Code_4]. |
Job_Code_5 | 17.9.0 | Varchar2(4) | Job Code 5. Migrated from [CALPADS_StaffAssignments.Job_Code_5]. |
Job_Code_6 | 17.9.0 | Varchar2(4) | Job Code 6. Migrated from [CALPADS_StaffAssignments.Job_Code_6]. |
Job_Code_7 | 17.9.0 | Varchar2(4) | Job Code 7. Migrated from [CALPADS_StaffAssignments.Job_Code_7]. |
SchoolFTE | 17.9.0 | Number(25,10) | School FTE. Migrated from [CALPADS_StaffAssignments.SchoolFTE]. |
SchoolID | 17.9.0 | Number(11,0) | School ID. Migrated from [CALPADS_StaffAssignments.schoolID]. |
| SubDist_Staff_Assign_ID | 20.8.2.0 | Number(11,0) | SubDist_Staff_Assign_ID. Used for Sub-District of Staff Assignment. |
TeacherID | 17.9.0 | Number(11,0) | Teacher ID. Migrated from [CALPADS_StaffAssignments.teacherId]. |
Unique_ID | 17.9.0 | Number(11,0) | Record ID. Migrated from [CALPADS_StaffAssignments.unique_ID]. |
YearID | 17.9.0 | Varchar2(2) | Year ID. Migrated from [CALPADS_StaffAssignments.user_defined_text]. |