Field Set: State ID Virtual ID_StaffAssignments
This field set was included with State Reporting Installer 17.8.0 released on September 1, 2017.
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
| ID_StaffAssignments | foreignKey | S_ID_USR_StaffAssignments_C | foreignKey |
| ID_StaffAssignments | unique_id | S_ID_USR_StaffAssignments_C | unique_id |
| ID_StaffAssignments | foreignKey_alpha | S_ID_USR_StaffAssignments_C | foreignKey_alpha |
| ID_StaffAssignments | schoolID | S_ID_USR_StaffAssignments_C | schoolID |
| ID_StaffAssignments | user_defined_text | S_ID_USR_StaffAssignments_C | AssignmentCode |
| ID_StaffAssignments | user_defined_integer | S_ID_USR_StaffAssignments_C | PeriodNumber |
| ID_StaffAssignments | user_defined_date | S_ID_USR_StaffAssignments_C | EffectiveDate |
| ID_StaffAssignments | user_defined_date2 | S_ID_USR_StaffAssignments_C | EndDate |
| ID_StaffAssignments | FTE | S_ID_USR_StaffAssignments_C | FTE |
| ID_StaffAssignments | ID_ClassLevel | S_ID_USR_StaffAssignments_C | ClassLevel |
| ID_StaffAssignments | ID_ContractNo | S_ID_USR_StaffAssignments_C | ContractNo |
| ID_StaffAssignments | ID_CourseStandards | S_ID_USR_StaffAssignments_C | CourseStandards |
| ID_StaffAssignments | ID_CRDCFteFactor | S_ID_USR_StaffAssignments_C | CRDCFteFactor |
| ID_StaffAssignments | ID_GradeLevel | S_ID_USR_StaffAssignments_C | GradeLevel |
| ID_StaffAssignments | ID_HQDate | S_ID_USR_StaffAssignments_C | HQDate |
| ID_StaffAssignments | ID_HQT | S_ID_USR_StaffAssignments_C | HQT |
| ID_StaffAssignments | ID_InstructionalSetting | S_ID_USR_StaffAssignments_C | InstructionalSetting |
| ID_StaffAssignments | ID_NoncertRate | S_ID_USR_StaffAssignments_C | NoncertRate |
| ID_StaffAssignments | ID_NoncertHours | S_ID_USR_StaffAssignments_C | NoncertHours |
| ID_StaffAssignments | ID_NoncertWeeks | S_ID_USR_StaffAssignments_C | NoncertWeeks |
| ID_StaffAssignments | ID_QualOverride | S_ID_USR_StaffAssignments_C | QualOverride |
| ID_StaffAssignments | ID_TeachingRole | S_ID_USR_StaffAssignments_C | TeachingRole |