PA Staff Student Subtest Template for Teacher-Student Linkages
Introduction
This template is used to report teacher-student linkages to facilitate population of a custom student list where teachers can select the current-year students and view their historical data in PVAAS.
Data Setup
For data setup, see:
Required Data Entry for the Staff Student Subtest - Sections
Adding Additional Staff - Student Instructional Relationships
Selection Criteria
Student must be not excluded from state reporting.
School must not be 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. |
Print Student Legal Name | The legal name is selected by default. |
Reporting Period | Select the reporting year. |
Show Column Field Headers and Debug Info | Select whether to include the headers and debug fields. If No is selected then 13 through 19 reports columns are not displayed. |
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 | Reporting Period | The numeric value to identify the collection period identified in the Elementray/Secondary Data Collection Calendar. Valid values:
| 1 | |
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 2024-2025 school year would be reported as 2025-06-30. | Based on the report start and end dates entered at report run time. | 10 |
9 | Subtest Identifier | The unique code that corresponds with the reporting period for this template. Prints TSL1 for October and TSL2 for January. Valid Values:
| ||
10 | Not Collected | |||
11 | Not Collected | |||
12 | Not Collected | |||
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 | |