Minnesota Ed-Fi Data v3.1 - Programs [.1825 - .2148]

Classic Path: System Administration > Ed-Fi

Search Terms: Ed-Fi

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.

Action	Trigger
Post	Post a Program when a student is assigned to a program record in the following program areas. The record must overlap the configured year and have a Student School Association record to report.
	student21stCenturyLearningCenterGrantProgramAssociations - State Program tab: 21st CCLC
	studentADSISProgramAssociations - State Program tab: ADSIS
	studentCEISProgramAssociations - State Program tab: CEIS
	studentEarlyChildhoodScreeningProgramAssociations - Core Program tab: Early Learning
	studentGiftedTalentedProgramAssociations - Core Program tab: Gifted
	studentHomelessProgramAssociations - Core Program tab: Homeless
	studentLanguageInstructionProgramAssociations - Core Program tab: EL
	studentPSEOConcurrentProgramAssociations - State Program tab: PSEO
	studentPSEOProgramAssociations - State Program tab: PSEO
	studentSchoolFoodServiceProgramAssociations - FRAM tab
	studentSAAPProgramAssociations - State Program tab: SAAP
	studentSection504PlanProgramAssociations - Core Program Tab: 504
	studentSpecialEducationProgramAssociation - Core SPED module
	studentTitleIPartAProgramAssociations - Core Title 1 tab / School editor
	All students will reference the same program once the first one is created.
Delete	If 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.

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.

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
The record will send to the scope year for the school year the program record is associated with.
Data will only send for the years that have valid configuration.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Program Type Descriptors	Programs

Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectType	Object Key Data Source
Program	programID
Plan	'sped'

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
programs	Post	The primary table used for sending data for this resource.
programparticipation	Post	The primary table used for sending data for this resource.
title1	Post	The primary table used for sending data for this resource.
lep	Post	The primary table used for sending data for this resource.
migrant	Post	The primary table used for sending data for this resource.
homeless	Post	The primary table used for sending data for this resource.
POSEligiblity	Post	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.

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 Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
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.	If reporting from Flags, report the Flag Name If reporting from a program area in Campus, report the Program Type Descriptor the program is mapped to: Student Program Associations Student Homeless Program Associations Student Migrant Program Associations Student Title 1 Part A Program Associations Student Language Instruction Program Associations, Student CTE Program Associations Student Special Education Program Associations Student Food Service Eligibility Associations.	M	Program Admin> Flags> Name Or Program Admin> Programs	program.name or EdFiMapping.edFiValue
programTypeDescriptor	The formal name of the program of instruction, training, services or benefits available through federal, state or local agencies.	If reporting from Flags, report the Ed-Fi code the flag is mapped to. If reporting from a program area in Campus, report the Program Type Descriptor the program is mapped to: Student Program Associations Student Homeless Program Associations Student Migrant Program Associations Student Title 1 Part A Program Associations Student Language Instruction Program Associations, Student CTE Program Associations Student Special Education Program Associations Student Food Service Eligibility Associations.	M	Program Admin> Programs	EdFiMapping.edFiValue
educationOrganizationReference	A reference to the related EducationOrganization resource.	Reports the State District Number.	M	System Administration> Resources> District Information> State District Number	district.number
characteristics	Reflects important characteristics of the Program, such as categories or particular indications.		O
learningObjectives	References the LearningObjective(s) with which the Program is associated.		O
learningStandards	LearningStandard followed by this program.		O
programId	A unique number or alphanumeric code assigned to a program by a school, school system, a state, or other agency or entity.	Reports the program ID from the flag or Career Tech Programs. Else, report '1'	O	Program Admin> Flags	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