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