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