PA Staff Student Subtest Template for Act 13 Educator Effectiveness
Introduction
The PA Staff Student Subtest Template for Act 13 Educator Effectiveness contains a record for each teacher/student instructional relationship for each assessment. The report must be submitted in a cumulative fashion indicating all instructional relationships related to PSSA and Keystone Assessments for the school year. The report includes all the current course records with one or more subtests attached for the terms in the date range, where the DateEnrolled and DateLeft are in the date range. Inactive courses are also included.
Data Setup
For data setup, see:
Required Data Entry for the Staff Student Subtest - Sections
Adding Additional Staff - Student Instructional Relationships
Selection Criteria
Student not excluded from state reporting.
School not excluded from state reporting.
Current Courses, Sections, and Courses are not excluded (for example, Exclude from PIMS is not selected).
Note: Report Start Date and Report End Date defaults to the First Day and Last Day defined for the current year in the District.
Report Input
For help with report generation and navigation, see How to Find and Generate a Report.
Field | Description |
Select Schools | Indicate which schools to include in the report by selecting from the following options: If sub-districts are not enabled:
If sub-districts are enabled:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Students to Include | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Report State Date | Enter a date using the format mm/dd/yyyy for the first day of the report date range. |
Report End Date | Enter a date using the format mm/dd/yyyy for the last day of the report date range |
Field Delimiter | Select one of the following options:
|
Show Column Field Headers and Debug Info | Choose Yes to output the header, which will include Teacher Number, Teacher Name, Student Number, and Student Name. Note: Do not choose Yes when submitting data to the state. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName | Field Length |
1 | Submitting AUN | The unique, 9-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education This is the AUN of the LEA submitting this PIMS template. | [Prefs]Value where [Prefs]Name=PA_districtAUN If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number | 9 |
2 | PPID | A unique identifier assigned by the Pennsylvania Department of Education to each staff member reported in PIMS. This is the 7-digit Professional Personnel ID (PPID) for all certificated and non-certificated staff with direct instructional responsibility for the course. | [S_PA_CRS_X]State_Staff_ID Else [Users]SSN | 12 |
3 | Student AUN | The unique, 9-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education. These are the AUN’(s) of the LEA(s) in which the student is enrolled while participating in the course/grade/subject of instruction. | [Prefs]Value where [Prefs]Name=PA_districtAUN If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number | 9 |
4 | PAsecureID | The unique, 10-digit identifier (PAsecureID) assigned by the Department of Education to each student. There is a record for each PAsecureID, which indicates students for whom staff have direct instructional responsibility for the applicable course/grade/subject of instruction. | [Students]State_StudentNumber | 12 |
5 | School Year Date | A single date representing the entirety of the school year. This is the school year being reported followed by the month and day of the end of the school year; for example, the 2018-2019 school year would be reported as 2019-MM-DD. | [S_PA_Calendar_S]CalendarEndDate | 10 |
6 | Assessment AUN | The unique, 9-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education. This is the state AUN. | 999999999 - Hard coded | 9 |
7 | Test Description | The unique code that represents the assessment for which this teacher is assigned instructional responsibility. Valid values:
| Derived from [S_PA_CRS_X]KeySubTestIdentifier | 7 |
8 | Assessment School Year Date | A single date indicating the whole school year. June 30 at the end of the standard school year is used to designate the Assessment school year; for example, the 2018-2019 school year would be reported as 2019-06-30. | Based on the report start and end dates entered at report run time. | 10 |
9 | Subtest Identifier | The unique code that represents the more specific subtest for which this teacher is assigned instructional responsibility. See Appendix AK in the PIMS User Manual Volume 2 for a complete list of valid values. | [S_PA_CRS_X]KeySubTestIdentifier | 200 |
10 | Percentage of Shared Instruction (Instructional Responsibility Weight) | The percentage of instruction for which this teacher is responsible for the assessment, by individual student. For example:
When a teacher has a change of percentage of shared instruction, values are averaged by the number of records. For example, if a teacher had an 80% allocation from 08/27/18 to 01/07/19 and a 75% allocation from 01/07/19 to 06/03/19, the reported Percentage of Shared Instruction would be 78% not 100%. Note: This percentage accounts for shared instruction of a student from day one of the instruction (subject/grade/course) for the state assessment, up to and including the last school day before the LEA's testing window opens for that state assessment. | [SectionTeacher]Allocation [S_PA_SEC_C]Allocation Or derived from the Allocation column in the [teacherSecInfoTable] temporary table. | 10 |
11 | Percentage of Concurrent Enrollment (Instructional Relationship Weight) | 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. The calculation is (days enrolled / days in session) *100, rounded. This is a whole number from 0 up to and including 100. For example, if the teacher and student are concurrently enrolled for 35 days in a 140-day course 25 is reported.
If the percentage is not a whole number, the report rounds the number. For example, if a teacher and student are concurrently enrolled for 9 days in a 199-day course, 5 is reported.
Applicable days begin on day one (1) of the course/grade/subject and continue up to and including the last school day before the LEA’s testing window opens. | Derived from the temporary table [relationshipWeight]. | 6,2 |
12 | Relationship School Number | The PDE-assigned, 4-digit code associated with this instructional relationship. This number is related to the Submitting AUN. Note: Each record represents a relationship, not a teacher or student. | [S_PA_SCH_X]PIMS_Location_Code | 4 |
The following fields are extracted when Yes is selected for Show Column Field Headers and Debug Info on the report input page. | ||||
13 | Teacher Number | Locally assigned Teacher Number | [Users]teachernumber | |
14 | Teacher Name | Locally assigned Teacher Name | [Users]lastfirst | |
15 | Student Number | Locally assigned student number | [Students]student_number | |
16 | Student Name | Locally assigned student name | [Students]lastfirst | |
17 | Grade Level | Current Grade Level of student | [Students]grade_level | |
18 | Course Name | Locally assigned course name | [Courses]Course_Name | |
19 | Section Number | Locally assigned section number | [Sections]section_number | |
20 | Percentage of Shared Instruction | The percentage of instruction for which this teacher is responsible. This is a whole number from 0 up to and including 100. | [SectionTeacher]allocation [S_PA_SEC_C]allocation | |