S_NY_STU_DEMOGRAPHICS_X (ver 15.9.0)
This table is an extension of the Students table and holds demographic information for students in New York.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 15.9.0 | NUMBER(10,0) | Primary key and also the foreign key that relates the extension table to the [Students] table. |
Career_Path | 16.9.0 | VARCHAR2(20) | The code for the student's career path. |
| Homeless | 16.1.0 | NUMBER(1,0) | Indicates if the student is homeless or not. Migrates from [Students]Homeless. |
| Immigrant | 16.1.0 | NUMBER(1,0) | Indicates if the student is an immigrant or not. Migrates from [Students]Immigrant. |
| Migrant | 16.1.0 | NUMBER(1,0) | Indicates if the student is considered a migrant or not. Migrates from [Students]Immigrant. |
| NighttimeResidence | 16.1.0 | VARCHAR2(1) | Indicates a homeless student's nighttime living situation. Migrates from [Students]NighttimeResidence. |
| BirthCity | 16.1.0 | VARCHAR2(50) | The city or town where the student was born. Migrates from [Students]NY_BirthCity. |
| BirthCountry | 16.1.0 | VARCHAR2(50) | The country where the student was born. Migrates from [Students]NY_BirthCountry. |
| BirthRegion | 16.1.0 | VARCHAR2(50) | The province or region where the student was born if born outside the U.S. Migrates from [Students]NY_BirthRegion. |
| BirthState | 16.1.0 | VARCHAR2(2) | The state where the student was born, if the student was born in the United States. Migrates from [Students]NY_BirthState. |
| Delinquent | 16.1.0 | NUMBER(1,0) | Indicates if the student is considered delinquent or not. Migrates from [Students]NY_Delinquent. |
| DistrictOfResidenceOverride | 16.1.0 | VARCHAR2(8) | The student's overridden district of residence code. Migrates from [Students]NY_DOR_Override. |
| ELLDuration | 16.1.0 | NUMBER(11,0) | The cumulative number of years the student has received LEP services. Migrates from [Students]NY_ELL_Length. |
| OriginCountry | 16.1.0 | VARCHAR2(4) | The country the student emigrated from if identified as an immigrant and born outside the U.S. Migrates from [Students]NY_OriginCountry. |
| YearsInUSSchools | 16.1.0 | NUMBER(11,0) | The number of years this student has attended a U.S school. Migrates from [Students]NY_YrsUSSchools. |
| Guidance_Counselor | 17.8.0 | NUMBER(11,0) | Saves the ‘ID’ of the Counselors from S_NY_SCH_COUNSELOR_C table |
| County_Of_Residence | 17.8.0 | VARCHAR2(160) | County of residence (Description stored in common code table) |
| Education_Level_Of_Parent | 17.8.0 | VARCHAR2(60) | Education Level of Parent (Description stored in common code table) |
| Crisis_Impact_Code | 17.8.0 | VARCHAR2(80) | Crisis Impact Code (Student Displaced By Disaster) (Description stored in common code table) |
| Crisis_Name | 17.8.0 | VARCHAR2(200) | Crisis Name (Disaster Name) (Description stored in common code table) |