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.
Primary PowerSchool Source Data
[Prefs]
[CST_SubDistricts]
Selection Criteria
Records are published if the following criteria are met:
This resource has no specific selection criteria.
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.
Data Element | Description | Data Type | Stored in [Table]Field | Submission |
|---|---|---|---|---|
localEducationAgencyID | The identifier assigned to a local education agency by the State Education Agency (SEA). | Integer | Derived from: [Prefs]Name=DistrictNumber | Required |
stateOrganizationID | The identifier assigned to an education agency by the State Education Agency (SEA). | String | Derived from: [Prefs]Name=DistrictNumber | Required |
nameOfInstitution | The full, legally accepted name of the institution. | String | [Prefs]Name=DistrictName | Required |
educationOrganizationAddress
An unordered collection of educationOrganizationAddresses. The set of elements that describes an address, including the street address, city, state and ZIP code.
Data Element | Description | TX Element | Data Type | Stored in [Table]Field | Submission |
|---|---|---|---|---|---|
/addressType | The type of address listed for an individual or organization. | String | 'Physical' | Required | |
/streetNumberName | The street number and street name or post office box number of an address. | String | [Schools]SchoolAddress | Required | |
/city | The name of the city in which an address is located. | String | [Schools]SchoolCity | Required | |
/stateAbbreviationType | The abbreviation for the state (within the United States) or outlying area in which an address is located. | String | [Schools]SchoolState | Required | |
/postalCode | The five- or nine-digit zip code portion of an address. | String | [Schools]SchoolZip | Required | |
educationOrganizationCategoryDescriptor | The classification of the education agency within the geographic boundaries of a state according to the level of administrative and operational control granted by the state, for example, State Education Agency, Local Education Agency, or School. | E3019 | String | 'School' | Required |
identificationCodes | Optional/Not Required | ||||
EducationOrganizationIdentificationSystemDescriptor | System publishes SEA | ||||
IdentificationCode | District Identification code | l_district := TX_PEIMS_COMMON.get_district; | |||
EducationOrganizationIdentificationSystemDescriptor | System publishes SEA | Required | |||
localEducationAgencyCategoryDescriptor | 01' for School District, '02' for Charter | E3036 | String | Required | |
localEducationAgencyId | Indicates the District ID | E0212 | String | l_district := TX_PEIMS_COMMON.get_district; | |
nameOfInstitution | The full, legally accepted name of the institution. | E3037 | String | [Prefs]Name=DistrictName |
TX Extensions
For each school, TX extension elements are published only if the school is designated as the reporting school for its TX state school identifier.
Data Element | TX Element | Description | Stored in [Table]Field | Submission |
ArmedServicesVocAptBatteryDescriptor | E1625 | ARMED-SERVICES-VOC-APT-BATTERY-INDICATOR-CODE | NVL((SELECT TO_CHAR(value) FROM prefs where name = 'E1626_ASVAB_Ind_Code'),'00') | Required |
familyEngagementPlanLink | E1583 | FAMILY-ENGAGEMENT-PLAN-LINK | SELECT TO_CHAR(value) FROM prefs where name = 'E1583_fam_engage_plan_link' | Required |
totalCostSchoolBoardRequests | E1557 | TOTAL-COST-SCHOOL-BOARD-REQUESTS | SELECT LPAD(TO_CHAR(value),6,0) FROM prefs where name = 'E1557' | Required |
totalNumSchoolBoardRequests | E1556 | TOTAL-NUM-SCHOOL-BOARD-REQUESTS | SELECT LPAD(TO_CHAR(value),3,0) FROM prefs where name = 'E1556' | Required |
pkProgramEvaluationTypeDescriptor | E1626 | PROGRAM-EVALUATION-TYPE | S_TX_SCH_SCHOOLS_X.E1626_PROGRAM_EVAL_TYPE | Required |
giftedTalentedPrograms | ||||
giftedTalendedProgramDescriptor | E1645 | GIFTED-TALENTED-PROGRAM-CODE | S_TX_DISTRICT_GTPROGRAMS_S.Effective_Date | Required |
programOfStudies | ||||
programOfStudyDescriptor | E1643 | PROGRAM-OF-STUDY | S_TX_CTEPrograms_S.School_Year | Required |
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.
Primary PowerSchool Source Data
SCHOOLS (sch)
Selection Criteria
Records are published if the following criteria are met:
School is not excluded from state reporting
School is designated as the state reporting school for its TX state school identifier
State reporting school determined by one of the following:sch.alternate_school_number = sch.school_number
sch.alternate_school_number > 0
and s_tx_sch_schools_x.TEDSSchoolName = sch.alternate_school_number
and option 1 doesn't existsch.alternate_school_number = 0 and options 1 and 2 don't exist
Resource Output
The schools resource is dependent on the prior publishing of the following resources: localEducationAgencies.
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
Data Element | Description | Data Type | Stored in [Table]Field | Submission |
|---|---|---|---|---|
localEducationAgencyReference A reference to the related localEducationAgency resource. | ||||
/localEducationAgencyID | The LEA of which the school is an organizational component. | Integer | Derived from: [Prefs]Name=DistrictNumber | Required |
stateOrganizationID | The identifier assigned to an education agency by the State Education Agency. | String | Derived from:[Schools]Alternate_School_Number or [Schools]School_Number | Required |
nameOfInstitution | The full, legally accepted name of the institution. | String | [Schools]Name | Required |
shortNameOfInstitution | A short name for the institution. | String | [Schools]Abbreviation | Optional |
operationalStatusType | The current operational status of the education organization, for example, active, inactive. | Type | If a term exists for the school within the school year, or students are actively enrolled in the school for the school year. 'Active' Otherwise: 'Inactive' | Optional |
type | The type of education institution as classified by primary focus, for example, Regular, Alternative, Special Ed, CTE. | String | 'Regular' | Optional |
educationOrganizationAddress An unordered collection of educationOrganizationAddresses. The set of elements that describes an address, including the street address, city, state and ZIP code. | ||||
/addressType | The type of address listed for an individual or organization. | String | 'Physical' | Required |
/streetNumberName | The street number and street name or post office box number of an address. | String | [Schools]SchoolAddress | Required |
/city | The name of the city in which an address is located. | String | [Schools]SchoolCity | Required |
/stateAbbreviationType | The abbreviation for the state (within the United States) or outlying area in which an address is located. | String | [Schools]SchoolState | Required |
/postalCode | The five- or nine-digit zip code portion of an address. | String | [Schools]SchoolZip | Required |
educationOrganizationCategories | The classification of the education agency within the geographic boundaries of a state according to the level of administrative and operational control granted by the state, for example, State Education Agency, Local Education Agency, or School. TX Element: E3019 | String | 'School' | |
educationOrganizationIdentificationCode An unordered collection of educationOrganizationIdentificationCodes. A unique number or alphanumeric code that is assigned to an education organization by a school, school system, state, or other agency or entity., | ||||
/educationOrganization | The school system, state, or agency assigning the identification code, for example, SEA, NCES. | Descriptor | 'LEA' 'SEA' 'ACT' | Optional |
/identificationCode | A unique number or alphanumeric code that is assigned to an education organization by a school, school system, a state, or other agency or entity. | String | [Schools]Alternate_School_Number or | Required |
educationOrganizationInstitutionTelephone An unordered collection of educationOrganizationInstitutionTelephones. The 10-digit telephone number, including the area code, for the person. | ||||
/institutionTelephoneNumberType | The type of telephone number listed for an individual or organization. | Type | 'Main' 'Fax' | Required |
/telephoneNumber | The 10-digit telephone number, including the area code, for the education entity. | String | [Schools]Schoolphone [Schools]SchoolFax | Required |
schoolCategoryType | The one or more categories of school. For example: High School, Middle School, and/or Elementary School. | Type | Derived from [Schools]Low_Grade and [Schools]High_Grade | Required |
schoolGradeLevel The grade levels served at the school. | ||||
/gradeLevelDescriptor | The grade levels served at the school. | Descriptor | List of all grade levels between [Schools]Low_Grade and [Schools]High_Grade | Required |
TX extensions
For each school, TX extension elements are published only if the school is designated as the reporting school for its TX state school identifier.
TX Element | Description | Stored in [Table]Field | Submission |
E1671 | ADDITIONAL-DAYS-PROGRAM-INDICATOR-CODE Default = 0 | S_TX_SCH_SCHOOLS_X.E1671_ADSY_Indicator | Required |
E1646 | PK-FULL-DAY-WAIVER-INDICATOR-CODE | S_TX_SCH_SCHOOLS_X.E1646_PK_FULL_DAY_WAIVER PK Full Day Waiver is selected as: coalesce(to_char(schX.e1646_pk_full_day_waiver),(select to_char(value) num from prefs where name = 'E1646_PK_FULL_DAY_WAIVER'),'0') we select from schools, then prefs (district), then if nothing is found, we report a default of 0 | Required |
E1613 | EXPANDED-LEARNING-OPPORTUNITY-INDICATOR-CODE | Calculated based on the presence of at least one ELO record for the current school year. | Required |
E1727 | NUMBER-OF-BULLYING-INCIDENTS | S_TX_SCH_SCHOOLS_X.Bullying_count | Required |
E1728 | NUMBER-OF-CYBERBULLYING-INCIDENTS | S_TX_SCH_SCHOOLS_X.Cyberbullying_count | Required |
E1641 | CAMPUS-ENROLLMENT-TYPE-CODE | S_TX_SCH_SCHOOLS_X.E1641_CAMPUS_ENROLL_TYPE | Required |
E3010 | FIRST DAY OF SCHOOL YEAR TERM | N/A | Required |
E3020 | DAY AFTER LAST DAY OF APPLICABILITY | N/A | Required |
E1674 | NUMBER-CHARTER-STUDENTS-ENROLLED | Calculated: Count of students actively enrolled in the school on the Charter School Waitlist Snapshot Date, which is the last Friday in September | Required |
E1675 | CHARTER-EDUCATIONAL-ENROLLMENT-CAPACITY | S_TX_SCH_SCHOOLS_X.E1675_Charter_Enroll_Cap | Required |
E1676 | CHARTER-ADMISSION-WAITLIST-INDICATOR-CODE | S_TX_STU_CHARTER_WAITLIST_C.StudentsDCID and .Waitlist_Effective_Date and .Waitlist_Campus_ID (schools.school_number) | Required |
E1614 | ELO-TYPE-CODE | S_TX_SCH_ELO_C.E1614_ELO_Type | Required |
E1719 | ELO-ACTIVITY-CODE | S_TX_SCH_ELO_C: Derived from E1720 & E1621 | Required |
E1720 | ELO-DAYS-SCHEDULED-PER-YEAR | S_TX_SCH_ELO_C. | Required |
E1621 | ELO-MINUTES-SCHEDULED-PER-DAY | S_TX_SCH_ELO_C. | Required |
[Array] | Required | ||
E1591 | NSLP-TYPE-CODE | S_TX_SCH_SCHOOLS_X.E1581_NSLP_Code | Required |
E3010 | FIRST DAY OF SCHOOL YEAR TERM | N/A | Required |
E3020 | DAY AFTER LAST DAY OF APPLICABILITY | N/A | Required |
| sch.school_number | district view only | N/A |
ssaOrgAssociationExts
Primary PowerSchool Source Data
Tables: S_TX_DISTRICT_SHARED_SERV_S
TX Extension Resource - also included in Finance domain 6-23. This is published only if configured: PublishSSAOrganizationAssociationExtensions = 1
Selection Criteria
One record published for each row in S_TX_DISTRICT_SHARED_SERV_S
Resource Output
The schools resource is dependent on the prior publishing of the following resources: localEducationAgencies.
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
Data Element | TX Element | Description | Stored in [Table]Field | Submission |
educationOrganizationId | E0212 | Indicates the District ID | l_district := TX_PEIMS_COMMON.get_district; | Required |
ssaTypeDescriptor | E0776 | SHARED-SVCS-ARRANGEMT-TYPE-CODE | S_TX_DISTRICT_SHARED_SERV_S.E0776_Shared_Service | Required |
fiscalAgentDistrictId | E0777 | FISCAL-AGENT-DISTRICT-ID | S_TX_DISTRICT_SHARED_SERV_S.E0777_Fiscal_Agent | Required |