Washington State Assessments

How are records matched to students in Illuminate?

SSID (8) to State Student ID only

How are unique records identified?

SSID (Column 8) only.

How are records matched to students in Illuminate?

2014-2015: SSID (13) to State Student ID only

How are unique records identified?

2014-2015: 

• AdministrationMonthYear (1)
• SSID (13)

How are records matched to students in Illuminate?

EDS WAMS Assessment Data 2013-2014: 

• 1st: SSID (7) to State Student ID
• 2nd: DistrictID (8) to Local Student ID

How are unique records identified?

2013-2014

"CEDARS" Table

• SSID (7)
• DistrictID (8)

"DAPE", "MSP", "MSP - B" and "WAASPORT" Tables (Math, Reading, Sci, and Writing)

• mathResolvedAttempted (29), ReadingResolvedAttempted (14), scienceResolvedAttempted (36), or writingResolvedAttempted (21) – depending on Subject 
• SSID (7)
• DistrictID (8)

"HSPE" and "HSPE - B" Tables (Reading and Writing)

• ReadingResolvedAttempted (14) or writingResolvedAttempted (21) – depending on Subject
• SSID (7)
• DistrictID (8)

"EOC Math 1" Table

• EOCMathyr1Attempted (43)
• SSID (7)
• DistrictID (8)

"EOC Math 2" Table

• EOCMathyr2Attempted (49)
• SSID (7)
• DistrictID (8)

"EOC Biology" Table

• EOCBiologyAttempted (55)
• SSID (7)
• DistrictID (8)

How are records matched to students in Illuminate?

2014-2015: 

• 1st: StateStudentID (14) to State Student ID
• 2nd: DistrictStudentID (13) to Local Student ID 

How are unique records identified?

2014-2015: DistrictStudentID (13) only

How are records matched to students in Illuminate?

All WELPA Imports (2011-2012, 2012-2013, 2013-2014, and 2014-2015)

• 1st: Look to match SSID (12) to State Student ID
• 2nd: Look to match DistrictStudentID (13) to Local Student ID

How are unique records identified?

All WELPA Imports (2011-2012, 2012-2013, 2013-2014, and 2014-2015): 

• SSID (12)
• DistrictStudentID (13)