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 |