PowerSchool SIS Illinois

S_IL_STU_EarlyChildhood_X (ver 16.6.2)

This table is an extension of the Students table.

Column Name

Version

Data Type

Description

StudentsDCID

16.6.2

Number(10,0)

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

Date_Services_Began

16.6.2

Date

Migrated from [Students]IL_Date_Services_Began

Early_Head_Start

16.6.2

Number(1,0)

Migrated from [Students]IL_Early_Head_Start

Early_Intervention

16.6.2

Number(1,0)

Migrated from [Students]IL_Early_Intervention

EI_Number

16.6.2

Varchar2(6)

Migrated from [Students]IL_EI_Number

Elig_Determination_Date

16.6.2

Date

Migrated from [Students]IL_Elig_Determination_Date

ER_Action

16.6.2

Varchar2(2)

Migrated from [Students]IL_ER_Action

ER_Coordinator

16.6.2

Varchar2(2)

Migrated from [Students]IL_ER_Coordinator

ER_Date

16.6.2

Date

Migrated from [Students]IL_ER_Date

ER_Home_RCDTS

16.6.2

Varchar2(15)

Migrated from [Students]IL_ER_Home_RCDTS

ER_Parent

16.6.2

Varchar2(2)

Migrated from [Students]IL_ER_Parent

ER_Positive_Relationships

16.6.2

Varchar2(2)

Migrated from [Students]IL_ER_Positive_Relationships

ER_Psychologist

16.6.2

Varchar2(2)

Migrated from [Students]IL_ER_Psychologist

ER_Related_Provider

16.6.2

Varchar2(2)

Migrated from [Students]IL_ER_Related_Provider

ER_Speech

16.6.2

Varchar2(2)

Migrated from [Students]IL_ER_Speech

ER_Teacher

16.6.2

Varchar2(2)

Migrated from [Students]IL_ER_Teacher

ER_Use_Skills

16.6.2

Varchar2(2)

Migrated from [Students]IL_ER_Use_Skills

ExR_App_Action

16.6.2

Varchar2(2)

Migrated from [Students]IL_ExR_App_Action

ExR_App_Action_Prog

16.6.2

Varchar2(2)

Migrated from [Students]IL_ExR_App_Action_Prog

ExR_Coordinator

16.6.2

Varchar2(2)

Migrated from [Students]IL_ExR_Coordinator

ExR_Date

16.6.2

Date

Migrated from [Students]IL_ExR_Date

ExR_Home_RCDTS

16.6.2

Varchar2(15)

Migrated from [Students]IL_ExR_Home_RCDTS

ExR_How_Parent

16.6.2

Varchar2(2)

Migrated from [Students]IL_ExR_How_Parent

ExR_Positive_Relationships

16.6.2

Varchar2(2)

Migrated from [Students]IL_ExR_Positive_Relationships

ExR_Primary_Assessment

16.6.2

Varchar2(2)

Migrated from [Students]IL_ExR_Primary_Assessment

ExR_Psychologist

16.6.2

Varchar2(2)

Migrated from [Students]IL_ExR_Psychologist

ExR_Related_Provider

16.6.2

Varchar2(2)

Migrated from [Students]IL_ExR_Related_Provider

ExR_Social_Prog

16.6.2

Varchar2(2)

Migrated from [Students]IL_ExR_Social_Prog

ExR_Speech

16.6.2

Varchar2(2)

Migrated from [Students]IL_ExR_Speech

ExR_Teacher

16.6.2

Varchar2(2)

Migrated from [Students]IL_ExR_Teacher

ExR_Use_Skills

16.6.2

Varchar2(2)

Migrated from [Students]IL_ExR_Use_Skills

ExR_Use_Skills_Prog

16.6.2

Varchar2(2)

Migrated from [Students]IL_ExR_Use_Skills_Prog

Family_Structure

16.6.2

Varchar2(2)

Migrated from [Students]IL_Family_Structure

Head_Start

16.6.2

Number(1,0)

Migrated from [Students]IL_Head_Start

IEP_Completion_Date

16.6.2

Date

Migrated from [Students]IL_IEP_Completion_Date

Local

16.6.2

Number(1,0)

Migrated from [Students]IL_Local

Meets_PFA_Criteria

16.6.2

Number(1,0)

Migrated from [Students]IL_Meets_PFA_Criteria

Meets_Risk_Criteria

16.6.2

Number(1,0)

Migrated from [Students]IL_Meets_Risk_Criteria

PreK_Title1

16.6.2

Number(1,0)

Migrates from [Students]IL_PreK_Title1

PreSchool_For_All

16.6.2

Varchar2(2)

Migrates from [Students]IL_PreSchool_For_All

Prevention_Initiative

16.6.2

Number(1,0)

Migrates from [Students]IL_Prevention_Initiative

Reason_For_Delay

16.6.2

Varchar2(2)

Migrates from [Students]IL_Reason_For_Delay

Referral_By_CFC

16.6.2

Number(1,0)

Migrates from [Students]IL_Referral_by_CFC

Head_Start_Funding

17.6.0

Varchar2(2)

New field for 2017-2018 Data Collection

IDEA_Services

17.6.0

Varchar2(2)

New field for 2017-2018 Data Collection

Preschool_For_All_Expansion

17.6.0

Varchar2(2)

New field for 2017-2018 Data Collection

Classroom_Location

17.6.0

Varchar2(2)

New field for 2017-2018 Data Collection

IDEA_Funding

17.6.0

Varchar2(2)

New field for 2017-2018 Data Collection

CPS_Value_Preschool

17.6.0

Varchar2(2)

New field for 2017-2018 Data Collection

Local_District_Funding

17.6.0

Varchar2(2)

New field for 2017-2018 Data Collection

Tuition_Based_Funding

17.6.0

Varchar2(2)

New field for 2017-2018 Data Collection

Household_Income_Criteria

17.6.0

Varchar2(2)

New field for 2017-2018 Data Collection

Inclusive_IEP_Services

17.6.0

Number(1,0)

New field for 2017-2018 Data Collection

Previous_Enr_Early_Childhood

17.6.0

Number(1,0)

New field for 2017-2018 Data Collection

Child_Care

17.6.0

Number(1,0)

New field for 2017-2018 Data Collection

Child_Welfare_Involvement

17.6.0

Number(1,0)

New field for 2017-2018 Data Collection

Child_Youth_Care

17.6.0

Number(1,0)

New field for 2017-2018 Data Collection

Child_Parent_Youth_Care

17.6.0

Number(1,0)

New field for 2017-2018 Data Collection

Open_Intact_Case

17.6.0

Number(1,0)

New field for 2017-2018 Data Collection

Receiving_TANF

17.6.0

Number(1,0)

New field for 2017-2018 Data Collection

Receiving_WIC

17.6.0

Number(1,0)

New field for 2017-2018 Data Collection

Receiving_SNAP

17.6.0

Number(1,0)

New field for 2017-2018 Data Collection

Receiving_Housing_Subsidy

17.6.0

Number(1,0)

New field for 2017-2018 Data Collection

Licensed_Child_Care

20.8.0

Varchar2(2)

New field for 2020-2021 Data Collection

Stu_Rec_CCAP_Subsidy

20.8.0

Varchar2(2)

New field for 2020-2021 Data Collection