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

This resource represents any program designed to work in conjunction with, or as a supplement to, the main academic program. Programs may provide instruction, training, services, or benefits through federal, state, or local agencies. Programs may also include organized extracurricular activities for students.

Primary PowerSchool Source Data

Tables: CST_PubCodeset (pcs)
CST_PubCodeValue (pcv)

Selection Criteria

Records are published if the following criteria are met:

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

    Minimum 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 programs resource is dependent on the prior publishing of Ed-Fi resources: localEducationAgencies.

  • The programs resource is published at the district level.

  • LEAs may upload (publish) data to the Ed-Fi 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

educationOrganizationReference

A reference to the related educationOrganization resource.

Required

/educationOrganizationID

Relates the program to an Education Organization, typically the LEA.

Integer

Derived from:
[Prefs]Name=DistrictNumber
[Prefs]Value

Required

programId

Program ID

integer

Required

programName

The formal name of the program of instruction, training, services, or benefits available.

String

Required

programId

The type of program, for example, Adult Ed, CTE, Bilingual.

String

[CST_PubProgram]Type

Valid values:

  • English as a Second Language (ESL)

  • Gifted and Talented

  • Special Education

  • Title I Part A

Required

programTypeDescriptor

Program type descriptor

A standard hard-coded list of common programs from the TEA code table is currently reported for all districts:

  • Bilingual

  • Career and Technical Education

  • English as a Second Language (ESL)

  • Gifted and Talented

  • Other

  • Regular Education

  • Section 504 Placement

  • Special Education

  • Title I Part A

Descriptor

PROGRAM-TYPE

Required

JavaScript errors detected

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

If this problem persists, please contact our support.