S_CO_SCH_X (ver 14.8.0)
This table is an extension of the Schools table, and holds Colorado-specific state reporting fields.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SchoolsDCID | 14.8.0 | Number (10,0) | System generated primary key. |
Advanced_Placement_Flag | 14.8.0 | Varchar2 (1) | Advanced Placement. Migrated from [Schools]CC_Advanced_Placement_Flag. |
Art_Flag | 14.8.0 | Varchar2 (1) | Visual Art. Migrated from [Schools]CO_Art_Flag. |
Asst_Out_School_Youth | 14.8.0 | Varchar2 (1) | Assistance Of Out-Of School Youth To Re-Enroll. Migrated from [Schools]CO_Asst_Out_School_Youth. |
Athletics_Flag | 14.8.0 | Varchar2 (1) | Athletics. Migrated from [Schools]CO_Athletics_Flag. |
Blendedlearn | 16.3.2 | Varchar2 (2) | Blended Learning. |
Blendedlearn_TF | 16.1.0 | Number (1,0) | Deprecated. |
| BP_BiennialSrvy | 21.3.1.0 | Varchar2 (1) | |
| BP_BullyPrevTm | 21.3.1.0 | Varchar2 (1) | |
| BP_Consequences | 21.3.1.0 | Varchar2 (1) | |
| Bully_Policy | 17.3.0 | Varchar2 (1) | Bullying Policy. Indicates whether the school meets all components of bullying policy. New 2016-17 field for Report Card March. |
| Bully_Prevention_BPPBIS | 17.3.0 | Varchar2 (1) | Bully Prevention - BP-PBIS. Indicates whether indicates whether the school uses Bully Prevention in Positive Behavioral Interventions and Supports (BP-PBIS) as evidence based bullying program. New 2016-17 field for Report Card March. |
| Bully_Proofing_PBYS | 17.3.0 | Varchar2 (1) | Bully Proofing - BPYS. Indicates whether indicates whether the school uses Bully Proofing Your School (BPYS) as evidence based bullying program. New 2016-17 field for Report Card March. |
Career_Tech_Ed_Flag | 14.8.0 | Varchar2 (1) | Career And Technical Education. Migrated from [Schools]CO_Career_Tech_Ed_Flag. |
CB_ACT_ID | 17.5.0 | Varchar2 (6) | Collegeboard / ACT School ID. Migrated from [Schools]CB_ACT_ID. |
| CDHSCode | 20.9.3.0 | Number(11,0) | TEXT NEEDED |
| CityID | 20.9.3.0 | Number(11,0) | TEXT NEEDED |
Civic_Comm_Engagement | 14.8.0 | Varchar2 (1) | Opportunities For Civic Or Community Engagement. Migrated from [Schools]CO_Civic_Comm_Engagement. |
Civics_Flag | 14.8.0 | Varchar2 (1) | Civics. Migrated from [Schools]CO_Civics_Flag. |
Comp_Health_Ed | 14.8.0 | Varchar2 (1) | Comprehensive Health Education. Migrated from [Schools]CO_Comp_Health_Ed. |
Concur_Enroll_School_Flag | 14.8.0 | Varchar2 (1) | Concurrent Enrollment Classes On School Property. Migrated from [Schools]CO_Concur_Enroll_School_Flag. |
| CountyID | 20.9.3.0 | Number(11,0) | TEXT NEEDED |
Credit_Recovery_Programs_Flag | 14.8.0 | Varchar2 (1) | Credit Recovery Programs. Migrated from [Schools]CO_Credit_Recovery_Programs_Flag. |
Dance_Flag | 14.8.0 | Varchar2 (1) | Dance. Migrated from [Schools]CO_Dance_Flag. |
Drama_Theatre_Flag | 14.8.0 | Varchar2 (1) | Drama Or Theatre. Migrated from [Schools]CO_Drama_Theatre_Flag. |
Economics_Flag | 14.8.0 | Varchar2 (1) | Economics. Migrated from [Schools]CO_Economics_Flag. |
Flexschedule | 16.3.2 | Varchar2 (2) | Flexible Schedule Flag. |
Flexschedule_TF | 16.1.0 | Number (1,0) | Deprecated. |
Fullday_Kinder_Flag | 14.8.0 | Varchar2 (1) | Full-Day Kindergarten Program. Migrated from [Schools]CO_Fullday_Kinder_Flag. |
Geography_Flag | 14.8.0 | Varchar2 (1) | Geography. Migrated from [Schools]CO_Geography_Flag]. |
Health_Ed_Required | 14.8.0 | Varchar2 (1) | Comprehensive Health Education Required. Migrated from [Schools]CO_Health_Ed_Required. |
Health_Wellness_Flag | 14.8.0 | Varchar2 (1) | School Health Team Or School Wellness Committee. Migrated from [Schools]CO_Health_Wellness_Flag. |
| HistandOurselves | 21.3.1.0 | Varchar2 (1) | |
History_Flag | 14.8.0 | Varchar2 (1) | History. Migrated from [Schools]CO_History_Flag. |
| Home_Grown_Program | 17.3.0 | Varchar2 (1) | Home Grown Program. Indicates whether indicates whether the school uses a Home Grown bullying program as evidence based bullying program. New 2016-17 field for Report Card March. |
| Home_Grown_Specify | 17.3.0 | Varchar2 (50) | If Home Grown, specify. If Home Grown Program is reported as yes, the name the home grown program is patterned after. New 2016-17 field for Report Card March. |
Honors_Courses_Flag | 14.8.0 | Varchar2 (1) | Honors Courses. Migrated from [Schools]CO_Honors_Courses_Flag. |
Immediateprogtograd | 16.3.2 | Varchar2 (2) | Immediate Progress Towards Graduation Flag. |
Immediateprogtograd_TF | 16.1.0 | Number (1,0) | Deprecated. |
International_Bac_Flag | 14.8.0 | Varchar2 (1) | International Baccalaureate. Migrated from [Schools]CO_International_Bac_Flag. |
Internet_Safety_Flag | 14.8.0 | Varchar2 (1) | Internet Safety Programs. Migrated from [Schools]CO_Internet_Safety_Flag. |
K6_Recess_Flag | 14.8.0 | Varchar2 (1) | Physical Activity. Migrated from [Schools]CO_K6_Recess_Flag. |
Library_Flag | 14.8.0 | Varchar2 (1) | Library. Migrated from [Schools]CO_Library_Flag. |
Montessori_Curricula_Flag | 14.8.0 | Varchar2 (1) | Montessori Curricula. Migrated from [Schools]CO_Montessori_Curricula_Flag. |
Music_Flag | 14.8.0 | Varchar2 (1) | Music. Migrated from [Schools]CO_Music_Flag. |
Nces_Id | 14.8.0 | Varchar2 (32) | NCES School ID. Migrated from [Schools]NCES_ID. |
Newcomercenter | 16.3.2 | Varchar2 (2) | Newcomer Center Flag. |
Newcomercenter_TF | 16.1.0 | Number (1,0) | Deprecated. |
| Olweus_BPP | 17.3.0 | Varchar2 (1) | Olweus Bully Prevention- BPP. Indicates whether indicates whether the school uses Olweus Bully Prevention Program (BPP) as evidence based bullying program. New 2016-17 field for Report Card March. |
| Other_Bully_Program | 17.3.0 | Varchar2 (1) | Other Flag (Other Bully Program). Indicates whether indicates whether the school uses another bullying program as evidence based bullying program.. New 2016-17 field for Report Card March. |
| Other_Bully_Program_Specify | 17.3.0 | Varchar2 (50) | If Other, specify (Other Bully Program). If the Other Flag is reported as yes, the name the program is patterned after. New 2016-17 field for Report Card March. |
Participates_Fed_Sch_Breakfst | 16.5.0 | Varchar2 (1) | Uses Federal School Breakfast Program In Classroom. Migrated from [Schools]CO_Participates_Fed_School_Breakfast_Flag. |
Participates_Fed_School_Breakfast_Flag | 14.8.0 | Varchar2 (1) | Deprecated And Replaced By Participates_Fed_Sch_Breakfst. |
Phys_Ed_Flag | 14.8.0 | Varchar2 (1) | Physical Education. Migrated from [Schools]CO_Phys_Ed_Flag. |
Phys_Ed_Required | 14.8.0 | Varchar2 (1) | Physical Education Is Required (All Students). Migrated from [Schools]CO_Phys_Ed_Required. |
Preschool_Program | 14.8.0 | Varchar2 (1) | Preschool Program. Migrated from [Schools]CO_Preschool_Program. |
Professional_Dev_Days | 14.8.0 | Varchar2 (3) | Professional Development Days (Ex. 5.5). Migrated from [Schools]CO_Professional_Dev_Days. |
| Promote_Alternative_PATHS | 17.3.0 | Varchar2 (1) | Promoting Alternative Thinking Strategies- PATHS. Indicates whether indicates whether the school uses Promoting Alternative Thinking Strategies (PATHS) as evidence based bullying program. New 2016-17 field for Report Card March. |
Registered_Nurse_On_Premises_Flag | 14.8.0 | Varchar2 (1) | Deprecated And Replaced By RN_On_Premises_Flag. |
Rn_On_Premises_Flag | 16.5.0 | Varchar2 (1) | CDE Licensed School Nurse Is Available During School Hours. Migrated from [Schools]CO_Registered_Nurse_On_Premises_Flag. |
School_Care_Programs | 14.8.0 | Varchar2 (1) | Before And After School Care Programs. Migrated from [Schools]CO_School_Care_Programs. |
School_Linked_Health_Center | 14.8.0 | Varchar2 (1) | School Based Health Center. Migrated from [Schools]CO_School_Linked_Health_Center. |
School_Year_Length | 14.8.0 | Varchar2 (5) | Length Of School Year (Ex. 185.5). Migrated from [Schools]CO_School_Year_Length. |
| Second_Step | 17.3.0 | Varchar2 (1) | Second Step. Indicates whether indicates whether the school uses Second Step as evidence based bullying program. New 2016-17 field for Report Card March. |
| Steps_To_Respect | 17.3.0 | Varchar2 (1) | Steps to Respect. Indicates whether indicates whether the school uses Steps to Respect as evidence based bullying program. New 2016-17 field for Report Card March. |
Title_I_Status | 14.8.0 | Number (1,0) | Title I Targeted Assistance. |
Workedexperiences | 16.3.2 | Varchar2 (2) | Work-Based Educational Experiences Flag. |
Workedexperiences_TF | 16.1.0 | Number (1,0) | Deprecated. |
World_Languages_Flag | 14.8.0 | Varchar2(1) | World Languages Flag. Migrated from [Schools]CO_World_Languages_Flag. |
Xtra_Activities_Flag | 14.8.0 | Varchar2 (1) | Extracurricular Activities. Migrated from [Schools]CO_Xtra_Activities_Flag. |
Year_Round_School | 14.8.0 | Varchar2 (1) | Year Round School. Migrated from [Schools]CO_Year_Round_School. |
| CovidResLearningDays | 21.11.1.0 | Varchar2(5) | COVID Response Remote Learning Days |
| BP_ProhibitBullying | 24.3.2.0 | Varchar2(1) | Report Card March Prohibit Bullying Flag |
| BP_DefineBullying | 24.3.2.0 | Varchar2(1) | Report Card March Define Bullying Flag |
| BP_PrevIntervention | 24.3.2.0 | Varchar2(1) | Report Card March Prevention and Intervention Flag |
| BP_Reporting | 24.3.2.0 | Varchar2(1) | Report Card March Reporting Flag (24.3.2.0) |
| BP_InvestResponding | 24.3.2.0 | Varchar2(1) | Report Card March Investigating and Responding Flag |
| BP_SupportsReferrals | 24.3.2.0 | Varchar2(1) | Report Card March Supports and Referrals Flag |