Classic View: PA State Reporting > PIMS Extracts > Staff Student Subtest Template
Search Terms: PIMS Extracts
The PIMS Staff Student Subtest Template returns any student enrolled in a Course Section as of the entered effective date for the selected calendar AND there is an assessment associated with the course that contains a designated state code (see the Report Logic section for more information).
See the PIMS Reporting article for additional PIMS Reporting information.
Report Logic
When the Exclude checkbox is marked on the District Assignment tool, the staff person does not report. When the All Students checkbox is NOT marked, students are excluded when:
- the student has an active Enrollment OR the most recent Enrollment as of the Effective Date chosen on the extract editor has an Assessment Participation Code of A:PASA (Student Information > General > Enrollment > State Reporting Fields > Assessment Participation).
- the student has an active Enrollment state grade level OR the most recent Enrollment as of the Effective Date chosen on the extract editor does NOT match the grade level of assessment selected on the extract editor.
When the Assessment State Code Ends in a number, the following reports:
- When assessment state codes last digit is 3, 003 reports.
- When assessment state codes last digit is 4, 004 reports.
- When assessment state codes last digit is 5, 005 reports.
- When assessment state codes last digit is 6, 006 reports.
- When assessment state codes last digit is 7, 007 reports.
- When assessment state codes last digit is 8, 008 reports.
- When assessment state codes last digit is 11, 011 reports.
When the State Assessment code is selected on the extract editor does not end in a number, the Section Assessment logic applies for reporting all students. Marking All Students does not change this logic.
A Section Assessment field can be populated on the report editor. When populated, districts can pull section level assessment information for the selected assessment.
Students enrolled in a course as of the entered Effective Date for the selected calendar are included on the report when the course has an Assessment assigned to it with one of these Subtest Identifiers selected as the State Code:
| SUBTEST IDENTIFIER | SUBTEST IDENTIFIER DEFINITION | TEST DESCRIPTION |
|---|---|---|
| KALG1SPR | Keystone Algebra I Spring | KALGI |
| KALG1SUM | Keystone Algebra I Summer | |
| KALG1WIN | Keystone Algebra I Winter | |
| KBIOSPR | Keystone Biology Spring | KBIO |
| KBIOSUM | Keystone Biology Summer | |
| KBIOWIN | Keystone Biology Winter | |
| KLITSPR | Keystone Literature Spring | KLIT |
| KLITSUM | Keystone Literature Summer | |
| KLITWIN | Keystone Literature Winter | |
| PSSAELA3 | PSSA English/Language Arts Grade 3 | PSSAELA |
| PSSAELA4 | PSSA English/Language Arts Grade 4 | |
| PSSAELA5 | PSSA English/Language Arts Grade 5 | |
| PSSAELA6 | PSSA English/Language Arts Grade 6 | |
| PSSAELA7 | PSSA English/Language Arts Grade 7 | |
| PSSAELA8 | PSSA English/Language Arts Grade 8 | |
| PSSAM3 | PSSA Math Grade 3 | PSSAM |
| PSSAM4 | PSSA Math Grade 4 | |
| PSSAM5 | PSSA Math Grade 5 | |
| PSSAM6 | PSSA Math Grade 6 | |
| PSSAM7 | PSSA Math Grade 7 | |
| PSSAM8 | PSSA Math Grade 8 | |
| PSSASCI4 | PSSA Science Grade 4 | PSSASCI |
| PSSASCI8 | PSSA Science Grade 8 |
State Test Setup, Assigned State Code
One record per administrative unit / staff ID / student district code / student ID / school year / assessment district code / test description / assessment school year date / subtest identifier reports. All teachers are accounted for only once in the report. In a situation where a Primary Teacher stops teaching a section for a period of time, then returns as the Primary Teacher or Regular Teacher, the percent of shared instruction and percent of concurrent enrollment combines the multiple instances of that teacher into one value.
When there are multiple records where all fields are identical except the Percentage Of Concurrent Enrollment field, the multiple records are combined and the Percentage Of Concurrent Enrollment value is summed to a cap of 100 to report one record. When all fields identical, the percentages are combined to a cap of 100.
The Staff ID must exist in the Staff Snapshot Template for the same year.
Section Assessment
When a Section Assessment is chosen on the report editor, the Subtest Identifier field on the report equals the selected assessment state code. When a Section Assessment is not selected, the Subtest Identifier field reports from the State Code field.
When the Section Assessment is chosen and the Section Active Date is populated, only students scheduled into courses at the section level that are active as of that date report.
- The course must have an assessment assigned to it with one of the state codes listed above.
- The Assessment State Code must be the same as the code selected for the Section Assessment.
- When there is no Section Active Date selected, all course/sections that have a State Assessment Code report.
Generate the Staff Student Subtest Template
- Select the Staff Student Subtest Template from the Extract Type dropdown list.
- Enter the Effective Date.
- Enter the Prior Reporting Date.
- Select the appropriate Section Assessment options. More than one can be selected.
- Enter the Section Active Date.
- Select the desired Format.
- Optional: mark the All Students checkbox.
- Optional: select an Ad hoc Filter to return only those students included in that filter.
- Select the desired Calendar.
- Click the Generate Extract button. Results display in the selected format.
PIMS Staff Student Subtest - HTML Format
PIMS Staff Student Subtest - State Format
Report Layout
| Data Element | Description | Campus Interface |
|---|---|---|
| State District Number | State District Number Numeric, 9 digits | System Administration > Resources > District Information > State District Number Student Information > General > Enrollments > State Reporting Fields > Serving District District.number |
| Staff ID | A unique identifier assigned by the Pennsylvania Department of Education to each staff member reported in PIMS. This reports from the State Staff ID field for ALL reporting periods. Numeric, 7 digits | Census > People > Demographics > Person Identifiers > Staff State ID Person.staffID |
| Student District Code | Reports the Administrative Unit Number assigned by the Pennsylvania Department of Education to each district. Numeric, 9 digits | System Administration > Resources > District Information > State District Number District.number |
| Student ID | Reports the state ID of each student. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > Student State ID Person.stateID |
| School Year Date | Reports as June 30th of the end year of the calendar. Date field, 10 characters, YYYY-06-30 | System Administration > Calendar > School Years > School Year Detail Calendar.endDate |
| Assessment District code | Reports a value of 999999999. | N/A |
| Test Description | Reports the code assigned to the assessments for which the teacher is assigned instructional responsibility. See the Report Logic section for reported values. Alphanumeric, 60 characters | Calculated Value |
| Assessment School Year | Reports as June 30th of the school year. Date field, 10 characters, YYYY-06-30 | System Administrations > Calendar > School Years Calendar.endDate |
| Subtest Identifier | Reports the subtest code for which the teacher is assigned instructional responsibility. Alphanumeric, 9 characters | Assessment > Test Setup > Test Detail > State Test > State Code Test.stateCode |
| Percentage of Shared Instruction | Reports the percentage of instruction for which the teacher is responsible for the assessment, by individual student. The percentage of shared instruction (instructional responsibility weight) accounts for shared instruction of a student. Percentage reports as follows for Primary Teachers or Non-Primary Teachers:
For Non-Primary Teachers, the percentage field must be populated on either the Roster or the Staff History. The Percentage field always reports from the Roster Verification when the Roster is certified for either Primary or Non-Primary teachers. Numeric, 9 digits (decimal point) | System Administration > Roster > Verification Event Log > Roster Verification Code System Administration > Roster > Verification Event Log > Roster Data Collection Unit: Instruction Percent Scheduling > Courses > Section > Staff History > Staff History Detail > Percent RosterVerificationRequest.code RosterVerificationRequest.collectType SectionStaffHistory.percent |
| Percentage of Concurrent Enrollment | Reports 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. This looks at the Course Days (not Instructional Days) for all Primary Teachers and Teachers who have a Percent value on either the Roster Verification Instruction Percent or on the Staff History Detail. When there are multiple records where all fields are identical except the Percentage Of Concurrent Enrollment field, the multiple records are combined and the Percentage Of Concurrent Enrollment value is summed to a cap of 100 to report one record. When all fields identical, combine percentage to a cap of 100. Calculation: Number of distinct concurrent days the student is enrolled in course with a particular teacher within a reporting period, DIVIDED BY the Number of distinct instructional days the Course Section from the Section Start Date or Prior Reporting Date of the report to the Effective Date of the report.
Numeric, 9 digits (decimal point) | Calculated value |
| Relationship Location Code | Location code associated with the instructional relationship. This code reports from the Alt School Number field on the School editor. When that field is not populated, the State School Number field on the School editor is used. Numeric, 12 characters | System Administration > Resources > School > Alt School Number, State School Number School.altNumber School.number |
Previous Versions
PIMS Staff Student Subtest (Pennsylvania) [.2319 and previous]
