1. Home
  2. Teacher Classroom Link Report Pre 2020

Teacher Classroom Link Report Pre 2020

Summary: This report produces a list of teachers with their classroom link information including class ID number, service id, course sequence, population served, class role id, campus, dual credit, non campus based instruction, and a count of students that is hyperlinked to a detailed student list view.

Note: This report only produces results through the 2018-2019 school year. Starting with the 2019-2020 school year, staff are no longer reported in the PEIMS summer submission.

Usage: Review report for course completion summer reporting. Use the drill down on count of students to review student level data with course completion information (including pass/fail indicator and college credit hours). The report can also be exported to Excel and used to link to other areas in staff since it includes the teacher’s unique id.

Data Sources: This report utilizes the PEIMS Summer records

  • InterchangeStaffAssociation
    • 30040 – Staff Extension Complex Type
    • 30305/50300 – Teacher Section Association Extension Complex Type
  • InterchangeStudentTranscript
    • 43415 – Course Transcript Complex Type
  • InterchangeStudentEnrollment
    • 40110 – Student School Association Complex Type
    • 40110/50300 – Student Section Association Complex Type
  • InterchangeMasterSchedule
    • 50300 – Section Extension Complex Type

Definitions:

  • Only includes records with a Course Completion Indicator (E1068) = ‘1’
  • 40110/50300 – Student Section Association Complex Type
    • Class-ID-Number – E1056
    • Service ID – E0724
    • Course Sequence Code – E0948
    • Non Campus Based Instruction – E1072
  • 50300 – Section Extension Complex Type
    • Population Served – E0747
  • 43415 – Course Transcript Complex Type
    • Dual Credit – E1081
  • 30305/50300 – Teacher Section Association Extension Complex Type
    • TX-Unique ID – E1524
    • Class Role ID – E1067
    • Campus – E0266

Calculations:

  • Count of Students in Class = sum of filtered 43415 course completion records by Class-ID-Number

Features:

  • Filter on:
    • Year
    • Campus
    • Course Sequence to look for ‘pieces’ of classes. Use codes 0, 2, 5, 9 to search for ‘completed’ courses
    • Class Role to identify different types of teachers (Teacher of Record, Assistant, or Support)
  • Drill down on count of students in class to display a detailed student list with all of the course completion attributes (classroom id, service id, population served, pass/fail indicator, college credit hours, etc.)
Updated on 11/04/2021

Was this article helpful?