PowerSchool SIS Washington

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