PowerSchool SIS Illinois

S_IL_STU_Demographics_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.

Birth_Place

16.6.2

Varchar2(30)

Migrated from [Students]IL_Birth_Place

DOB_To_Delete

16.6.2

Date

Migrated from [Students]IL_DOB_To_Delete

FER

16.6.2

Varchar2(3)

Migrated from [Students]IL_FER

FN_To_Delete

16.6.2

Varchar2(30)

Migrated from [Students]IL_FN_To_Delete

Home_Language_Code

16.6.2

Varchar2(3)

Migrated from [Students]IL_Home_Language_Code

Legal_First_Name

16.6.2

Varchar2(30)

Migrated from [Students]IL_Legal_First_Name

Legal_Last_Name

16.6.2

Varchar2(30)

Migrated from [Students]IL_Legal_Last_Name

Legal_Middle_Name

16.6.2

Varchar2(30)

Migrated from [Students]IL_Legal_Middle_Name

Lineage_Code

18.7.0

Varchar2(4)

Migrated from [Students]IL_Lineage_Code

LN_To_Delete

16.6.2

Varchar2(30)

Migrated from [Students]IL_LN_To_Delete

Mother_Maiden_Name

16.6.2

Varchar2(30)

Migrated from [Students]IL_Mother_Maiden_Name

NELB

16.6.2

Varchar2(3)

Migrated from [Students]IL_NELB

SID_To_Delete

16.6.2

Varchar2(9)

Migrated from [Students]IL_SID_To_Delete

Prenatal_ID

20.5.2.0

Varchar2(9)

Stores the Prenatal ID of the student

Mother_Education_Received

22.2.2.0

Varchar2(2)

Stores Mother's education received

Mother_Employment_Status

22.2.2.0

Varchar2(2)

Stores Mother's employment status

Prenatal_RCDT_Grantee

22.2.2.0

Varchar2(11)

Stores RCDT for grantee