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:
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:
|
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:
| [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:
| [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:
| 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:
| 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
| 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:
| 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:
| 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
| Based on [S_PA_STU_LocalAssessment_C]Score3 | Alpha-numeric | 50 |