Field Set: State WA Virtual WA_BilingualEd 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_BilingualEd | foreignKey | S_WA_STU_LEP_C | foreignKey |
| WA_BilingualEd | schoolID | S_WA_STU_LEP_C | schoolID |
| WA_BilingualEd | user_defined_text2 | S_WA_STU_LEP_C | instModelCode |
| WA_BilingualEd | user_defined_date | S_WA_STU_LEP_C | startDate |
| WA_BilingualEd | user_defined_date2 | S_WA_STU_LEP_C | endDate |
| WA_BilingualEd | WA_PlacementTestCode | S_WA_STU_LEP_C | PlacementTestCode |
| WA_BilingualEd | WA_GradeLevelAtPlacement | S_WA_STU_LEP_C | GradeLevelAtPlacement |
| WA_BilingualEd | user_defined_text | S_WA_STU_LEP_C | ExitReasonCode |
| WA_BilingualEd | user_defined_numeric | S_WA_STU_LEP_C | placementTestScore |
| WA_BilingualEd | user_defined_integer | S_WA_STU_LEP_C | placementLevel |
| WA_BilingualEd | PlacementTestDate | S_WA_STU_LEP_C | PlacementTestDate |
| WA_BilingualEd | ProgramEligDesignation | S_WA_STU_LEP_C | ProgramEligDesignation |
| WA_BilingualEd | InitialUSAPlacementDate | S_WA_STU_LEP_C | InitialUSAPlacementDate |
| WA_BilingualEd | InitialWAPlacementDate | S_WA_STU_LEP_C | InitialWAPlacementDate |
| WA_BilingualEd | NumberOfMonthsUSAtt | S_WA_STU_LEP_C | NumberOfMonthsUSAtt |
| WA_BilingualEd | NumberOfMonthsNonFormal | S_WA_STU_LEP_C | NumberOfMonthsNonFormal |
| WA_BilingualEd | unique_ID | S_WA_STU_LEP_C | unique_ID |
| WA_BilingualEd | foreignKey_alpha | S_WA_STU_LEP_C | foreignKey_alpha |