PowerSchool SIS Illinois

S_IL_STU_BirthTo3_C(ver 22.1.2.0)

Column Name

Version

Data Type

Description

ID

22.1.2.0

Number(19,0)

Primary Key

SchoolsDCID

22.1.2.0

Number(19,0)

Foreign Key that relates the extended table back to the Schools table.

IEIN

22.1.2.0

Varchar2(12)


Program

22.1.2.0

Varchar2(2)

To collect an Birth to three program

Program_End_Date

22.1.2.0

Date

Program end date

Program_Start_Date

22.1.2.0

Date

Program start date

Provider_Type

22.1.2.0

Varchar2(3)

Provider Type

Provider_End_Date

22.1.2.0

Date

Provider End Date

Provider_Start_Date

22.1.2.0

Date

Provider Start Date

Service_Location

22.1.2.0

Varchar2(2)

Service location

Program_Model

22.1.2.0

Varchar2(2)

Program Model

Reason_Ending_Program

22.1.2.0

Varchar2(2)

Reason for Ending Program

Reason_Ending_Provider

22.1.2.0

Varchar2(2)

Reason for Ending Provider

GatewaysRegistryMemberId

22.1.2.0

Varchar2(10)

Gateways Registry Member Id

HasGatewaysCredential

22.1.2.0

Boolean

Has Gateways Credential