S_CO_REN_X (ver 16.6.2)
This table is an extension of the Reenrollments table, and holds Colorado-specific state reporting fields.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ReenrollmentsDCID | 14.5.0 | Number (10,0) | System generated primary key. |
| Attend_Info | 14.8.0 | Varchar2 (3) | Pupils Attendance/Residence Information. |
| 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 [Reenrollments]CO_Bilingual. |
Colorado_Continuously | 14.8.0 | Varchar2 (1) | Colorado Continuously. |
Continuous_In_District | 14.8.0 | Varchar2 (1) | Continuous in District. |
| Continuous_In_School | 14.8.0 | Varchar2 (1) | Continuous in School. |
| Contract_Agreement_3RDParty | 14.8.0 | Varchar2 (1) | Contractual Agreement with Third Party Educators/Programs. |
| County_Joint_District | 14.8.0 | Varchar2 (3) | County Code of Residence for Joint School Districts. |
| CSAP_Alternate_Assessment | 14.8.0 | Varchar2 (1) | CSAP Alternate Assessment Participant. |
| Date_Recently_Enrolled_US | 14.8.0 | Date | Date Most Recently Enrolled in US. |
| DateRecentlyEnrolled_CO | 15.7.0 | Date | Date Most Recently Enrolled in CO School. |
| English_Learner | 14.8.0 | Varchar2 (4) | Language Background (English Language Learner). |
| 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 [Reenrollments]CO_ESL. |
| Expelled | 14.8.0 | Varchar2 (1) | Expelled with Educational Services. |
FacilityDetentionCode | 14.8.0 | Varchar2 (4) | Facility/Detention Code. |
| Gifted | 14.8.0 | Varchar2 (1) | Gifted/Talented. |
| 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. |
| Handicapped_504 | 14.8.0 | Varchar2 (1) | Section 504 Handicapped. |
| HomeBasedEd | 15.7.0 | Number (1,0) | Home Based Education. |
| Homeless | 17.3.0 | Varchar2 (1) | The student's Homeless Status. Migrated from [Reenrollments]CO_Homeless. |
| IEP_EntryDate | 15.7.0 | Date | Special Education Entry Date. |
| IEP_ExitDate | 15.7.0 | Date | Special Education Exit Date. |
| Immigrant | 14.8.0 | Varchar2 (1) | Immigrant. |
IndependentStudy | 14.8.0 | Varchar2 (1) | Independent Study. |
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: Reading/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 Instructional 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 | 14.8.0 | Varchar2 (2) | Kindergarten Enrollment. |
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 [Reenrollments]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 [Reenrollments]CO_Migrant. |
| NonSchoolPrgm | 17.8 | Varchar2 (2) | Indicates whether the student is enrolled in a program not run by the student's school. |
OrthopedicDisability | 14.8.0 | Varchar2 (1) | Orthopedic Disability. |
OtherHealthImpairment | 14.8.0 | Varchar2 (1) | Other Heath Impairment. |
| Parent_Res_Country | 14.8.0 | Varchar2 (4) | Country Code of Parents Residence for Non-Resident Students. |
| Parent_Res_District | 14.8.0 | Varchar2 (5) | District of Parents Residence for Non-Resident Students. |
| Parent_Res_State | 14.8.0 | Varchar2 (2) | State Code of Parents Residence for Non-Resident Students. |
PhysicalDisability | 14.8.0 | Varchar2 (1) | Physical Disability. |
| PostSecondaryProgram | 15.7.0 17.8.0 - type change | Varchar2 (11) | Post Secondary Program. |
| Primary_Disability | 14.8.0 | Varchar2 (2) | Primary Disability. |
| Primary_Night_Residence | 14.8.0 | Varchar2 (3) | Primary Nighttime Residence. |
| READ_Plan | 15.2.2 | Varchar2 (1) | READ Plan. |
Rec_Reten_READ | 14.5.0 | Varchar2 (2) | Recommended for Retention. |
| Refugee | 14.8.0 | Varchar2 (1) | Refugee. |
Retained_READ | 14.5.0 | Varchar2 (2) | Retained. |
| Retention_Code | 14.8.0 | Varchar2 (1) | Retention Code. |
| S1A_Institution | 15.7.0 | Number (11,0) | Semester 1A Institution Code. |
| S1A_PSOA | 15.7.0 17.8.0 - type change | Varchar2 (11) | Semester 1A Other Post Secondary Enrollment Options Program. |
| S1B_Institution | 15.7.0 | Number (11,0) | Semester 1B Institution Code. |
| S1B_PSOA | 15.7.0 17.8.0 - type change | Varchar2 (11) | Semester 1B Other Post Secondary Enrollment Options Program. |
| S2A_Institution | 15.7.0 | Number (11,0) | Semester 2A Institution Code. |
| S2A_PSOA | 15.7.0 17.8.0 - type change | Varchar2 (11) | Semester 2A Other Post Secondary Enrollment Options Program. |
| S2B_Institution | 15.7.0 | Number (11,0) | Semester 2B Institution Code. |
| S2B_PSOA | 15.7.0 17.8.0 - type change | Varchar2 (11) | Semester 2B Other Post Secondary Enrollment Options Program. |
Score_READ | 14.5.0 | Varchar2 (4) | READ Score. |
| SpecialEducation | 14.8.0 | Varchar2 (1) | Special Education. |
| SPED_ProgramCode | 15.4.0 | Varchar2 (4) | SPED Program Code. |
| SS_Guidance | 14.8.0 | Number (1,0) | Support Services: 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 [Reenrollments]CO_LunchStatus. |
| Status_For_Funding | 14.8.0 | Varchar2 (2) | Status for Public School Finance Act Funding. |
Status_READ | 14.5.0 | Varchar2 (2) | Student READ Status. |
Summer_School_READ | 14.5.0 | Number (1,0) | READ Plan Support: Summer School. |
Test_Accom_READ | 14.5.0 | Varchar2 (2) | READ - Allowable Testing Accommodations. |
Test_Date_READ | 14.5.0 | Date | READ Testing Date. |
Test_READ | 14.5.0 | Varchar2 (2) | READ 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 [Reenrollments]CO_TitleI_SchoolWide. |
| Transition | 14.8.0 | Varchar2 (1) | Transition from educational environments to life skills and/or vocational (for Special Education Students). |
Tutor_READ | 14.5.0 | Number (1,0) | READ Plan Support: Tutoring (before or after school). |