S_TX_SCH_SCHOOLS_X (ver 24.5.2)
This table is an extension of the Schools table.
Column Name | Version | Data Type | Description |
---|---|---|---|
SchoolsDCID | 14.2.2 | Number(10,0) | Primary key that relates the extended table back to the [SCHOOLS] table. |
ADSY_Default_Minutes | 21.3.2.0 | Number(11,0) | Indicates the default Instructional Minutes for a typical ADSY program day. |
AdultEd_01 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers an Adult Education Program. Migrated from [Schools.TX_01AdultEd]. |
AltEd_02 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers an Alternative Education Program. Migrated from [Schools.TX_02AltEd]. |
Athletics_03 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers an Athletics Program. Migrated from [Schools.TX_03Athletics]. |
BilSum_40 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Bilingual Summer School Program. Migrated from [Schools.TX_40BilSum]. |
Bil_04 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Bilingual Program. Migrated from [Schools.TX_04Bil]. |
CBCC_Number | 15.10.3 | Varchar2(6) | Indicates the College Board/ACT Campus Number. Migrated from [Schools.CBCC_Number]. |
ChildFind_Placeholder | 21.8.2 | Number(1,0) | Selected if the school is a non-reportable Child Find Placeholder Campus. |
Closed_Campus | 19.5.1.0 | Number(1,0) | Selected if a prior, reportable school is now closed. |
Cocurricular_06 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a CoCurricular Program. Migrated from [Schools.TX_06CoCurricular]. |
CollegePrep_07 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a College Preparatory Program. Migrated from [Schools.TX_07CollegePrep]. |
ComEdProg_09 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Community/Junior College Education Program. Migrated from [Schools.TX_09ComEdProg]. |
Compensatory_10 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Compensatory Services for Disadvantaged Students Program. Migrated from [Schools.TX_10Compensatory]. |
ComServProg_08 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Community Service Program. Migrated from [Schools.TX_08ComServProg]. |
CounServ_11 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Counseling Services Program. Migrated from [Schools.TX_11CounServ]. |
CSW_Placeholder | 20.9.1 | Number(1,0) | Selected if the school is the Charter School Waitlist Placeholder Campus. |
CTE_05 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Career and Technical Education Program. Migrated from [Schools.TX_05CTE]. |
Default_Day_Minutes | 16.8.2 | Number(11,0) | The default number of minutes a school is in-session for a regular school day. |
E0894 | 15.10.3 | Varchar2(1) | Identifies the Title I Part A status of the school. Migrated from [Schools.E0894]. |
E1102 | 15.10.3 | Varchar2(30) | Obsolete field. Identifies the School Accountability Rating Title. Migrated from [Schools.E1102]. |
E1103 | 15.10.3 | Varchar2(35) | Obsolete field. Identifies the School Accountability Rating. |
E1358 | 15.10.3 | Varchar2(2) | Obsolete field. Identifies the School Category. Migrated from [Schools.E1358]. |
E1461 | 15.10.3 | Varchar2(9) | Obsolete field. Identifies the Year School Accountability Rating was awarded. Migrated from [Schools.E1461]. |
E1531 | 14.2.2 | Varchar2(2) | Obsolete field. Indicates the Fine Arts Category Code for the School. |
E1532 | 14.2.2 | Varchar2(2) | Obsolete field. Indicates the Wellness and Physical Ed Category Code for the School. |
E1533 | 14.2.2 | Varchar2(2) | Obsolete field. Indicates the Community and Parental Involvement Category Code for the School |
E1534 | 14.2.2 | Varchar2(2) | Obsolete field. Indicates the 21st Century Workforce Devel PGM Category Code for the School. |
E1535 | 14.2.2 | Varchar2(2) | Obsolete field. Indicates the Second Lang Acquisition PGM Category Code for the School. |
E1536 | 14.2.2 | Varchar2(2) | Obsolete field. Indicates the Digital Learning Environmental Category Code for the School. |
E1537 | 14.2.2 | Varchar2(2) | Obsolete field. Indicates the Dropout Prevention Strategies Category Code for the School. |
E1538 | 14.2.2 | Varchar2(2) | Obsolete field. Indicates the Educational PGM for GT Students Category Code for the School. |
E1539 | 14.2.2 | Varchar2(1) | Obsolete field. Indicates the Overall Rating Code for the school. |
E1540 | 14.2.2 | Varchar2(1) | Obsolete field. Indicates the Statutory Reporting and Policy Compliance Code for the School. |
E1555 | 14.7.2 | Varchar2(2) | Indicates the PK School Type for this school. |
E1559 | 15.7.3 | Number(1,0) | Indicates the Texas-Science, Technology, Engineering and Math status for this school. |
E1560 | 15.7.3 | Number(1,0) | Indicates the Early College High School status for this school. |
E1561 | 15.9.0 | Number(11,0) | Number of students reviewed by Individual Graduation Committee |
E1575_FirstCase | 17.2.0 | Varchar2(2) | Obsolete field. The first Community and Student Engagement category selected to be rated on in the next school year. |
E1576_SecondCase | 17.2.0 | Varchar2(2) | Obsolete field. The second Community and Student Engagement category selected to be rated on in the next school year. |
E1577_ThirdCase | 17.2.0 | Varchar2(2) | Obsolete field. The third Community and Student Engagement category selected to be rated on in the next school year. |
E1578_Case_Ratings_Link | 17.2.0 | Varchar2(200) | Obsolete field. The URL for the Community and Student Engagement ratings criteria that are used by the LEA and campuses to determine the ratings for the LEA and campuses. |
E1579_PK_Curricula | 20.6.2 | Varchar2(2) | Indicates the Pre-K Curricula for the School. |
E1580_High_Qual_PK_Prog | 17.2.0 | Number(1,0) | Indicates if the LEA receives funding for the High Quality Pre-K Program. |
E1581_NSLP_Code | 17.7.0 | Varchar2(2) | Indicator of a school's type of participation in the National School Lunch Program. |
E1604_Days_Taught_Week_1 | 20.6.2 | Number(11,0) | The number of days the PE class meets during the first week of October. |
E1605_Days_Taught_Week_2 | 20.6.2 | Number(11,0) | The number of days the PE class meets during the second week of October. |
E1606_Days_Taught_Week_3 | 20.6.2 | Number(11,0) | The number of days the PE class meets during the third week of October. |
E1607_Days_Taught_Week_4 | 20.6.2 | Number(11,0) | The number of days the PE class meets during the fourth week of October. |
E1608_Minutes_Taught_Week_1 | 20.6.2 | Number(11,0) | The number of minutes the PE class meets during the first week of October. |
E1609_Minutes_Taught_Week_2 | 20.6.2 | Number(11,0) | The number of minutes the PE class meets during the second week of October. |
E1610_Minutes_Taught_Week_3 | 20.6.2 | Number(11,0) | The number of minutes the PE class meets during the third week of October. |
E1611_Minutes_Taught_Week_4 | 20.6.2 | Number(11,0) | The number of minutes the PE class meets during the fourth week of October. |
E1671_ADSY_Indicator | 21.3.2.0 | Number(1,0) | Indicates that the school participates in the ADSY program. |
E1674_Charter_Enrolled_Stu | 23.10.1 | Number(11,0) | Holds the calculated Number of Students Enrolled in the Charter School on the Charter Waitlist Collection Snapshot date. |
E1675_Charter_Enroll_Cap | 20.7.2 | Number(11,0) | Indicates the number of students to which the charter school’s campus is able to provide instruction without exceeding staffing and facility limitations and the approved charter holder's maximum enrollment. |
E1676_Charter_Waitlist_Ind | 20.7.2 | Number(1,0) | Obsolete field as of August 2020. |
E1726 Child_Care_Operator | 23.8.1 | Varchar2(8) | The eight digit Child Care Operator number (school-level default); reported for the ECDS collection. |
ENABLE_ASSESSMENT_PORTAL | 21.4.2 | Number(1,0) | Indicates that the school allows parents and students to directly access the Texas State Assessment Portal via single sign-on |
GT_15 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Gifted and Talented Program. Migrated from [Schools.TX_15GT]. |
HeadStart_16 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Head Start Program. Migrated from [Schools.TX_16HeadStart]. |
HealthServProg_17 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Health Services Program. Migrated from [Schools.TX_17HealthServProg]. |
HSEP_18 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a High School Equivalency Program. Migrated from [Schools.TX_18HSEP]. |
IDEA_19 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers an IDEA Program. Migrated from [Schools.TX_19IDEA]. |
Immigrant_20 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers an Immigrant Education Program. Migrated from [Schools.TX_20Immigrant]. |
IndianEd_21 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers an Indian Education Program. Migrated from [Schools.TX_21IndianEd]. |
Instructional_Program_Type | 18.7.0 | Varchar2(2) | Indicates the type of Instructional program associated with the default school track 0. |
IntBacc_22 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers an International Baccalaureate Program. Migrated from [Schools.TX_22IntBacc]. |
LibServProg_23 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Library/Media Services Program. Migrated from [Schools.TX_23LibServProg]. |
Magnet_24 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Magnet/Special Program Emphasis Program. Migrated from [Schools.TX_24Magnet]. |
Migrant_25 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Migrant Education Program. Migrated from [Schools.TX_25Migrant]. |
NegDelProg_26 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Neglected and Delinquent Program. Migrated from [Schools.TX_26NegDelProg]. |
NoAccountability | 14.5.2 | Number(1,0) | Obsolete field. Indicates whether or not the accountability data is reported for this school. |
Non_Reportable_Campus | 18.7.0 | Number(1,0) | Identifies campuses that are not reportable to the state, but where students are scheduled into remote classes that are reportable. |
OFSDP_27 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Optional Flexible School Day Program. Migrated from [Schools.TX_27OFSDP]. |
Other_28 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers an Other Program. Migrated from [Schools.TX_28Other]. |
Placement504_31 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Section 504 Placement Program. Migrated from [Schools.TX_31504]. |
PrimarySchoolRecord | 24.5.2 | Number(1,0) | Identifies the one and only one school that “owns” the CDC number. |
RegEd_29 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Regular Education Program. Migrated from [Schools.TX_29RegEd]. |
Remedialed_30 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Remedial Education Program. Migrated from [Schools.TX_30RemedialEd]. |
ServLearn_32 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Service Learning Program. Migrated from [Schools.TX_32ServLearn]. |
Signature_Asset_ID | 20.7.2 | Number(11,0) | The Digital Signature Image ID of the Registrar selected for the School. |
SpecEd_33 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Special Education Program. Migrated from [Schools.TX_33SpecEd]. |
StuRetDOPrev_34 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Student Retention/Dropout Prevention Program. Migrated from [Schools.TX_34StuRetDOPrev]. |
SubAbEdPrev_35 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Substance Abuse Education/Prevention Program. Migrated from [Schools.TX_35SubAbEdPrev]. |
TchProfDev_36 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Teacher Professional Development/Mentoring Program. Migrated from [Schools.TX_36TchProfDev]. |
TechPrep_37 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Technical Preparatory Program. Migrated from [Schools.TX_37TechPrep]. |
TEDSSchoolName | 15.2.2 | Varchar2(60) | This field was originally used for the obsoleteTSDS Dashboards collection, and was re-purposed as of the 24.1.2 state reporting release to hold the reportable TEA CDC School Number when multiple PowerSchool schools share a TEA number. This field identifies the school that "owns" the CDC number. |
TitleI_38 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Title I Part A Program. Migrated from [Schools.TX_38TitleI]. |
UIL_Placeholder | 23.11.1 | Number(1,0) | Indicates that the school is the placeholder campus for Non-Enrolled UIL Participants. |
VocEd_39 | 15.10.3 | Number(1,0) | Obsolete field previously used for the TSDS Dashboards collection. Selected if the school offers a Vocational Education Program. Migrated from [Schools.TX_39VocEd]. |