Skip to main content
Skip table of contents

Organization Catalog

localEducationAgencies

This view captures a list of Texas districts defined on the PowerSchool server. The layout includes the School Name, District ID, District Name, Last Publish Date, Publishing ID, and Resource ID.

eSP Source Data

Tables: REG_DISTRICT (rd), reg_user_district (rud)

Selection Criteria

(same as Base Profile): One record published for each distinct district where rd.validation_only = 'N'

Resource Output

  • The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.

  • LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

This resource represents an administrative unit at the local level, which exists primarily to operate schools or to contract for educational services. It includes school districts, charter schools, charter management organizations, or other local administrative organizations.

Category

Resource

Data Element

Description

TX Element

TX Element Name

eSP Source

Required?

Comments

Organization Catalog

 

 

 

 

 

 

localEducationAgencies

 

 

Tables:  REG_DISTRICT (rd), reg_user_district (rud)

Y

addresses

[Array}

Y

addressType

hard coded

Y

Publishes '02' Physical

streetNumberName

coalesce(rd.street1, 'No Address Available')

Y

trim(regexp_substr((select to_char(value) from prefs where name like 'DistrictAddress'), '[^,]+'))

apartmentRoomSuiteNumber

rd.street2 as apartmentRoomSuiteNumber,

N

trim(regexp_substr((select to_char(value) from prefs where name like 'DistrictAddress'), '[^,]+', 1, 2))

city

coalesce(rd.city, 'No City Available')

Y

stateAbbreviation

rd.state

Y

postalCode

coalesce(trim(rd.zip), 'No Zip Code')

Y

categories.educationOrganizationCategory

'02'

Y

02 = Local Education Agency

identificationCodes

[Array}

N

EducationOrganizationIdentificationSystemDescriptor

hard coded

Y

Publishes'SEA'; LEA

IdentificationCode

SEA: rd.state_code_equiv
LEA: rd.district

Y

SEA - only if not null
LEA - rd.district should never be null

localEducationAgencyCategoryDescriptor

E3019

Y

'01' for School District, '02' for Charter

localEducationAgencyId

E0212

DISTRICT-ID

coalesce(rd.state_code_equiv, rd.district)

Y

Formatted, publish integer value

nameOfInstitution

E3037

rd.name

Y

TX extensions

 

 

 

armedServicesVocAptBatteryIndicatorDescriptor

E1625

ARMED-SERVICES-VOC-APT-BATTERY-INDICATOR-CODE

rud.field_value where rud.screen_number ='11110', rud.field_number = '18'

TX

'00' ASVAB not offered; '01' ASVAB offered; '02' alternative career exploration test offered

familyEngagementPlanLink

E1583

FAMILY-ENGAGEMENT-PLAN-LINK

rud.field_value where rud.screen_number ='11110', rud.field_number = '17'

TX

totalCostSchoolBoardRequests

E1557

TOTAL-COST-SCHOOL-BOARD-REQUESTS

rud.field_value where rud.screen_number ='11110', rud.field_number = '12'

TX

totalNumSchoolBoardRequests

E1556

TOTAL-NUM-SCHOOL-BOARD-REQUESTS

rud.field_value where rud.screen_number ='11110', rud.field_number = '11'

TX

pkProgramEvaluationTypeDescriptor

E1626

PROGRAM-EVALUATION-TYPE

REG_USER_DISTRICT where screen_number = 10170, field_number = 2

TX

giftedTalentedPrograms

[Array]

TX

     giftedTalendedProgramDescriptor

E1645

GIFTED-TALENTED-PROGRAM-CODE

rud.field_value where rud.screen_number ='11114', rud.field_number = '1' through '6'

TX

Field number 1 - 00 - No Gifted/Talented Programs
Field number 2 - 01 - Pull Out
Field number 3 - 02 - Push In
Field number 4 - 03 - Full-time Gifted Only
Field number 5 - 04 - Full-time Inclusion
Field number 6 - 05 - Special Day Schoool 

programOfStudies

[Array]

TX

     programOfStudyDescriptor

E1643

PROGRAM-OF-STUDY

txtb_c220.code where txtb_c220.report_to_tsds = 'Y'

TX

Descriptor codes 001 - 018 not mutually exclusive, report all that apply in array

additional fields for display only

 

 

 

'LEA Office'

district view only

schools

 This view captures a detailed list of schools defined in PowerSchool. The layout includes the School Name, State Organization ID, State School Number, Last Publish Date, Publishing ID, and Resource ID.

This resource represents an educational organization that includes staff and students who participate in classes and educational activity groups.

eSP Source Data

Tables: Reg_Building (rb), Reg_Building_Grade (rbg), regtb_bldg_types rbt, Reg_User_Building (rub)

Publishing adds TX extension data to record in ODS (populated by TEA and downloaded)


Selection Criteria

One record published for each school (rb) where:

  • rb.district = rd.district

  • rbt.code = rb.building_type

  • rb.transfer_building = 'N'

  • rb.out_of_district = 'N'

Resource Output

  • The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.

  • LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Resource

Data Element

Description

