Demographic, 166 (ver4.0.0)
This table is currently used only by the State Reporting process. Maintains information about person's demographics such as birth data and any special circumstances.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Birth_Cert_Verify_DT | 4.0.0 | Date | Date the certificate was verified. |
Birth_Certificate_Num | 4.0.0 | Varchar(40) | Birth Certificate File Number. |
Birth_City | 4.0.0 | Varchar(80) | City or town of birth. |
Birth_Country_CD | 4.0.0 | Varchar(10) | Country code as defined in SIF specification from CODE_ENTITY:Country. |
Birth_DT | 4.0.0 | Date | Date of birth. |
Birth_State_CD | 4.0.0 | Varchar(10) | Birth State. Should come from CODE_ENTITY:State. |
Citizenship_CD | 4.0.0 | Varchar(10) | Codes such as Dual National, Non-resident alien, United States Citizen from CODE_ENTITY:Citizenship. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Econom_Disadvantaged | 5.0.0 | Number(10,0) | Economically disadvantaged flag (0=No, 1=Yes). |
Gifted_YN | 4.0.0 | Number(10,0) | Is the student gifted or talented (0=No, 1=Yes). |
Home_Lang_CD | 4.0.0 | Varchar(10) | The Language spoken in the person's home country from CODE_ENTITY:HomeLang. |
Home_Schooled_YN | 4.0.0 | Number(10,0) | Is the student Home Schooled (0=No, 1=Yes). |
Homeless_YN | 4.0.0 | Number(10,0) | Is the student Homeless (0=No, 1=Yes). |
ID | 4.0.0 | Number(10,0) | A unique sequential number generated by the application. Indexed. |
Immigrant_YN | 4.0.0 | Number(10,0) | Is the student an Immigrant (0=No, 1=Yes). |
Lim_Eng_Prof | 5.0.0 | Number(10,0) | Limited English Proficiency flag (0=No, 1=Yes). |
Migrant_YN | 4.0.0 | Number(10,0) | Is the student a Migrant Student (0=No, 1=Yes). |
Primary_Lang_CD | 4.0.0 | Varchar(10) | The primary language spoken by the person from CODE_ENTITY:PrimaryLang. |
Single_Parent_YN | 4.0.0 | Number(10,0) | Is the student from a Single Parent Household (0=No, 1=Yes). |
StudentID | 4.0.0 | Number(10,0) | The internal number and ID of the associated Students record. |
Transient_YN | 4.0.0 | Number(10,0) | Is the student a transient of the State (0=No, 1=Yes). |
Ward_Of_State_YN | 4.0.0 | Number(10,0) | Is the student a Ward of the State (0=No, 1=Yes). |