Field Set: State WA Virtual WA_SpecialEducation 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_SpecialEducation | unique_ID | S_WA_STU_SpecialEducation_C | unique_ID |
| WA_SpecialEducation | schoolID | S_WA_STU_SpecialEducation_C | schoolID |
| WA_SpecialEducation | foreignKey | S_WA_STU_SpecialEducation_C | foreignKey |
| WA_SpecialEducation | LRECode | S_WA_STU_SpecialEducation_C | LRECode |
| WA_SpecialEducation | user_defined_date | S_WA_STU_SpecialEducation_C | startDate |
| WA_SpecialEducation | user_defined_date2 | S_WA_STU_SpecialEducation_C | endDate |
| WA_SpecialEducation | user_defined_integer | S_WA_STU_SpecialEducation_C | exitReasonCode |
| WA_SpecialEducation | foreignKey_alpha | S_WA_STU_SpecialEducation_C | foreignKey_alpha |
| WA_SpecialEducation | user_defined_text | S_WA_STU_SpecialEducation_C | ttlSpEdMinutes |
| WA_SpecialEducation | LastIEPReviewDate | S_WA_STU_SpecialEducation_C | LastIEPReviewDate |
| WA_SpecialEducation | LastEvaluationDate | S_WA_STU_SpecialEducation_C | LastEvaluationDate |
| WA_SpecialEducation | InitialEligibilityDate | S_WA_STU_SpecialEducation_C | InitialEligibilityDate |
| WA_SpecialEducation | InitialReferralDate | S_WA_STU_SpecialEducation_C | InitialReferralDate |
| WA_SpecialEducation | user_defined_text2 | S_WA_STU_SpecialEducation_C | ServiceModel |