TX Element

TX Element Name

eSP Source

Required?

Comments

addresses

Y

Array

addressType

hard coded

Y

Publishes '02' Physical

streetNumberName

coalesce(rb.street1, 'No Address Available')

Y

apartmentRoomSuiteNumber

rb.street2

N

city

coalesce(rb.city, 'No City Available')

Y

stateAbbreviation

coalesce(rb.state, reg_district.state)

Y

postalCode

coalesce(trim(rb.zip), 'No Zip Code')

Y

categories

eucationOrganizationCategoryDescriptor

E3037

'03'

Y

03 = School

gradeLevels

[Array}

Y

Publishes all grade levels between sch.low_grade and sch.high_grade

gradeLevelDescriptor[1..n]

rbg.grade, all grades in table for each school

Y

schoolId

E0266

CAMPUS-ID

coalesce(rb.state_code_equiv, rb.building)

Y

localEducationAgencyReference

E0212

DISTRICT-ID

coalesce(rd.state_code_equiv, rd.district)

TX

identificationCodes

[Array}

N

EducationOrganizationIdentificationSystemDescriptor

'LEA'; 'SEA'

Y

IdentificationCode

SEA: rb.state_code_equiv
LEA: rb.building

Y

SEA - only if not null
LEA - rb.building should never be null

institutionTelephones

[Array}

N

Publish main and Fax

institutionTelephoneNumberTypeDescriptor

'Main'; 'Fax'

Y

telephoneNumber

rb.phone; rb.fax

Y

nameOfInstitution

E3037

rb.name

Y

displayed in district view only

schoolCategoryDescriptor

rb.building_type

N

shortNameOfInstitution

rb.abbreviation

N

TX extensions

 

 

 

For each school, TX extension elements are published only if the school is the reporting school for its TX state school identifier.
When multiple buildings share the same TX Campus ID (REG_BUILDING.State_Code_Equiv), the reporting school does not have:
REG_USER_BUILDING.Field_Value = 'N' where screen_number = 101, field_number = 5

additionalDaysProgram

E1671

ADDITIONAL-DAYS-PROGRAM-INDICATOR-CODE

Stored at the calendar level. If a calendar within a building has a day type flagged as Additional Days School Year program, the building gets flagged for the Additional Days program.

TX

The code snippet used to determine the ADSY Indicator: select *
from reg_cal_days
inner join regtb_day_type on reg_cal_days.district = regtb_day_type.district
and reg_cal_days.day_type = regtb_day_type.code
inner join reg_building on reg_building.district = reg_cal_days.district
and reg_building.building = reg_cal_days.building
where reg_cal_days.district = @intDistrict
and regtb_day_type.state_code_equiv = 'ADSY'
and reg_cal_days.school_year = @intSchoolYear - If this count is greater than 0, building is ADSY.

pkFullDayWaiver

E1646

PK-FULL-DAY-WAIVER-INDICATOR-CODE

rub.field_value where rub.screen_number ='101', rub.field_number = '25'

TX

expandedLearningOpportunity

E1613

EXPANDED-LEARNING-OPPORTUNITY-INDICATOR-CODE

if any records exist in rub.screen_number = '10120', field_number = '1' and ELO exists for at least one campus in the LEA

TX

Added back in Dec 1 spec, indicates at least one ELO record for the current school year.

numberOfBullyingIncidents

E1727

NUMBER-OF-BULLYING-INCIDENTS

DISC_INCIDENT, DISC_INCIDENT_CODE, state code equiv = 61

TX

select count(*) from DISC_INCIDENT a
inner join DISC_INCIDENT_CODE b
on a.INCIDENT_CODE = b.CODE
and b.STATE_CODE_EQUIV = '61' -- bullying incidents
and a.SCHOOL_YEAR = 'current school year'

numberOfCyberBullyingIncidents

E1728

NUMBER-OF-CYBERBULLYING-INCIDENTS

DISC_USER.FIELD_VALUE = 'Y' where Screen_number 1, field_number 2

TX

Sum number of cyber bullying incidents for school year

campusEnrollmentTypeSets

[Array]

TX

     campusEnrollmentTypeDescriptor

E1641

CAMPUS-ENROLLMENT-TYPE-CODE

rub.field_value where rub.screen_number ='101', rub.field_number = '27'

TX

building user screen 101 currenlty allows only one entry (rub.list_sequence = 1 all cases)

     beginDate

E3010

Not stored in eSP, use school year start date

TX

TEA: May be in prior year

     endDate

E3020

day after lastl day of school year term

TX

TEA: Day after last day of applicability

charterWaitListSet

[Array]

TX

Students are pre-registered in campus they are waitlisted for.  Have student screen to show students waitlisted.
Changed from array to single complex without dates, Jul 2023 spec.

     numberCharterStudentsEnrolled

E1674

NUMBER-CHARTER-STUDENTS-ENROLLED

rub.field_value where rub.screen_number ='10130', rub.field_number = '1'

TX

building user screen 10130 currenlty allows only one entry (rub.list_sequence = 1 all cases)

     charterEduEnrollmentCapacity

