PowerSchool SIS Washington

Field Set: State WA Virtual WA_OpenDoors 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_OpenDoors

foreignKey

S_CA_STU_Authorizations_C

foreignKey

WA_OpenDoors

user_defined_date

S_CA_STU_Authorizations_C

startDate

WA_OpenDoors

user_defined_date2

S_CA_STU_Authorizations_C

endDate

WA_OpenDoors

WA_OpenDoorVocFTE

S_CA_STU_Authorizations_C

VocFTE

WA_OpenDoors

WA_OpenDoorNonVocFTE

S_CA_STU_Authorizations_C

NonVocFTE

WA_OpenDoors

WA_ExcludeFromP223OD_Att

S_CA_STU_Authorizations_C

ExcludeFromP223OD_Att

WA_OpenDoors

WA_ExcludeFromP223OD_Status

S_CA_STU_Authorizations_C

ExcludeFromP223OD_Status

WA_OpenDoors

WA_ExcludeFromP223OD_AcProg

S_CA_STU_Authorizations_C

ExcludeFromP223OD_AcProg

WA_OpenDoors

WA_OpenDoorsComment

S_CA_STU_Authorizations_C

ODComment

WA_OpenDoors

unique_ID

S_CA_STU_Authorizations_C

unique_ID

WA_OpenDoors

schoolID

S_CA_STU_Authorizations_C

schoolID

WA_OpenDoors

foreignKey_alpha

S_CA_STU_Authorizations_C

foreignKey_alpha