S_TX_SCH_ELO_C (ver 19.12.1.0)
This table is a child of the Schools table and is used to capture the Expanded Learning Opportunities (ELO's) offered by the school each year.
Column Name | Version | Data Type | Description |
---|---|---|---|
SchoolsDCID | 19.12.1.0 | Number(11,0) | Primary key that relates the ELO table back to the [SCHOOLS] table. |
E1614_ELO_Type | 19.12.1.0 | Varchar2(2) | Indicates the type of expanded learning opportunity (ELO) program offered at the campus. |
E1615_ELO_Rig_Coursework | 20.3.2.0 | Number(1,0) | Indicates that the ELO Activity Code is Rigorous Coursework. |
E1616_ELO_Mentoring | 20.3.2.0 | Number(1,0) | Indicates that the ELO ELO Activity Code is Mentoring. |
E1617_ELO_Tutoring | 20.3.2.0 | Number(1,0) | Indicates that the ELO ELO Activity Code is Tutoring. |
E1618_ELO_Physical_Activity | 20.3.2.0 | Number(1,0) | Indicates that the ELO ELO Activity Code is Physical Activity. |
E1619_ELO_Academic_Support | 20.3.2.0 | Number(1,0) | Indicates that the ELO ELO Activity Code is Academic Support. |
E1620_ELO_Ed_Enrichment | 20.3.2.0 | Number(1,0) | Indicates that the ELO ELO Activity Code is Educational Enrichment. |
E1621_ELO_Minutes | 19.12.1.0 | Number(11,0) | Indicates the average number of minutes scheduled for an Expanded Learning Opportunity (ELO) each day. Obsolete as of the 2021-22 school year, and replaced by separate fields to capture the minutes for each ELO Activity. |
E1621_ELO_ACADSUPP_MIN | 21.9.2 | Number (11,0) | Average number of minutes per day for Academic Support. |
E1621_ELO_EDENRICH_MIN | 21.9.2 | Number (11,0) | Average number of minutes per day for Educational Enrichment. |
E1621_ELO_MENTOR_MIN | 21.9.2 | Number (11,0) | Average number of minutes per day for Mentoring. |
E1621_ELO_PHYSACT_MIN | 21.9.2 | Number (11,0) | Average number of minutes per day for Physical Activity. |
E1621_ELO_RIGCOURSE_MIN | 21.9.2 | Number (11,0) | Average number of minutes per day for Rigorous Coursework. |
E1621_ELO_TUTOR_MIN | 21.9.2 | Number (11,0) | Average number of minutes per day for Tutoring. |
E1720_ELO_ACADSUPP_DAYS | 21.9.2 | Number (11,0) | Number of days per year for Academic Support. |
E1720_ELO_EDENRICH_DAYS | 21.9.2 | Number (11,0) | Number of days per year for Educational Enrichment. |
E1720_ELO_MENTOR_DAYS | 21.9.2 | Number (11,0) | Number of days per year for Mentoring. |
E1720_ELO_PHYSACT_DAYS | 21.9.2 | Number (11,0) | Number of days per year for Physical Activity. |
E1720_ELO_RIGCOURSE_DAYS | 21.9.2 | Number (11,0) | Number of days per year for Rigorous Coursework. |
E1720_ELO_TUTOR_DAYS | 21.9.2 | Number (11,0) | Number of days per year for Tutoring. |
ELO_Description | 19.12.1.0 | Varchar2(1000) | The optional local description of the ELO. |
School_Year | 19.12.1.0 | Number(11,0) | The School Year to which the ELO applies; stored as the two-digit Term ID such as 29 for the 2019-20 school year. |