Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

This association represents the Title I Part A program(s) that a student participates in or from which the student receives services.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a new enrollment is saved for a student, and there is a Title 1 tab record saved that overlaps the enrollment record OR when a new Title 1 tab record is saved that overlaps one or more enrollment records, OR the school record tied to the enrollment has Title 1 = SWELIGSWPROG: Schoolwide Program. When a student has two enrollments in the same School, Calendar & Schedule Structure with the same start date, report from the enrollment service type in the following order: P: Primary Enrollment S: Partial/Ancillary N: Special Ed Services When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record. When a student has two or more consecutive enrollments tied to the same school, if they overlap, the Title I program records will be broken into multiple non-overlapping records, with the. start date of the record matching the start date of the related enrollment, but the end date of the record calculated as the day before the enrollment start date of the next enrollment record. When a student has two or more consecutive enrollments tied to the different schools, if they overlap, multiple Title I records will be sent. Do not send records if the Calendar Exclude check box is checked in the calendar the student is enrolled. Do not send records if the School Exclude check box is checked in the calendar the student is enrolled. Do not send a record if the No Show check box is checked. When a new Title 1 record is saved for a student, and there is a reportable enrollment record that overlaps the Title 1 record. When the Title 1 record's Start Date or End Date are updated so that they newly overlap a reportable enrollment record. When the Enrollment record's Start Date or End Date are updated so that they newly longer overlap an Title 1 record. Do not send records if the Calendar Grade Level "Exclude from State Reporting" checkbox is selected for the grade level that the student's enrollment is tied to.
Put	When the start date for an enrollment is changed. When an enrollment with a lower priority is changed, data will not send. When an enrollment is updated for a student. When the Title 1 record is updated for a student.
Delete	When an enrollment is deleted. When a student has two enrollments in the same school for the same start date, records with lower priority will not trigger a delete. When the No Show check box is checked. When the Title 1 record is deleted. When the Title 1 record's Start Date or End Date are updated so that they no longer overlap a reportable enrollment record.

Action

Trigger

Post

When a new enrollment is saved for a student, and there is a Title 1 tab record saved that overlaps the enrollment record OR when a new Title 1 tab record is saved that overlaps one or more enrollment records, OR the school record tied to the enrollment has Title 1 = SWELIGSWPROG: Schoolwide Program.

When a student has two enrollments in the same School, Calendar & Schedule Structure with the same start date, report from the enrollment service type in the following order:
1. P: Primary Enrollment
2. S: Partial/Ancillary
3. N: Special Ed Services
When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record.
When a student has two or more consecutive enrollments tied to the same school, if they overlap, the Title I program records will be broken into multiple non-overlapping records, with the. start date of the record matching the start date of the related enrollment, but the end date of the record calculated as the day before the enrollment start date of the next enrollment record.
When a student has two or more consecutive enrollments tied to the different schools, if they overlap, multiple Title I records will be sent.
Do not send records if the Calendar Exclude check box is checked in the calendar the student is enrolled.
Do not send records if the School Exclude check box is checked in the calendar the student is enrolled.
Do not send a record if the No Show check box is checked.
When a new Title 1 record is saved for a student, and there is a reportable enrollment record that overlaps the Title 1 record.
When the Title 1 record's Start Date or End Date are updated so that they newly overlap a reportable enrollment record.
When the Enrollment record's Start Date or End Date are updated so that they newly longer overlap an Title 1 record.
Do not send records if the Calendar Grade Level "Exclude from State Reporting" checkbox is selected for the grade level that the student's enrollment is tied to.

Put

When the start date for an enrollment is changed.

When an enrollment with a lower priority is changed, data will not send.
When an enrollment is updated for a student.
When the Title 1 record is updated for a student.

Delete

When an enrollment is deleted.

When a student has two enrollments in the same school for the same start date, records with lower priority will not trigger a delete.
When the No Show check box is checked.
When the Title 1 record is deleted.
When the Title 1 record's Start Date or End Date are updated so that they no longer overlap a reportable enrollment record.

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.
Resync	Programs will only be update/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 my 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.

Action	Trigger
Post/Delete	Natural Key changes: 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 an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers. If the Program Name or Program Type Descriptor mapping changes and a resync is completed. If the Start Date of the program record changes.
Delete	Cascading Deletes: N/A - no dependent resources.