E1675

CHARTER-EDUCATIONAL-ENROLLMENT-CAPACITY

rub.field_value where rub.screen_number ='10130', rub.field_number = '2'

TX

     charterAdmissionWaitList

E1676

CHARTER-ADMISSION-WAITLIST-INDICATOR-CODE

rub.field_value where rub.screen_number ='10130', rub.field_number = '3'

TX

eloSets

[Array]

TX

Fred Q: Are begin/end dates same for PEIMS Extended Year where ELO type = 4?  For PS, we are using day after end of school year for begin date and day before 1st day of school in next school year for that scenario. A: Jim, let's use the same logic for these dates that used in PS to keep things consisent. 07/21/2023

     eloTypeDescriptor

E1614

ELO-TYPE-CODE

rub.field_value where rub.screen_number ='10120', rub.field_number = '1'

TX

building user screen 10120 allows multiple entries (rub.list_sequence varies)

     eloActivitySets    

[Array]

TX

          eloActivityDescriptor

E1619

ELO-ACTIVITY-CODE

01 -Rigorous Coursework if rub.screen_number = '10120', rub.field_number = '3' has a field_value = 'Y'
02 - Mentoring if rub.screen_number = '10120', rub.field_number = '4' has a field_value = 'Y'
03 - Tutoring if rub.screen_number = '10120', rub.field_number = '5' has a field_value = 'Y'
04 - Physical Activity if rub.screen_number = '10120', rub.field_number = '6' has a field_value = 'Y'
05 - Academic Support if rub.screen_number = '10120', rub.field_number = '7' has a field_value = 'Y'
06 - Educational Enrichment if rub.screen_number = '10120', rub.field_number = '8' has a field_value = 'Y'

TX

building user screen 10120 allows multiple entries (rub.list_sequence varies)

          eloDaysScheduledPerYear

E1620

ELO-DAYS-SCHEDULED-PER-YEAR

If ELO-ACTIVITY-CODE = 01, then rub.field_value where rub.screen_number = '10120', rub.field_number = '10'
If ELO-ACTIVITY-CODE = 02, then rub.field_value where rub.screen_number = '10120', rub.field_number = '12'
If ELO-ACTIVITY-CODE = 03, then rub.field_value where rub.screen_number = '10120', rub.field_number = '14'
If ELO-ACTIVITY-CODE = 04, then rub.field_value where rub.screen_number = '10120', rub.field_number = '16'
If ELO-ACTIVITY-CODE = 05, then rub.field_value where rub.screen_number = '10120', rub.field_number = '18'
If ELO-ACTIVITY-CODE = 06, then rub.field_value where rub.screen_number = '10120', rub.field_number = '20'

TX

building user screen 10120 allows multiple entries (rub.list_sequence varies)

          eloMinutesScheduledPerDay

E1621

ELO-MINUTES-SCHEDULED-PER-DAY

If ELO-ACTIVITY-CODE = 01, then rub.field_value where rub.screen_number = '10120', rub.field_number = '2'
If ELO-ACTIVITY-CODE = 02, then rub.field_value where rub.screen_number = '10120', rub.field_number = '11'
If ELO-ACTIVITY-CODE = 03, then rub.field_value where rub.screen_number = '10120', rub.field_number = '13'
If ELO-ACTIVITY-CODE = 04, then rub.field_value where rub.screen_number = '10120', rub.field_number = '15'
If ELO-ACTIVITY-CODE = 05, then rub.field_value where rub.screen_number = '10120', rub.field_number = '17'
If ELO-ACTIVITY-CODE = 06, then rub.field_value where rub.screen_number = '10120', rub.field_number = '19'

TX

building user screen 10120 allows multiple entries (rub.list_sequence varies)

nslpTypeSets

[Array]

TX

     nslpTypeDescriptor

E1591

NSLP-TYPE-CODE

rub.field_value where rub.screen_number ='101', rub.field_number = '24'

TX

building user screen 101 currenlty allows only one entry (rub.list_sequence = 1 all cases)

     beginDate

E3010

use school year start

TX

TEA: Current year only

     endDate

E3020

day after last day of school year term

TX

additional fields for display only

 

 

 

rb.building

district view only

ssaOrgAssociationExts

eSP Source Data

Tables: TXTB_011

Selection Criteria

SSA are stored in the txtb_011 validation table.

Resource Output

  • The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.

  • LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Resource

Data Element

Description

TX Element

TX Element Name

eSP Source

Required?

Comments

ssaOrgAssociationExts

 

 

Tables: TXTB_011

TX

TX Extension Resource
Selection Criteria: SSA are stored in the txtb_011 validation table

educationOrganizationId

reg_district.state_code_equiv

TX

ssaTypeDescriptor

E0776

SHARED-SVCS-ARRANGEMT-TYPE-CODE

txtb_011.shared_svcs_type

TX

fiscalAgentDistrictId

E0777

FISCAL-AGENT-DISTRICT-ID

txtb_011.fiscal_agent_id

TX

JavaScript errors detected

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

If this problem persists, please contact our support.