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 tables below describe logic for triggering syncing of this object.
Academic Programs, Flags, Graduation Programs, and Programs
Action
Trigger
Post
When a Flag or Program that is mapped to an Ed-Fi Code in Resource Preferences AND a student within the reporting school has a reportable record for that Flag or Program.
All students reference the same program record once it is created (Do not create duplicate program records for the exact same program).
Delete/Post/Put
A DELETE/POST is performed if the element being changed is part of the natural key for the resource. Otherwise, a PUT is performed.
When the following elements on Flags are changed:
Name
When the following elements on Graduation Programs are changed:
Name
School
When the following elements on Academic Programs are changed:
Name
School
When the following elements on Programs are changed:
Name
School(s)
District Wide
Delete
If a mapping is removed from Resource Preferences. Programs will only be deleted after a resync is completed and 'All Schools' is checked on resync. All Student Program Association records must be deleted before a Program can be deleted. It is therefore recommended that Student Program Associations is always resynced with Programs.
Alternative Education (01 Programs)
Alternative Education programs assigned to students in Student Information > Program Participation > State Programs > Alternative Education.
Action
Trigger
Post
When a student in the school has an Alternative Education program record that overlaps an Enrollment in the configured year.
All students reference the same program record once it is created (Do not create duplicate program records for the exact same program).
Delete/Post/Put
A DELETE/POST is performed if the element being changed is part of the natural key for the resource. Otherwise, a PUT is performed.
When the following elements on Alternative Education records are changed:
Start Date
End Date
Alternative School ID
Delete
Programs are only deleted after a resync is completed and 'All Schools' is checked on resync. All Student Program Association records must be deleted before a Program can be deleted. It is recommended that Student Program Associations is always resynced with Programs.
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.
Action
Trigger
None
If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
Resync
If 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.
Resync
If 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.
Resync
If a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes.
Natural Key Changes, Cascading Updates, and Deletes Logic
This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.
Action
Trigger
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.
If a mapping to the Ed-Fi Program Type Descriptor is removed or changed, a resync must be completed on 'All Schools' to delete/repost Student Program Associations. If only 1 school is selected, only Student Program Association records associated with that school will be updated and the Program will remain until a resync on 'All Schools' for Programs is completed.
Scope Year Logic
This table describes scope year logic of this object.
Logic
Special Education: Record will report for each year in which there is a locked IEP or NPSP.
If the school year Start and End Date = Null, then report 07/01/XXXX as the Start Date and an End Date of 06/30/XXXX
English Learner (EL) and Immigrant: Record will report for each year where an active LEP service exists.
LEP service must be active at least one day within or the Scope Year.
If the school year Start and End Date = Null, then report 07/01/XXXX as the Start Date and an End Date of 06/30/XXXX.
Title 1: Record will report for each year in which there is a student that has a Title I program.
The program with the selection must be within the Ed-Fi scope year.
Early Childhood: Record will report for each year in which there is a student that has an Early Childhood program.
The program with the selection must be within the Ed-Fi scope year
FRAM:Record will report for each year in which there is a student that has a food service program.
The program with the selection must be within the Ed-Fi scope year
Data will only send for the years that have valid configuration.
Resource Preferences
Data Element Label
Mapping Needed
Program Type Descriptors
Programs
Program Type Descriptors - Flags
Flag
Object Data Elements
This table describes data elements sent within the Programs resource.
Academic Programs, Flags, Graduation Programs, and Programs
Data Element Label
Business Rules
M, C, or O
Data Source GUI Path
Database Field
programName
Flags: Report the Flag Name.
Grad Programs + Academic Programs + Programs: Report the Program Name.
M
Program Admin > Flags > Name
Program Admin > Programs > Name
Program.name
programTypeDescriptor
Report the Ed-Fi Code the Flag or Program is mapped to in Resource Preferences.
