PowerSchool SIS Illinois

S_IL_SEC_Teacher_Tracking_C (ver 17.5.0)

This is a child table (section is the parent table) for migration from IL_Section_Teacher_Tracking virtual table.

Column Name

Version

Data Type

Description

ID

17.5.0

Number(11,0)

Primary Key

SchoolID

17.5.0

Number(11,0)

ID of the school associated with this Store code list. Migrated from [IL_Section_Teacher_Tracking.SchoolID].

Teacher_id

17.5.0

Varchar2(10)

The teacher ID. Migrated from [IL_Section_Teacher_Tracking.Teacher_id].

StartDate

17.5.0

Date

Start Date. Migrated from [IL_Section_Teacher_Tracking.StartDate].

EndDate

17.5.0

Date

End Date. Migrated from [IL_Section_Teacher_Tracking.EndDate].

Role_of_professional

18.8.0

Varchar2(3)

Role of Professional. Migrated from [IL_Section_Teacher_Tracking.Role_of_professional].

Teacher_commitment

17.5.0

Number(25,10)

Teacher to Course Commitment. Migrated from [IL_Section_Teacher_Tracking.Teacher_commitment].

Actual_attendance

17.5.0

Varchar2(10)

No longer used. Migrated from [IL_Section_Teacher_Tracking.Actual_attendance].

Total_attendance

17.5.0

Varchar2(10)

No longer used. Migrated from [IL_Section_Teacher_Tracking.Total_attendance].

Reason_for_exit

17.5.0

Varchar2(2)

Reason for Exit. Migrated from [IL_Section_Teacher_Tracking.Reason_for_exit].

Sort_by

17.5.0

Varchar2(50)

Internal use. Migrated from [IL_Section_Teacher_Tracking.Sort_by].

foreignkey

17.5.0

Number(11,0)

Stores the section id, connecting with the section parent table.

foreignKey_alpha

17.5.0

Number(11,0)

No longer used.