CALPADS Staff Assignments Table
For general information about Virtual Tables, such as how to view Virtual Table records, see Virtual Tables.
Virtual table name: CALPADS_StaffAssignments
Data Element | Importing: [Table]Field | DDE: [Table]Field | Required for Import |
|---|---|---|---|
Start Date | [CALPADS_StaffAssignments]EffectiveDate | [VirtualTablesData2]user_defined_date (also seen as EffectiveDate) | Yes |
End Date | [CALPADS_StaffAssignments]EndDate | [VirtualTablesData2]user_defined_date2 (also seen as EndDate) | Yes, if the assignment has ended. |
Job Classification Code | [CALPADS_StaffAssignments]Cert_Class_Desig | [VirtualTablesData2]user_defined_text2 (also seen as Cert_Class_Desig) | Yes |
Job Classification FTE Percentage | [CALPADS_StaffAssignments]FTE | [VirtualTablesData2]user_defined_numeric (also seen as FTE) | Yes |
Non Classroom Based Job Assignment 1 Non Classroom Based Job Assignment 2 etc. (1 through 7) | [CALPADS_StaffAssignments]Job_Code_1 [CALPADS_StaffAssignments]Job_Code_2 etc. (1 through 7) | [VirtualTablesData2]Job_Code_1 [VirtualTablesData2]Job_Code_2 etc. (1 through 7) | Yes, if the Job Classification Code is 0000001. |
School ID | [CALPADS_StaffAssignments]schoolID | [VirtualTablesData2]schoolID | Yes |
Staff ID Note: The staff member's internal ID is stored in [Teachers]ID. | [CALPADS_StaffAssignments]foreignKey | [VirtualTablesData2]foreignKey | Yes |