Field Set: State VA Virtual VA_MSC v1
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 |
|---|---|---|---|
| VA_MSC | unique_id | S_VA_SEC_Additional_Staff_C | unique_ID |
| VA_MSC | schoolID | S_VA_SEC_Additional_Staff_C | schoolID |
| VA_MSC | foreignkey | S_VA_SEC_Additional_Staff_C | foreignKey |
| VA_MSC | foreignkey_alpha | S_VA_SEC_Additional_Staff_C | foreignKey_alpha |
| VA_MSC | VA_teacher_role_cd | S_VA_SEC_Additional_Staff_C | Teacher_Role_Code |
| VA_MSC | VA_defined_class_type | S_VA_SEC_Additional_Staff_C | Defined_Class_Type |
| VA_MSC | VA_highly_qual_flag | S_VA_SEC_Additional_Staff_C | Highly_Qualified_TF |
| VA_MSC | VA_flex_criteria_flag | S_VA_SEC_Additional_Staff_C | Flexibility_Criteria_TF |
| VA_MSC | VA_KidsTaughtText | S_VA_SEC_Additional_Staff_C | KidsTaughtText |
| VA_MSC | VA_KidsTaught | S_VA_SEC_Additional_Staff_C | KidsTaught |
| VA_MSC | user_defined_text | S_VA_SEC_Additional_Staff_C | sectionID |
| VA_MSC | user_defined_numeric | S_VA_SEC_Additional_Staff_C | userID |
| VA_MSC | sortby | S_VA_SEC_Additional_Staff_C | sortby |
| VA_MSC | teacherid | S_VA_SEC_Additional_Staff_C | teacherid |