Field Set: State CA Virtual CALPADS_StaffAssignments
This field set was included with State Reporting Installer 17.9.0 released on September 29, 2017.
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
CALPADS_StaffAssignments | Unique_id | S_CA_USR_StaffAssignments_C | Unique_id |
CALPADS_StaffAssignments | SchoolID | S_CA_USR_StaffAssignments_C | SchoolID |
CALPADS_StaffAssignments | ForeignKey | S_CA_USR_StaffAssignments_C | ForeignKey |
CALPADS_StaffAssignments | ForeignKey_Alpha | S_CA_USR_StaffAssignments_C | ForeignKey_Alpha |
CALPADS_StaffAssignments | User_Defined_Numeric | S_CA_USR_StaffAssignments_C | FTE |
CALPADS_StaffAssignments | User_Defined_Text2 | S_CA_USR_StaffAssignments_C | Cert_Class_Desig |
CALPADS_StaffAssignments | User_Defined_Date | S_CA_USR_StaffAssignments_C | EffectiveDate |
CALPADS_StaffAssignments | User_Defined_Date2 | S_CA_USR_StaffAssignments_C | EndDate |
CALPADS_StaffAssignments | User_Defined_Text | S_CA_USR_StaffAssignments_C | YearID |
CALPADS_StaffAssignments | User_Defined_Integer | S_CA_USR_StaffAssignments_C | AssignmentCode |
CALPADS_StaffAssignments | SchoolFTE | S_CA_USR_StaffAssignments_C | SchoolFTE |
CALPADS_StaffAssignments | Job_Code_1 | S_CA_USR_StaffAssignments_C | Job_Code_1 |
CALPADS_StaffAssignments | Job_Code_2 | S_CA_USR_StaffAssignments_C | Job_Code_2 |
CALPADS_StaffAssignments | Job_Code_3 | S_CA_USR_StaffAssignments_C | Job_Code_3 |
CALPADS_StaffAssignments | Job_Code_4 | S_CA_USR_StaffAssignments_C | Job_Code_4 |
CALPADS_StaffAssignments | Job_Code_5 | S_CA_USR_StaffAssignments_C | Job_Code_5 |
CALPADS_StaffAssignments | Job_Code_6 | S_CA_USR_StaffAssignments_C | Job_Code_6 |
CALPADS_StaffAssignments | Job_Code_7 | S_CA_USR_StaffAssignments_C | Job_Code_7 |
CALPADS_StaffAssignments | TeacherID | S_CA_USR_StaffAssignments_C | TeacherID |