Skip to main content
Skip table of contents

S_TX_SCH_SCHOOLS_X (ver 14.2.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_Minutes21.3.2.0Number(11,0)Indicates the default Instructional Minutes for a typical ADSY program day.
AdultEd_0115.10.3Number(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_0215.10.3Number(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_0315.10.3Number(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_4015.10.3Number(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_0415.10.3Number(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_Number15.10.3Varchar2(6)Indicates the College Board/ACT Campus Number. Migrated from [Schools.CBCC_Number].
ChildFind_Placeholder21.8.2Number(1,0)Selected if the school is a non-reportable Child Find Placeholder Campus.
Closed_Campus19.5.1.0Number(1,0)Selected if a prior, reportable school is now closed.
Cocurricular_0615.10.3Number(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_0715.10.3Number(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_0915.10.3Number(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_1015.10.3Number(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_0815.10.3Number(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_1115.10.3Number(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_Placeholder20.9.1Number(1,0)Selected if the school is the Charter School Waitlist Placeholder Campus.
CTE_0515.10.3Number(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_Minutes16.8.2Number(11,0)The default number of minutes a school is in-session for a regular school day.
E089415.10.3Varchar2(1)Identifies the Title I Part A status of the school.  Migrated from [Schools.E0894].
E110215.10.3Varchar2(30)Obsolete field. Identifies the School Accountability Rating Title.  Migrated from [Schools.E1102].
E110315.10.3Varchar2(35)Obsolete field. Identifies the School Accountability Rating.  
E135815.10.3Varchar2(2)Obsolete field. Identifies the School Category.  Migrated from [Schools.E1358].
E146115.10.3Varchar2(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.

E154014.2.2Varchar2(1)Obsolete field. Indicates the Statutory Reporting and Policy Compliance Code for the School.
E155514.7.2Varchar2(2)Indicates the PK School Type for this school.
E155915.7.3Number(1,0)Indicates the Texas-Science, Technology, Engineering and Math status for this school.
E156015.7.3Number(1,0)Indicates the Early College High School status for this school.
E156115.9.0Number(11,0)Number of students reviewed by Individual Graduation Committee
E1575_FirstCase17.2.0Varchar2(2)Obsolete field. The first Community and Student Engagement category selected to be rated on in the next school year.
E1576_SecondCase17.2.0Varchar2(2)Obsolete field. The second Community and Student Engagement category selected to be rated on in the next school year.
E1577_ThirdCase17.2.0Varchar2(2)Obsolete field. The third Community and Student Engagement category selected to be rated on in the next school year.
E1578_Case_Ratings_Link17.2.0Varchar2(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_Curricula20.6.2Varchar2(2)Indicates the Pre-K Curricula for the School.
E1580_High_Qual_PK_Prog17.2.0Number(1,0)Indicates if the LEA receives funding for the High Quality Pre-K Program.
E1581_NSLP_Code17.7.0Varchar2(2)Indicator of a school's type of participation in the National School Lunch Program.
E1604_Days_Taught_Week_120.6.2Number(11,0)The number of days the PE class meets during the first week of October.
E1605_Days_Taught_Week_220.6.2Number(11,0)The number of days the PE class meets during the second week of October.
E1606_Days_Taught_Week_320.6.2Number(11,0)The number of days the PE class meets during the third week of October.
E1607_Days_Taught_Week_420.6.2Number(11,0)The number of days the PE class meets during the fourth week of October.
E1608_Minutes_Taught_Week_120.6.2Number(11,0)The number of minutes the PE class meets during the first week of October.
E1609_Minutes_Taught_Week_220.6.2Number(11,0)The number of minutes the PE class meets during the second week of October.
E1610_Minutes_Taught_Week_320.6.2Number(11,0)The number of minutes the PE class meets during the third week of October.
E1611_Minutes_Taught_Week_420.6.2Number(11,0)The number of minutes the PE class meets during the fourth week of October.
E1671_ADSY_Indicator21.3.2.0Number(1,0)Indicates that the school participates in the ADSY program.
E1674_Charter_Enrolled_Stu23.10.1Number(11,0)Holds the calculated Number of Students Enrolled in the Charter School on the Charter Waitlist Collection Snapshot date.
E1675_Charter_Enroll_Cap20.7.2Number(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_Ind20.7.2Number(1,0)

Obsolete field as of August 2020.

E1726 Child_Care_Operator23.8.1Varchar2(8)The eight digit Child Care Operator number (school-level default); reported for the ECDS collection.
ENABLE_ASSESSMENT_PORTAL21.4.2Number(1,0)Indicates that the school allows parents and students to directly access the Texas State Assessment Portal via single sign-on
GT_1515.10.3Number(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_1615.10.3Number(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_1715.10.3Number(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_1815.10.3Number(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_1915.10.3Number(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_2015.10.3Number(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_2115.10.3Number(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_Type18.7.0Varchar2(2)Indicates the type of Instructional program associated with the default school track 0.
IntBacc_2215.10.3Number(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_2315.10.3Number(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_2415.10.3Number(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_2515.10.3Number(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_2615.10.3Number(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_2715.10.3Number(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_2815.10.3Number(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_3115.10.3Number(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].
RegEd_2915.10.3Number(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_3015.10.3Number(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_3215.10.3Number(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_ID20.7.2Number(11,0)The Digital Signature Image ID of the Registrar selected for the School.
SpecEd_3315.10.3Number(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_3415.10.3Number(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_3515.10.3Number(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_3615.10.3Number(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_3715.10.3Number(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].
TEDSSchoolName15.2.2Varchar2(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_3815.10.3Number(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_Placeholder23.11.1Number(1,0)Indicates that the school is the placeholder campus for Non-Enrolled UIL Participants.
VocEd_3915.10.3Number(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].




JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.