Course Instructor Template

PIMS Course Instructor Template Specifications

(22 Fields • 8 Collected • Delimited)
Target Table:
CRSE_INSTRUCT
Load Sequence / Dependencies:

The Course Instructor Template depends on the Course Template and Staff Template being loaded first.

Template Description

The Course Instructor Template identifies the instructor(s) for each section of every course reported in the Course Template. Submit this template cumulatively so the primary instructor associated with each section and course is reported for the entire school year.

Include the following instructor records:

  • All active teachers assigned to a course section.
  • Teachers on long-term leave who retain an assignment for a course section.
  • Retired teachers who taught a portion of the course prior to retirement.
  • Long-term substitutes when they are the teacher of record, or when they are employed as a professional or temporary professional employee.

Do not include:

  • Teachers who were terminated during the school year unless the course ended with their departure.

Notes:

  • Follow the Course Template and Staff Template conventions when matching course and staff records.
  • This template is intended to capture the primary instructor for each section over the school year; use the Supplementary Course Differentiator and Section Code fields to distinguish multiple sections when necessary.

Template Specifications

1 - SUBMITTING AUN

RequiredKeyMax Length: 9

The unique, 9-digit AUN assigned by the PDE.

Sample Value

All LEA and School Numbers can be found on the EdNA website.

123456789

eScholar Name: DISTRICT CODE


2 - SCHOOL NUMBER

RequiredKeyMax Length: 4

The PDE-defined 4-digit code identifying the school.

Sample Value

All LEA and School Numbers can be found on the EdNA website.

1234

eScholar Name: LOCATION CODE


3 - SCHOOL YEAR DATE

RequiredKeyMax Length: 10

A single date (June 30), the last day of the current school year indicating the whole school year.

Sample Value

2026-06-30


4-7 🛇

Field(s) not collected. Must be delimited in template file.


8 - PRIMARY INSTRUCTOR ID

RequiredUpdateableMax Length: 7

A unique identifier for all instructors, regardless of whether they hold a PA certificate; the 7-digit Professional Personnel ID (PPID). Professional personnel can obtain a PPID from the TIMS system. Helpful information is found at the PDE website > Educators > Certification.

Sample Value

0123456789


9-16 🛇

Field(s) not collected. Must be delimited in template file.


17 - SUPPLEMENTARY COURSE DIFFERENTIATOR

RequiredKeyMax Length: 2

This field is used to help make a course unique where the same COURSE CODE is offered in more than one-time period during the school year. This field will represent the general span of time in which a course and its sections are offered.

Business Rules

This field should match the Supplementary Course Differentiator (Semester) column in the Course Template for the relevant course code record.

Sample Value

See Appendix O in Volume 2 of the PIMS User Manual for a complete list of valid values.


18 🛇

Field(s) not collected. Must be delimited in template file.


19 - COURSE CODE LONG

RequiredKeyMax Length: 12

The unique, local, LEA-specific COURSE CODE.

Business Rules

Courses may have multiple sections. Each course should have a single COURSE CODE LONG. Do not assign separate course codes to sections of the same course.

Sample Value

20 - PRIMARY INSTRUCTION LANGUAGE CODE

OptionalUpdateableMax Length: 4

The primary language in which a course is taught.

Note

This field should be left blank for courses taught in US English.

Sample Value

See Appendix J in Volume 2 of the PIMS User Manual for a complete list of valid values.


21 🛇

Field(s) not collected. Must be delimited in template file.


22 - SECTION CODE LONG

RequiredKeyMax Length: 25

Class section number assigned by LEA to identify distinct classes.

Note

This field should be the local section number only.

Sample Value

Rules

See the Rules Section of the Template Domain for rules consistent throughout all templates.