Action

Trigger

Post/Delete

Natural Key changes:

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 an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers.
If the Program Name or Program Type Descriptor mapping changes and a resync is completed.
If the Start Date of the program record changes.

Delete

Cascading Deletes: N/A - no dependent resources.

Scope Year Logic

This table describes scope year logic of this object.

Logic
The record will send to any year the Title 1 record overlaps with.
Data will only send for the years that have valid configuration.

Identity Mapping Object Key

campusObjectType	Object Key Data Source
Title1	title1ID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
title1	Post/Put/Delete	The primary table for sending data for this resource.

Error Log

Error	Possible Causes/Hot to Fix
Error code return from Ed-Fi. 400: [message:Validation of 'StudentTitleIPartAProgramAssociation' failed. TitleIPartAParticipantDescriptorId is required. ].	School History > Title 1 is missing for the school reporting for the titleIPartAParticipantDescriptor field (see logic below to determine which school is being used).

Object Data Elements

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 Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		O
beginDate	The month, day, and year on which the Student first received services.	Report the Start Date from the Title 1 tab record. If the Enrollment Start Date takes place after the Title 1 tab record Start Date, report the Enrollment Start Date. Report the Enrollment Start Date if the reporting is based on the School Title 1 record.	M	Student Information > Program Participation > Title 1 > Start Date Student Information > General > Enrollments > Start Date	Title1.startDate Enrollment.startDate
education Organization Reference	educationOrganizationId The identifier assigned to an education organization.	Report the Ed-Fi School ID If Ed-Fi School ID is NULL, report: ttddddsssmmm where: tt = district type dddd = district number, left zero filled sss = school number, left zero filled mmm = 000 for all organizations reported in Ed-Fi	M	System Administration > Resources > School > school record > Ed-Fi School ID tt: System Administration > Resources > District Information > district record > Type dddd: System Administration > Resources > District Information > district record > State District Number SSS: System Administration > Resources > School > school record > State School Number	School.entityID District.type District.number School.number
program Reference	educationOrganizationId The identifier assigned to an education organization. programName The formal name of the Program of instruction, training, services, or benefits available through federal, state, or local agencies. programTypeDescriptor The type of program.	Report the following values within the program educationOrganizationId: Report the Ed-Fi District Number, if it exists If Ed-Fi District Number is NULL, report: ttddddsss where: tt = district type dddd = district number, left zero filled sss = 000 programName: 'Served in a Title I Part A Program' programTypeDescriptor: 'Title I Part A'	M	System Administration > Resources > District Information > district record > Ed-Fi District Number tt: System Administration > Resources > District Information > district record > Type dddd: System Administration > Resources > District Information > district record > State District Number	District.entityID District.type District.number
student Reference	A unique alpha-numeric code assigned to a student.	Reports the Natural key of the Students resource.	M
endDate	The month, day, and year on which the Student exited the Program or stopped receiving services.	Report the End Date from the Title 1 tab record, if it exists. If the Enrollment Start Date takes place after the Title 1 record Start Date, report the Enrollment Start Date. Report the Enrollment End Date, if it exists, if the reporting is based on the School Title 1 record. If no Title 1 tab record End Date or enrollment End Date exists, do not report.	C	Student Information > Program Participation > Title 1 > End Date Student Information > General > Enrollments > Enrollment End Date	Title1.endDate Enrollment.endDate
reasonExited Descriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.	This is optional - do not report.	O
servedOutsideOf RegularSession	Indicates whether the student received services during the summer session or between sessions.	This is optional - do not report.	O
services	An unordered collection of studentProgramAssociationServices. This association represents the Title I Part A program(s) that a student participates in or from which the student receives services. The association is an extension of the StudentProgramAssociation particular for Title I Part A programs.	This is optional - do not report.	O
titleIPartA Participant Descriptor	An indication of the type of Title I program, if any, in which the student is participating and served: Public Targeted Assistance Program Public Schoolwide Program Private school student participating Local Neglected Program.	This is optional - do not report.	O

Minnesota Ed-Fi Data v3.1 - Student Title 1 Part A Program Associations