PowerSchool SIS Illinois

S_IL_USR_X (ver 16.6.2)

This table is an extension of the Users table.

Column Name

Version

Data Type

Description

UsersDCID

16.6.2

Number (10,0)

Primary key that relates the extended table to the [Users] table.

Employer_RCDTS

16.6.2

Varchar2(15)

Migrated from [Teachers]IL_Employer_RCDTS

IEIN

16.6.2

Varchar2(12)

Migrated from [Teachers]IL_IEIN

Legal_First_Name

16.6.2

Varchar2(30)

Migrated from [Teachers]IL_Legal_First_Name

Legal_Last_Name

16.6.2

Varchar2(30)

Migrated from [Teachers]IL_Legal_Last_Name

Reason_For_Exit

16.6.2

Varchar2(2)

Migrated from [Teachers]IL_ReasonForExit

Role_Of_Professional

16.6.2

Varchar2(3)

Migrated from [Teachers]IL_RoleOfProfessional

State_ExcludeFromReporting

16.6.2

Number(1,0)

Migrated from [Teachers]IL_ExcludeFromStateReporting