S_TX_SCH_SCHOOLS_X (ver 24.5.2)

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].