Field Set: State WA Virtual WA_SpecialPrograms v1
This field set was included with State Reporting Installer 17.8.0 released on August 31, 2017.
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
| WA_SpecialPrograms | unique_ID | S_WA_STU_SpecialPrograms_C | unique_ID |
| WA_SpecialPrograms | schoolID | S_WA_STU_SpecialPrograms_C | schoolID |
| WA_SpecialPrograms | foreignKey | S_WA_STU_SpecialPrograms_C | foreignKey |
| WA_SpecialPrograms | user_defined_integer | S_WA_STU_SpecialPrograms_C | programCode |
| WA_SpecialPrograms | user_defined_date | S_WA_STU_SpecialPrograms_C | startDate |
| WA_SpecialPrograms | user_defined_date2 | S_WA_STU_SpecialPrograms_C | endDate |
| WA_SpecialPrograms | foreignKey_alpha | S_WA_STU_SpecialPrograms_C | foreignKey_alpha |
| WA_SpecialPrograms | user_defined_text | S_WA_STU_SpecialPrograms_C | exitReasonCode |
| WA_SpecialPrograms | user_defined_text2 | S_WA_STU_SpecialPrograms_C | qualificationCode |