Skip to main content
Skip table of contents

Program Catalog

This view captures the program(s) that the students participate in or are served by. The layout provides the School Name, Program Type, Program Name, Last Publish Date, Publishing ID, and Resource ID.

programs

eSP Source Data

Tables: REG_PROGRAM_SETUP (rps)
PS: CST_PubCodeset (pcs), CST_PubCodeValue (pcv)

eSP has validation table TX_Program_Types by school year.  Could publish just those or all possible program types.


Selection Criteria

One record published for each programType downloaded in descriptors, program name = short description from downloaded list, odd chars removed.

Minimal set needed for TEA (Program Type and Name):

  • 05, Career and Technical Education

  • 12, English as a Second Language (ESL)

  • 33, Special Education

  • 38, Title I Part A

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

program

educationOrganizationId

rps.district

Y

format district id

programId

rtrim(rps.program_id)

N

5-char eSP program identifier, also used as local code for mapping to Ed-Fi programType descriptors

programName

substring(rps.description)

Y

programTypeDescriptor

E1337

PROGRAM-TYPE

derived from rps.program_id

Y

rps.program_id mapped to Ed-Fi programType descriptors on Code Mapping page

JavaScript errors detected

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

If this problem persists, please contact our support.