Tool Search: PIMS Extract
The Staff Student Subtest template contains a record for each teacher/student instructional relationship for each assessment type selected in the extract editor. The report must be submitted cumulatively indicating all instructional relationships related to PSSA and Keystone Assessments for the school year.
This report is due in Winter and Spring.
See the PIMS Reporting article for additional PIMS Reporting information.
Report Logic
Any student enrolled in a course as of the effective date for the selected calendar(s) and has an Assessment set up on the course that meets the following condition report:
- The Course has an Assessment set up with one of the following State Codes from Test Setup > Test Detail > State Test > State Code of KALG1SPR, KALG1SUM, KALG1WIN, KBIOSPR, KBIOSUM, KBIOWIN, KLITSPR, KLITSUM, KLITWIN, PSSAELA3, PSSAELA4, PSSAELA5, PSSAELA6, PSSAELA7, PSSAELA8, PSSAM3, PSSAM4, PSSAM5, PSSAM6, PSSAM7, PSSAM8, PSSASCI4, PSSASCI8
Primary teachers report for sections of courses that meet the report population above. Non-primary teacher report when Section Percentage is populated.
Generate Report
- Select Staff Student Subtest - Act 13 Educator from the Extract Type from the dropdown list.
- Enter a Start Date of the extract in mmddyy format or use the calendar icon to select a date.
- Enter the Effective Date of the extract in mmddyy format or use the calendar icon to select a date.
- Select the Section Assessment(s) to include in the report. Options include:
- KALG1SPR : Keystone Algebra I Spring
- KALG1SUM : Keystone Algebra I Summer
- KALG1WIN : Keystone Algebra I Winter
- KBIOSPR : Keystone Biology Spring
- KBIOSUM : Keystone Biology Summer
- KBIOWIN : Keystone Biology Winter
- KLITSPR : Keystone Literature Spring
- KLITSUM : Keystone Literature Summer
- KLITWIN : Keystone Literature Winter
- PSSAELA3
- PSSAELA4
- PSSAELA5
- PSSAELA6
- PSSAELA7
- PSSAELA8
- PSSAM3
- PSSAM4
- PSSAM5
- PSSAM6
- PSSAM7
- PSSAM8
- PSSASCI4
- PSSASCI8
- Select the Format of the extract. Options are Comma Separated (CSV) or HTML.
- Mark the All Students checkbox, if desired.
- Select an Ad hoc filter, if desired.
- Select the desired Grades to include.
- Select the appropriate Calendar(s) from which to include data on the extract. This defaults to the calendar selected in the Campus toolbar. At least one calendar is required.
- Click the Generate Extract button or the Submit to Batch button. The extract generates in the selected format.
Report Layout
Data Element Label | Description | Location |
---|---|---|
State District Number | The unique, 9-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education. Reports the State District Number. Numeric, 20 digits | District Information > State District Number |
Staff ID | A unique identifier assigned by the Pennsylvania Department of Education to each staff member reported in PIMS. Reports the Staff State ID. Numeric, 12 digits | Demographics > Person Identifiers > Staff State ID |
Student District Number | The unique, 9-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education. Reports the State District Number. Numeric, 20 digits | District Information > State District Number |
Student ID | The unique, 10-digit identifier (PAsecureID) assigned by the Department of Education to each student. Reports the Student State ID number. Numeric, 12 digits | Demographics > Person Identifiers > Student State ID |
School Year Date | A single date representing the entirety of the school year. To designate a School Year Date, use the reported school year followed by June 30. Reports the School Year. Date, YYYY-MM-DD | Calendar > School Years |
Assessment District Number | The unique, 9-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education. Reports a value of 999999999. Numeric, 20 digits | N/A |
Test Description | The unique code that represents the assessment for which this teacher is assigned instructional responsibility.
| Calculated |
Assessment School Year | A single date representing the entirety of the school year. To designate a School Year Date, use the reported school year followed by June 30. Reports the School Year. Date, YYYY-MM-DD | Calendar > School Years |
Subtest Identifier | The unique code that represents the more specific subtest for which this teacher is assigned instructional responsibility. Reports the State Code OR Extract Editor Section Assessment. Numeric, 200 digits | Test Setup > Test Detail > State Test > State Code OR Extract Editor Section Assessment |
Percentage of Shared Instruction | The percentage of instruction for which this teacher is responsible for the assessment by individual students. The Percentage of Shared Instruction (Instructional Responsibility Weight) accounts for the shared instruction of a student. Reports the percentage in the following order for Primary or Regular Teachers:
Numeric, 6,2 digits | Staff History > Staff History Detail > Percent |
Percent of Concurrent Enrollment | The percentage of school days during which the student and the teacher are enrolled together (concurrently enrolled) in a course/grade/subject that prepares the student for the assessment. Percent calculation of how many days the student and teacher are concurrently enrolled.
| Calculated |
Relationship Location Code | Location code associated with this instructional relationship: must be a location associated with the Staff District Code reported in field 1. Note that each record represents a relationship, not a teacher or student. Reports from the State School Number. Numeric, 12 digits | School Information > Alt School Number School Information > State School Number |