Indiana Ed-Fi Data v2.4/3.1 - Student Title 1 Part A Program Associations
Last Modified on 10/22/2022 10:19 am CDT
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 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.
A school is marked as 'Schoolwide Program - Title 1 A' or Schoolwide Program - Title 1 A and C' report all active students with enrollment start date and end date as the eligibility dates.
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.
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).
NOT AN ERROR: If School is marked as 'Schoolwide' and nothing is populated in the event queue (i.e., Nothing is Sending)..
System Administration > Resources > School > Title 1 field
Title 1 field has to have a value of:
'Schoolwide Program - Title 1 A', or
'Schoolwide Program - Title 1 A and C'
To fix this, click 'Original Record' > New School History > Make the new Title 1 selection > Save.
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
Location
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, unless Schoolwide.
If schoolwide, report enrollment start date.
M
Student Information > Program Participation > Title I > Start Date
Student Info > General > Enrollment > startDate
title1.startDate
enrollment.startDate
educationOrganization Reference
The education organization where the student is participating in or receiving the program services.
Report as the following:
10+District+School
M
programReference
The program associated with the student.
Program Reference is:
programName
programType
See programReference section below
M
studentReference
A unique alpha-numeric code assigned to a student.
Reports the student Ed-Fi ID.
M
Census > Demographics
identity.edfiID
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.
If schoolwide, report end date of the enrollment.
C
Student Information > General > Title I > End Date
Student Information > General > Enrollment > End Date
title1.endDate
enrollment.
endDate
reasonExitedDescriptor
A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.
Reports if there is an end status
Index > Student Information > General > Title 1 Tab (title1IN)
This field will be located here with the descriptor values in a drop list.
2. If Schoolwide, ALWAYS report End of Year (EOY)
C
Student Information > General > Title 1
servedOutsideOfRegularSession
Indicates whether the student received services during the summer session or between sessions.
This is optional - does not report.
O
serviceDescriptor
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.
Reports services received by the student on the Title 1 Tab.
Report services in an array if there is more than one Current Active Title1 program.
Services on this tab are broken into three categories:
Instructional Services
Support Services
Extended Time Opportunities
If schoolwide, report services selected in the School tool. (System Administration > Resources> School> Title 1)
See Service Descriptor section below.
M
Student Information > General > Title I
System Administration> Resources> School> Title 1
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 the 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 there are multiple Primary enrollments or no Primary enrollment exists, then use the highest enrollment ID.
M
System Administration > Resources > School > Title 1
