Tool Search: 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.
|
| Delete/Post | When any field part of the natural key is changed:
|
| Put | When any field not part of the natural key is changed.
|
| 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:
|
| 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. |
| M | Student Information > Program Participation> Title I> Start Date | title1.startDate |
| education Organization Reference | The education organization where the student is participating in or receiving the program services. |
| M | ||
| program Reference | The program associated with the student. |
| M | ||
| student Reference | A unique alpha-numeric code assigned to a student. |
| M | ||
| endDate | The month, day, and year on which the student exited the program or stopped receiving services. |
| C | Student Information > Program Participation> Title I> End Date | title1.endDate |
| reasonExited Descriptor | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. |
| C | ||
| servedOutsideOf RegularSession | Indicates whether the student received services during the summer session or between sessions. |
| O | ||
| services | An unordered collection of student Program Association Services. 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. |
| 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. | Report the Ed-Fi Code from the mapping on School Editor that the reporting enrollment is associated with.
| M | System Administration> Resources> School> Title 1 |
