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 |