PIMS Staff Student Course Template (Pennsylvania)

Classic View: PA State Reporting > PIMS Extracts > Staff Student Course Template 

Search TermsPIMS Extracts

The Staff Student Course Template reports a record for each student enrolled in a course for each Primary Teacher and Other Teacher who has a percent value entered that is assigned to that course.

See the PIMS Reporting article for additional PIMS Reporting information.

Report Logic

Students need to be enrolled in a course during the reporting period (on or between the Prior Reporting Date and the Effective Date entered on the report editor).

The Primary Teacher or Other Teacher needs to be assigned to the course during the reporting period (on or between the Prior Reporting Date and the Effective Date entered on the Report Editor). It is assumed the assigned Primary Teacher is the teacher of record for the entire duration of the course, as noted in the Percent field on the Staff History tab.

This extract has a Course Collection Field on the Report Editor. The entered date is the opening date of the course collection and will be populated with 2014-01-06 for the 2013-14 school year.

Instructional Responsibility Weight

The Instructional Responsibility Weight (field 20) reports the percentage of instruction for which the teacher is responsible for the course/grade/subject by individual student.

The Instructional Responsibility Weight will account for shared instruction of a student in a course. Reports a percent value if entered for the Primary Teacher or Regular Teacher that was assigned to a course during the reporting period (Prior Reporting Date and Effective Date on Report Editor) otherwise it is calculated as noted.

  • All Primary Teachers Report at 100% (Default) unless the following:
  • Report Actual percentage if it is populated (Both Primary and Regular Teachers)
  • Due to possible difference in end dating of teachers, customer will be responsible to make sure all Primary or Regular teachers assigned to course = 100%

Instructional Relationship Weight

The Instructional Relationship Weight reports the percentage of school days during which a student and a teacher are enrolled together (concurrently enrolled) in a subject/grade/course, from day one (1) of the course up to and including the last school day This value uses the total number of course days (not instructional days), allowing districts to accurately report this percentage for those course sections that do not meet on a daily basis. It will report on all Primary Teachers and Teachers who have a Percent value on the Staff History Detail. If a student is enrolled for a period of time, withdrawals (drops), and then re-enrolls, the value reported considers the amount of time for both the staff person and the student during all periods of enrollment in the course section.

State Exclude Logic

Students do not report when:

  • The enrollment record is marked as state exclude or as no show.
  • The grade level of enrollment is marked as state exclude.
  • The calendar of enrollment is marked as state exclude.

Generate the Staff Student Course Template

  1. Select Staff Student Course Template from the  Extract Type from the dropdown list.
  2. Enter the Effective Date of the extract in mmddyy format or use the calendar icon to select a date.
  3. Enter the Prior Reporting Date of the extract in mmddyy format or use the calendar icon to select a date.
  4. Enter the Course Collection Date in mmddyy format or use the calendar icon to select a date.
  5. Select the Format of the extract.
  6. Select a Staff Ad hoc Filter, if desired.
  7. Select the appropriate Calendar(s) from which to include data on the extract.
  8. Click the Generate Extract button or the Submit to Batch button, if available. The extract displays in the selected format.

Staff Student Course Template, HTML Format

Staff Student Course Template, State Format (Comma Delimited)

Report Layout

Data Element Description Type, Format and Length Campus Database Campus Interface
Staff District Code Reports the state-assigned district number of the school district where the staff person has instructional responsibility. Numeric, 9 digits District.number System Administration > Resources > District Information > State District Number
Staff ID

Reports the state-assigned staff number for all certificated and non-certificated staff with direct instructional responsibility for the course.


This reports from the State Staff ID field for ALL reporting periods.

Numeric, 10 digits Person.staffStateID Census > People > Demographics > Person Identifiers > Staff State ID
Student District Code Reports the state-assigned district number of the school district where the student receives instruction. Numeric, 9 digits District.number System Administration > Resources > District Information > State District Number
Student ID Reports the student's state-assigned student number. Numeric, 10 digits Person.stateID Census > People > Demographics > Person Identifiers > Student State ID
School Year Date Reports a single date representing the entirety of the school year. This field always reports as June 30 for the selected calendar/school year.

Date field, 10 characters


YYYY-06-30

Calendar.endYear System Administration > Calendar > Calendar > School Years
Course District Code Reports the state-assigned District Number indicating the district where the course is taught. Numeric, 9 digits District.number System Administration > Resources > District Information > State District Number
Course Location Code

Reports the State School Number in which the course is taught.


This code reports from the Alt School Number field on the School editor. If that field is not populated, the State School Number field on the School editor is used.


The school number reports for the employer of the Teacher of Record for the course location UNLESS the majority or totality of direct instruction occurs in a physical instructional setting assigned to a school code different than that of the employer of the teacher of record.

Numeric, 4 digits

School.altNumber

School.number

System Administration > Resources > School > Alt School Number, State School Number
Course Code Reports the locally assigned Course Number assigned by the school or district. Alphanumeric, 30 characters Course.number Scheduling > Courses > Course > Number
Supplementary Course Differentiator Reports the general span of time in which a course and its sections are offered. This field identifies a specific course as unique when the same Course Code is applied to multiple, non-current course offerings during a single school year. Text field, N/A Section.semester Scheduling > Courses > Course > Custom Data Elements > Semester Code
Section Code Reports the number assigned to the local education agency to identify the distinct classes within a course offering. Text, 30 character Section.number Scheduling > Courses > Course > Section > Section Number
Reporting Date Reports the date from the Course Collection Date field entered on the Report Editor. This reports as 2014-01-06 for the 2013-14 school year.

Date field, 10 characters


YYYY-MM-DD

N/A N/A
Relationship Start Date Reports the opening date of the school year. This field reports as 2013-07-01 for the 2013-14 school year.

Date field, 10 characters


YYYY-M-DD

N/A N/A
 Filler Fields 13-15  These fields do not report. N/A N/A N/A
Instructional Responsibility Weight

Reports the percentage of instruction for which the teacher is responsible for the course/grade/subject by individual student. This field does account for any shared instruction in a course.


See the Report Logic section for additional information.

Numeric, 3 digits SectionStaff History.percent Scheduling > Courses > Course > Section > Staff History > Staff History Detail > Percent
 Filler Fields 17-19  These fields do not report. N/A N/A N/A
Instructional Relationship Weight

Reports the percentage of school days during which a student and a teacher are enrolled together (concurrently enrolled) in a subject/grade/course from day one of the course up to and including the last school day before the testing window opens.


See the Report Logic section for additional information.

Numeric, 3 digits Calculated, data not stored Calculated, data not stored