Programs (Texas v4.0)

This entity 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.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When Flag is created and is mapped to an Ed-Fi Program Type Descriptor and a resync is completed

  • The Program record will Post when the first student is given an eligible Flag record that is mapped.
  • All students will reference the same programs once the first one is created.
Post

Post a Program when a student is assigned to a program record in the following areas. The record must overlap the configured year and have a Student School Association record to report.

  • Career Tech Program
  • Title I
  • SPED - locked IEP
  • Homeless
  • EL
  • Migrant
  • FRAM Eligibility

All students will reference the same program once the first one is created.

DeleteIf a mapping is removed from Resource Preferences. Programs will only be deleted when a mapping is removed after a resync is completed and 'All Schools' is checked on resync. Programs are at the district level and students in another school may have a Student Program Association record that references the Program.  All Student Program Association records must be deleted before a Program can be deleted.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table.
ResyncIf a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS.
ResyncIf a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes.
ResyncPrograms are only updated/deleted if a mapping is changed after a resync is completed and 'All Schools' is checked on resync. Programs are at the district level and students in another school may have a Student Program Association record that references the Program.

Natural Key Changes, Cascading Updates, and Deletes Logic

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

ActionTrigger
Post/Delete

Natural Key change:

  • LEA Reference - District Numbers cannot change after data has been sent.  If a district number changes, we would expect an Ed-Fi error and this change would not be supported.
  • If the Program Name or Program Type Descriptor mapping changes.

Delete

Cascading Deletes:  If the Natural Key changes, the following resources will be deleted/reposted.

  • Student Program Associations, Student Homeless Program Associations, Student Migrant Program Associations, Student Title 1 Part A Program Associations, Student Neglected or Delinquent Program Associations, Student Language Instruction Program Associations, Student CTE Program Associations, Student Special Education Program Associations, Student Food Service Eligibility Associations.


Scope Year Logic

Logic
The record sends to the scope year for the school year with which the program record is associated.
Data only sends for the years that have valid configuration.


Resource Preferences

Data Element LabelMapping Needed
Program Type DescriptorsPrograms
Program Type Descriptors - FlagsFlags


Identity Mapping Object Key

campusObjectTypeObject Key Data Source
ProgramprogramID
Plan'sped'


Event Queue Detail

Campus Table

Ed-Fi Action

Fields

programsPost

The primary table used for sending data for this resource.

programparticipationPost

The primary table used for sending data for this resource.

title1Post

The primary table used for sending data for this resource.

lepPost

The primary table used for sending data for this resource.

migrantPost

The primary table used for sending data for this resource.

homelessPost

The primary table used for sending data for this resource.

POSEligiblityPost

The primary table used for sending data for this resource.

Error Log

Error

Possible Causes/How to Fix

409: Failed to delete programs resource.

[message:The resource (or a subordinate entity of the resource) cannot be deleted because it is a dependency of the 'generalStudentProgramAssociation' entity.]

There are dependent resources in the Ed-Fi ODS so the Program record cannot be deleted. Use the delete tool to remove any dependent data before the course can be removed.


Object Data Elements

This table describes data elements sent within the Programs resource. Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Location

id  

The unique identifier of the resource.


M
programName The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies.
  1. Title 1 Part A: Reports 'Title 1 Part A'
  2. CTE: Reports 'Career and Technical Education'
  3. LanguageInstruction: If EL Service Type has mapped Ed-Fi Code = 002, 003, or 004, reports 'English as a Second Language (ESL)'
  4. LanguageInstruction: If EL Service Type has mapped Ed-Fi Code = 042, 043, 044, 045, 046, reports 'Bilingual'
  5. Special Education: Reports 'Special Education'
M




programTypeDescriptor

The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies.

  1. Title 1 Part A: Reports '38'
  2. CTE: Reports '05'
  3. LanguageInstruction: If EL Service Type has mapped Ed-Fi Code = 002, 003, or 004, reports '12'
  4. LanguageInstruction: If EL Service Type has mapped Ed-Fi Code = 042, 043, 044, 045, 046, reports '04'
  5. Special Education: Reports '33'
M




educationOrganization
Reference 
A reference to the related Education Organization resource.

Reports the District Number based on the Local Education Agency resource logic

MSchool & District Settings > District > District Information > State District Number

district.number
characteristicsReflects important characteristics of the Program, such as categories or particular indications.
O
learningObjectives References the LearningObjective(s) with which the Program is associated.
O
learningStandardsLearningStandard followed by this program.
O
programIdA unique number or alphanumeric code assigned to a program by a school, school system, a state, or other agency or entity.
  1. Reports the program ID from the flag or Career Tech Programs.
  2. Otherwise, reports '1'.


OStudent Information > Program Admin > Flags Setup

program.programId


services Defines the services this program provides to students.
O
sponsors

Ultimate and intermediate providers of funds for a particular educational or service program or activity, or for an individual’s participation in the program or activity (e.g., Federal, State, ESC, District, School, Private Organization).


O
etag

O