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

Classic View: System Administration > Ed-Fi > Ed-Fi Configuration

Search Terms: Ed-Fi Configuration

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 student is given a Title 1 record and the record overlaps a configured year and the student has an enrollment in the configured year. The program selected on the student's Title one record must be selected in the 'Select all Title 1 Programs that are eligible to report under the Title I Part A program' droplist in Resource Preferences. Do not send a record if enrollment is in a calendar marked as Exclude. Do not send a record if enrollment is in a school marked as Exclude. Do not send a record if enrollment is marked as No Show.
Delete/Post	When any field part of the natural key is changed: Title 1 Program Start Date
Put	When any field not part of the natural key is changed. End Date
Delete	When the student' no longer has an enrollment in the configured year.
Delete	When the Title I record has been deleted.
Delete	When the Title I record no longer overlaps the configured year.

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.

Resource Preferences

Data Element Label	Mapping Needed
Select the Program Type Descriptor associated with this Program.	Program Type Descriptor
Select all Title 1 Programs that are eligible to report under the Title I Part A program.	Title I Program
School Attribute Title I	Title I Part A Participant Type

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 I record being reported.	M	Student Information > Program Participation> Title I> Start Date	title1.startDate
educationOrganizationReference	The education organization where the student is participating in or receiving the program services.	Report the District Number to which the enrollment is associated.	M
programReference	The program associated with the student.	Reports the Natural Key of the Programs resource.	M
studentReference	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 I record being reported.	C	Student Information > Program Participation> Title I> End Date	title1.endDate
reasonExitedDescriptor	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.	C
servedOutsideOfRegularSession	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
titleIPartAParticipantDescriptor	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.	Report the Ed-Fi Code from the mapping on School Editor that the reporting enrollment is associated with. Use the most recent School History record for the Title I Program status. If the student has more than 1 enrollment in more than 1 school, use the school that has a Title I Program Participation on School History. If more than 1 school has a Title I Program Participation record than use the school from the student's Primary enrollment. If multiple Primary enrollments or no Primary enrollment exists, then use the highest enrollment ID.	M	System Administration> Resources> School> Title 1

Type/Descriptors

Title I Part A Participant Descriptor

Code Value	Description	Namespace	Short Description
Local Neglected Program	Local Neglected Program	uri://ed-fi.org/TitleIPartAParticipantDescriptor	Local Neglected Program
Private school students participating	Private school students participating	uri://ed-fi.org/TitleIPartAParticipantDescriptor	Private school students participating
Public Schoolwide Program	Public Schoolwide Program	uri://ed-fi.org/TitleIPartAParticipantDescriptor	Public Schoolwide Program
Public Targeted Assistance Program	Public Targeted Assistance Program	uri://ed-fi.org/TitleIPartAParticipantDescriptor	Public Targeted Assistance Program
Was not served	Was not served	uri://ed-fi.org/TitleIPartAParticipantDescriptor	Was not served