Student Local Assessment Subtest for Reporting and Analytics

Introduction

This template identifies whether a student has met the required standards for grades from PreK through 12 in the subtest area ELA and Math, where the LEA exercises the local assessment option instead of the standard PSSA for any or all the grades for reporting and analytics. A student may have multiple results for the same assessment provided the assessments are administered on different dates.

Grain: One record per LEA / School / School Year / Local Assessment / Student.

Output File Name

The report output file name consists of the following:

District Code = 9-digit Administrative Unit Number
Target table (located on the template)
Date and time stamp (ensures each file is unique), the format is YYYMMMDDHHMM
File Extension (data separator type)“csv”, "tab", or "del"

Example: 100000009_STUDENT_LOCAL_ASSMNT_SUBTEST_201709051134.csv

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The report selects which student records to use based on the following criteria:

The student must be enrolled in a school included in the report.
The student must not be excluded from state reporting.
The student must be in grade levels from PreK through 12 during the reporting period.

Report Input

For help with report generation and navigation, see How to Find and Generate a Report.

Field	Description
Students to Include	When Running the Report from the School: Select one of the following: The Selected [number of] Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school or district that meet the selection criteria. If running the report for a single student or group of students, select the students prior to running the report. When Running the Report from the District, indicate which schools to include in the report by selecting from the following options: If sub-districts are not enabled: Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria. All Schools (default) – Run the report for all schools. Includes all student records on the PowerSchool server that meet the selection criteria If sub-districts are enabled: Select Sub-district - Select the sub-district for which you want to run the report. Current School Only – Run the report for only the current selected school. Includes all student records associated with the selected schools that meet the selection criteria. All Schools in selected sub-district (default) – Run the report for all schools in the selected sub-district. Includes all student records on the PowerSchool server that meet the selection criteria.
Select School Year	From the pop-up menu, choose the year for which the report should be run.
Field Delimiter	Select the field delimiter for the extract file.
Include Header Labels in output file?	Choose Yes or No to indicate whether to include column headings in the extract file. Including column headers provides a heading for each type of data extracted in the report.

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

At least one score must have a value.
Values for Score 1 and Score 2 must be numeric and whole numbers.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	District Code	The unique, nine-digit Administrative Unit Number assigned by the PDE. This field is extracted from Start Page > District Setup > District Info.	[Prefs]Value where [Prefs]Name=PA_districtAUN If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number	Alpha-numeric	9
2	Test Description	The PDE-defined value identifying the assessment specified at Start Page > Student Selection > Pennsylvania State Information > Local Assessments >Test Description. Valid value: For ELA: Acadience, Aimsweb, Dibels, Dra, Easycbmk-8, Easycbm1-8, Easycbm2-8, Exactpath, Fp, Ireadyk-8, Imaginelearning, Ixl, Linkit, Mapgrowth, Renstar, Starcbmreadingk-6 For Math: Acadience, Aimsweb, Easycbmk-8, Exactpath, Fastbridge, Getmoremath , -Readyk-8, Imaginelearning, Ixl, Linkit, Nweamap, Springmath, Renstar	[S_PA_STU_LocalAssessment_C]Test_Description	Alpha-numeric	5
3	School Year Date	A single date indicating the whole school year; the June 30 at the end of the standard school year is used to designate a school year. Thus, the 2017-2018 school year would be indicated by 2018-06-30.	Derived based on the year for which the report is run.	Alpha-numeric	10
4	Subtest Subject Area	The description of the subtest area. Valid values: ELA Math	[S_PA_LocalAssessments_S]SubTest_Area	Alpha-numeric	25
5	Subtest Grade Level	The grade level for which the subtest was administered, extracted in a 3-digit format. Must match the grade level reported for the student in the STUDENT template. See Appendix K in Volume 2 of the PIMS User Manual for valid values corresponding to grades 3 and 7.	[S_PA_STU_X]State_Grade_Code [S_PA_REN_X]State_Grade_Code	Alpha-numeric	15
6	Subtest Version ID	The version ID of the subtest. Valid value: 1	[S_PA_LocalAssessments_S]SubTest_VersionID	Alpha-numeric	8
7	Not Collected
8	Subtest Identifier Organization Type Code	The constant value, 08 is extracted.		Numeric	20
9	Not Collected
10	PASecureId	The unique 10-digit PAsecureID assigned to the student.	[Students]State_StudentNumber	Numeric	12
11	Test Date	The date on which the test was taken.	[S_PA_STU_LocalAssessment_C]Test_Date	Date	10
12	Status	The constant value of 15 must be extracted.		N/A	20
13	Not Collected
14	Not Collected
15	Score Type 1	If Score 1 has a value then extract 033, if score 1 is blank then extract a blank. Valid values: 033 Blank	Based on [S_PA_STU_LocalAssessment_C]Score1	Numeric	3
16	Score 1	The value of Score 1 is extracted. For example, 86.	[S_PA_STU_LocalAssessment_C]Score1	Numeric	35
17	Score Value Type 1	If a value is available in the Score 1 field then extract 'Integer', or extract blank. Valid values: Integer Blank	Based on [S_PA_STU_LocalAssessment_C]Score1	Alpha	50
18	Not Collected
19	Not Collected
20	Score Type 2	If Score 2 has a value then extract 031, if score 2 is blank then extract a blank. Valid values 031 Blank	Based on [S_PA_STU_LocalAssessment_C]Score2	Numeric	3
21	Score 2	The value of Score 2 is extracted. For example, 86.	[S_PA_STU_LocalAssessment_C]Score2	Numeric	35
22	Score Value Type 2	If a value is available in the Score 2 field then extract 'Integer', or extract blank. Valid values: Integer Blank	Based on [S_PA_STU_LocalAssessment_C]Score2	Alpha	50
23	Not Collected
24	Not Collected
25	Score Type 3	If Score 3 has a value then extract 045, if score 3 is blank then extract a blank. Valid values: 045 Blank	Based on [S_PA_STU_LocalAssessment_C]Score3	Numeric	3
26	Score 3	The value of Score 3 is extracted. For example, PREA.	[S_PA_STU_LocalAssessment_C]Score3	Alpha-numeric	35
27	Score Value 3	If a value is available in the Score 3 field, extract 'Level' or extract blank. Valid values Level Blank	Based on [S_PA_STU_LocalAssessment_C]Score3	Alpha-numeric	50