S_CO_STU_X (ver 16.6.2)
This table is an extension of the Students table and holds Colorado-specific state reporting fields.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 14.5.0 | Number (10,0) | Primary key that relates the extended table back to the Students table. |
AddHousingCrisis | Varchar2 (2) | Additional Cause of Housing Crisis | |
Attend_Info | 16.1.0 | Varchar2 (3) | Pupils Attendance/Residence Information. Migrated from [Students]Attend_Info. |
Bilingual | 17.3.0 | Varchar2 (1) | Bilingual Status; indicates whether the student is currently enrolled in a bilingual program, is in the monitoring period, or is exited. Migrated from [Students]CO_Bilingual. |
Colorado_Continuously | 16.1.0 | Varchar2 (1) | Colorado Continuously. Migrated from [Students]CO_ColoradoContinuously. |
Continuous_In_District | 16.1.0 | Varchar2 (1) | Continuous in District. Migrated from [Students]CO_ContinuousDistrict. |
Continuous_In_School | 16.1.0 | Varchar2 (1) | Continuous in School. Migrated from [Students]CO_ContinuousSchool. |
Contract_Agreement_3rdParty | 16.1.0 | Varchar2 (1) | Contractual Agreement with Third Party Educators/Programs. Migrated from [Students]CO_ContractAgreement3rdParty. |
County_Joint_District | 16.1.0 | Varchar2 (3) | County Code of Residence for Joint School Districts. Migrated from [Students]County_Joint_District. |
CSAP_Alternate_Assessment | 16.1.0 | Varchar2 (1) | County Code of Residence for Joint School Districts. Migrated from [Students]CO_CSAPAlternateAssessment. |
Date_First_Enrolled_US | 16.6.2 | Date | Date First Enrolled in US. |
Date_Recently_Enrolled_US | 16.1.0 | Date | Date Most Recently Enrolled in US. Migrated from [Students]CO_DateRecentlyEnrolledUS. |
DateRecentlyEnrolled_CO | 15.7.0 | Date | Date Most Recently Enrolled in CO School. |
Diploma_Type | 17.3.0 | Varchar2 (4) | The type of diploma achieved by the student. Migrated from [Students]CO_Diploma_Type. |
English_Learner | 16.1.0 | Varchar2 (4) | Language Background (English Language Learner). Migrated from [Students]CO_EnglishLearner. |
ESL | 17.3.0 | Varchar2 (1) | ESL Status; indicates whether the student is currently enrolled in an English as a Second Language program, is in the monitoring period, or is exited. Migrated from [Students]CO_ESL. |
Expelled | 16.1.0 | Varchar2 (1) | Expelled with Educational Services. Migrated from [Students]CO_Expelled. |
FacilityDetentionCode | 16.1.0 | Varchar2 (4) | Facility/Detention Code. Migrated from [Students]CO_FacilityDetentionCode. |
GED_Program | 17.3.0 | Varchar2 (1) | Attends District Funded HSED Program; indicates HSED funded using state funds either in the form of a district run HSED program or tuition paid, by the district, to an external HSED program. Migrated from [Students]CO_GED_Program. |
Gifted | 16.1.0 | Varchar2 (1) | Gifted/Talented. Migrated from [Students]CO_Gifted. |
Gifted_Creativity | 16.6.2 | Varchar2 (1) | Gifted Creativity. |
Gifted_Dance | 16.6.2 | Varchar2 (1) | Gifted Dance. |
Gifted_Drama_Theater | 16.6.2 | Varchar2 (1) | Gifted Drama Theater. |
Gifted_General_Intellect | 16.6.2 | Varchar2 (1) | Gifted General Intellect. |
Gifted_Leadership | 16.6.2 | Varchar2 (1) | Gifted Leadership. |
Gifted_Math | 16.6.2 | Varchar2 (1) | Gifted Math. |
Gifted_Musical | 16.6.2 | Varchar2 (1) | Gifted Musical. |
Gifted_Psychomotor | 16.6.2 | Varchar2 (1) | Gifted Psychomotor. |
Gifted_Reading | 16.6.2 | Varchar2 (1) | Gifted Reading. |
Gifted_Science | 16.6.2 | Varchar2 (1) | Gifted Science. |
Gifted_Social_Studies | 16.6.2 | Varchar2 (1) | Gifted Social Studies. |
Gifted_Visual_Arts | 16.6.2 | Varchar2 (1) | Gifted Visual Arts. |
Gifted_World_Language | 16.6.2 | Varchar2 (1) | Gifted World Language. |
Gifted_Writing | 16.6.2 | Varchar2 (1) | Gifted Writing. |
Grad_Date | 17.3.0 | Date | The date the student graduated from high school. Migrated from [Students]CO_Grad_Date. |
Handicapped_504 | 16.1.0 | Varchar2 (1) | Section 504 Handicapped. Migrated from [Students]Handicapped_504. |
HomeBasedEd | 15.7.0 | Number (1,0) | Home Based Education. |
Homeless | 17.3.0 | Varchar2 (1) | The student's Homeless Status. Migrated from [Students]CO_Homeless. |
HousingCrisis | Varchar2 (2) | Cause of Housing Crisis | |
IEP_EntryDate | 15.7.0 | Date | Special Education Entry Date. |
IEP_ExitDate | 15.7.0 | Date | Special Education Exit Date. |
Immigrant | 16.1.0 | Varchar2 (1) | Immigrant. Migrated from [Students]CO_Immigrant. |
IndependentStudy | 16.1.0 | Varchar2 (1) | Independent Study. Migrated from [Students]CO_IndependentStudy. |
Interventional_READ | 14.5.0 | Number (1,0) | READ Plan Support: Other intervention services during the school day. |
ISS_Language_Arts | 14.8.0 | Number (1,0) | Instructional Support Services: Language Arts. |
ISS_Math | 14.8.0 | Number (1,0) | Instructional Support Services: Mathematics. |
ISS_Other | 14.8.0 | Number (1,0) | Instructional Support Services: Other Support Services. |
ISS_Science | 14.8.0 | Number (1,0) | Instructional Support Services: Science. |
ISS_Social_Studies | 14.8.0 | Number (1,0) | Instructional Support Services: Social Studies. |
ISS_Vocational | 14.8.0 | Number (1,0) | Instructional Support Services: Vocational/Career. |
Kindergarten | 16.1.0 | Varchar2 (2) | Kindergarten Enrollment. Migrated from [Students]CO_Kindergarten. |
Kindergarten_READ | 14.5.0 | Number (1,0) | READ Plan Support: Full-day Kindergarten. |
LanguageProficiency | 17.3.0 | Varchar2 (1) | The student's Language Proficiency Status. Migrated from [Students]CO_LanguageProficiency. |
LIP | 17.8.0 | Varchar2 (2) | Language Instruction Program |
Migrant | 17.3.0 | Varchar2 (1) | Indicates whether the student participates in the migrant education program. Migrated from [Students]CO_Migrant. |
MilitaryConnected | 17.7.0 | Varchar2 (2) | Indicates whether the student is from a military family. |
MilitaryEnlisted | 20.7.2 | Varchar2 (1) | Military Enlisted |
NonSchoolPrgm | 17.8 | Varchar2 (2) | Indicates whether the student is enrolled in a program not run by the student's school. |
OrthopedicDisability | 16.1.0 | Varchar2 (1) | Orthopedic Disability. Migrated from [Students]CO_OrthopedicDisability. |
OtherHealthImpairment | 16.1.0 | Varchar2 (1) | Other Heath Impairment. Migrated from [Students]CO_OtherHealthImpairment. |
Parent_Res_County | 16.1.0 | Varchar2 (4) | Country Code of Parents Residence for Non-Resident Students. Migrated from [Students]CO_parent_res_country. |
Parent_Res_District | 16.1.0 | Varchar2 (5) | District of Parents Residence for Non-Resident Students. Migrated from [Students]CO_parent_res_district. |
Parent_Res_State | 16.1.0 | Varchar2 (2) | State Code of Parents Residence for Non-Resident Students. Migrated from [Students]CO_parent_res_state. |
PhysicalDisability | 16.1.0 | Varchar2 (1) | Physical Disability. Migrated from [Students]CO_PhysicalDisability. |
PostSecondaryProgram | 16.1.0 17.8.0 - type change | Varchar2 (11) | Post Secondary Program. Migrated from [Students]CO_PostSecondaryProgram. |
Primary_Disability | 16.1.0 | Varchar2 (2) | Primary Disability. Migrated from [Students]CO_PrimaryDisability. |
Primary_Night_Residence | 16.1.0 | Varchar2 (3) | Primary Nighttime Residence. Migrated from [Students]CO_PrimaryNightResidence. |
READ_Plan | 15.2.2 | Varchar2 (1) | READ Plan. |
Rec_Reten_READ | 14.5.0 | Varchar2 (2) | Recommended for Retention. Migrated from [Students]CO_Recommended_Retention. |
Refugee | 16.1.0 | Varchar2 (1) | Refugee. Migrated from [Students]CO_Refugee. |
Retained_READ | 14.5.0 | Varchar2 (2) | Retained. Migrated from [Students]CO_Retained. |
Retention_Code | 16.1.0 | Varchar2 (1) | Retention Code. Migrated from [Students]CO_RetentionCode. |
S1A_Institution | 17.5.0 | Number (11,0) | Semester 1A Institution Code. Migrated from [Students]CO_1stSemesterA_InstitutionCode. |
S1A_PSOA | 16.1.0 17.8.0 - type change | Varchar2 (11) | Semester 1A Other Post Secondary Enrollment Options Program. Migrated from [Students]CO_1stSemesterA_OtherPSOA. |
S1B_Institution | 16.1.0 | Number (11,0) | Semester 1B Institution Code. Migrated from [Students]CO_1stSemesterB_InstitutionCode. |
S1B_PSOA | 16.1.0 17.8.0 - type change | Varchar2 (11) | Semester 1B Other Post Secondary Enrollment Options Program. Migrated from [Students]CO_1stSemesterB_OtherPSOA. |
S2A_Institution | 16.1.0 | Number (11,0) | Semester 2A Institution Code. Migrated from [Students]CO_2ndSemesterA_InstitutionCode. |
S2A_PSOA | 16.1.0 17.8.0 - type change | Varchar2 (11) | Semester 2A Other Post Secondary Enrollment Options Program. Migrated from [Students]CO_2ndSemesterA_OtherPSOA. |
S2B_Institution | 16.1.0 | Number (11,0) | Semester 2B Institution Code. Migrated from [Students]CO_2ndSemesterB_InstitutionCode. |
S2B_PSOA | 16.1.0 17.8.0 - type change | Varchar2 (11) | Semester 2B Other Post Secondary Enrollment Options Program. Migrated from [Students]CO_2ndSemesterB_OtherPSOA. |
Score_READ | 14.5.0 | Varchar2 (4) | READ Score. Migrated from [Students]CO_CBLA_Score. |
SeniorExitCode | 17.3.0 | Varchar2 (2) | The student's anticipated graduate exit code. Migrated from [Students]CO_SeniorExitCode. |
SpecialEducation | 16.1.0 | Varchar2 (1) | Special Education. Migrated from [Students]CO_SpecialEducation. |
SPED_ProgramCode | 15.4.0 | Varchar2 (4) | SPED Program Code. |
SS_Guidance | 14.8.0 | Number (1,0) | Support Services: Supporting Guidance/Advocacy. |
SS_Health | 14.8.0 | Number (1,0) | Support Services: Health, Dental and Eye Care. |
SS_Other | 14.8.0 | Number (1,0) | Support Services: Other Support Services. |
StateLunchStatus | 17.3.0 | Varchar2 (2) | Indicates whether the student meets the eligibility criteria for free or reduced lunch pursuant to the provisions of the Federal National School Lunch Act. Migrated from [Students]CO_LunchStatus. |
Status_READ | 14.5.0 | Varchar2 (2) | Student Read Status. Migrated from [Students]CO_CBLA_Status. |
Status_For_Funding | 16.1.0 | Varchar2 (2) | Status for Public School Finance Act Funding. Migrated from [Students]status_for_funding. |
Summer_School_READ | 14.5.0 | Number (1,0) | READ Plan Support: Summer School. |
Test_Accom_READ | 14.5.0 | Varchar2 (2) | Allowable Testing Accommodations. Migrated from [Students]CO_CBLA_Accommodations. |
Test_Date_READ | 14.5.0 | Date | READ Test Date. Migrated from [Students]CO_READ_Testing_Date. |
Test_READ | 14.5.0 | Varchar2 (2) | READ Test. Migrated from [Students]CO_CBLA_Test. |
TitleI_TA_Participation | 17.3.0 | Varchar2 (1) | Indicates whether the student participates in the Title I Targeted Assistance Program. Note that the extended schema field name represents a correction to the prior legacy field name, which was incorrectly labeled as indicating Title I Schoolwide Participation. Migrated from [Students]CO_TitleI_SchoolWide. |
Transition | 16.1.0 | Varchar2 (1) | Transition from educational environments to life skills and/or vocational (for Special Education Students). Migrated from [Students]CO_Transition. |
Tutor_READ | 14.5.0 | Number (1,0) | READ Plan Support: Tutoring (before or after school). |
IndustryCertificate | 19.3.0 | Boolean | Industry Certificate Student. |
FreeLunchIden | 23.6.2.0 | NUMBER(11) | Free Lunch Eligibility Identification |
FOSTERCHILD | 24.8.1.0 | Boolean | Foster Child |
PROGRAMPARTICIPANT | 24.8.1.0 | Boolean | Confidentiality Program participant |
STATECODE | 24.8.1.0 | Varchar2 (50) | State Code |
COUNTYCODE | 24.8.1.0 | Varchar2 (50) | County Code |
TRACTCODE | 24.8.1.0 | Varchar2 (50) | Tract Code |
BLOCKCODE | 24.8.1.0 | Varchar2 (50) | Block Code |