Student Local Assessment Subtest Template

Students to Include

When Running the Report from the School:

Select one of the following:

• • The Selected [number] 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.

Note: If running the report for a single student or group of students, select the students prior to running 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.

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

20

2

Test Description

The PDE-defined value identifying the assessment.

Valid value:

• LOCAL

[S_PA_STU_LocalAssessment_C]Test_Description

Alpha-numeric

60

3

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

Dervied based on the year for which the report is run.

Alpha-numeric

10

4

Subtest Area

The description of the subtest area.

Valid values:

• MATH
• READING

[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

The version ID of the subtest.

Valid value:

• 1

7

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

8

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

9

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

10

Student ID

The PAsecureID assigned to the student. This field is extracted from Start Page > Student > State/Province - PA > PA SecureID.

[Students]State_StudentNumber

Alpha-numeric

10

11

Test Date

The date on which the test was taken.

[S_PA_STU_LocalAssessment_C]Test_Date

Date

10

12

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

13

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

Score Type 1

Valid value:

• STD

Fixed value

Alpha-Numeric

35

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

The standard the student must meet.

Valid value:

• MOTS

Indicates if the student met the standard.

Valid values:

• Y – Yes
• N – No

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A

Not Collected

A blank placeholder is extracted.

N/A

N/A

N/A