Skip to main content
Skip table of contents

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:

  1. District Code = 9-digit Administrative Unit Number

  2. Target table (located on the template)

  3. Date and time stamp (ensures each file is unique), the format is YYYMMMDDHHMM

  4. 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


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.