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.
In order for a Title 1 service to report, at least one of the Title 1 service checkboxes must be marked AND the Targeted Assistance checkbox must be marked on the student's enrollment in Student Information > General > Enrollments > State Reporting Fields.
| Action | Trigger |
|---|---|
| Post | When an enrollment is created and saved, and at least 1 of the Title 1 service checkboxes are checked, and Targeted Assistance is selected, it qualifies.
|
| Post | If the service type is being changed for the enrollment record being reported in this resource, report a new record for the new properly reported enrollment, if previously not the reporting enrollment. |
| Post | When any field part of the natural key is updated. |
| Put | Update the record if any other fields in this resource are changed that are not part of the natural key.
|
| Delete | If the service type is being changed for the enrollment record being reported in this resource, delete the record if the enrollment is no longer the reported enrollment. |
| Delete | When any field part of the natural key is updated. |
| Delete | When any enrollment record that previously had at least one Title 1 service checkbox selected & saved, and all Title 1 services in that enrollment record are subsequently unchecked & saved, delete the record. |
| Delete | When any enrollment record that previously had at least one Title 1 service checkbox selected & saved, and the enrollment record is subsequently deleted, delete the 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:
|
| 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. | Reports the Enrollment Start Date. | M | Student Information > General > Enrollments > General Enrollment Information > Start Date | title1.startDate |
| educationOrganization Reference | The education organization where the student is participating in or receiving the program services. | Report the District Number the enrollment is associated with. | 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. |
| C | Student Information > General > Enrollments > General Enrollment Information > 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 | ||
| 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 | ||
| titleIPartAParticipant 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 |
