Assessment Session Location Calculation (SessionName)

This section describes the data sources and logic used to output the ELA/Math Assessment Session Location values. A string composed of the five elements listed below is output, with each element separated by a dash, for example: 123-ELA04-SMITH-567878-02. 

School Code

The data sources are considered in the order listed and the first non-blank value is output

[S_NJ_STU_X]PARCC_Testing_Site_School
[Schools]Alternate_School_Number
[Students]SchoolID 

Test Code

Override 

[S_NJ_STU_X] PARCC_ELA_Test_Code
[S_NJ_STU_X] PARCC_Math_Test_Code

If an override value exists, the value entered in the override is output, truncated to 20 characters. 

Calculated

The same calculation and value as output for the ELA/Math Test Code element is used. 

Teacher Last Name 

Override

[S_NJ_STU_X]PARCC_ELA_Staff_Member_Override
[S_NJ_STU_X]PARCC_Math_Staff_Member_Override

If an override exists, the teacher last name corresponding to the SMID entered is output, truncated to 20 characters.

Note: if an invalid SMID is entered as an override, Teacher Last Name will be extracted as blank in the Assessment Session Location (SessionName) output.

Calculated

[Users]LastName corresponding to the Teacher SMID calculated as the ELA/Math teacher in the StaffMemberAssigned field.

Additional selection logic if the Teacher SMID maps to more than one teacher: MAX[Teachers]ID 

Course Number ELA/Math class

Override

[S_NJ_STU_X]PARCC_ELA_Class_Name_Override
[S_NJ_STU_X]PARCC_Math_Class_Name_Override

If an override value exists, the value entered in the override is output, truncated to 20 characters. 

Calculated - from ELA/Math Class Name element

[Courses]Number 

Section Number ELA/Math class

Override

If an override exists in ELA/Math Class Name field, the Section Number is suppressed from the output.

Calculated - from ELA/Math Class Name element

[CC]Section Number

Additional selection logic if the student has more than one target class in the subject area: MAX[CC]ID