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 the logic for triggering the syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a student is given a Title 1 record that has been mapped to an Ed-Fi Code and the record overlaps a configured year OR If the school has a school history record with Title 1 = Schoolwide Program, report a record for all enrolled students. Multiple Enrollments - A new record will be created for each enrollment change found. Compare enrollment Start/End Dates against program Start/End Dates to produce a complete set of records. Exception: Ignore enrollment changes if End Status is mapped to an Ed-Fi Code = SC and SchoolID did not change.
|
| Delete/Post | When any field part of the natural key is updated:
|
| Put | When any field not part of the natural key isupdated
|
| 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. |
| Delete | When school is no longer marked as a Schoolwide Program. |
School Exclude, Calendar Exclude, Resource Toggle and Resync Logic
| 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 be needed 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
| Action | Trigger |
|---|---|
| Post/Delete | Natural Key changes:
|
| Delete | Cascading Deletes: N/A - no dependent resources. |
Scope Year Logic
| Logic |
|---|
The record only sends to any year with which the Title 1 record overlaps. |
| Data only sends 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 I Programs 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
| 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 I 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 | Location |
|---|---|---|---|---|
| id | The unique identifier of the resource. | O | ||
| beginDate | The first instructional day a student is identified as eligible to receive Title I Part A services. | Schoolwide Program
| M | Student Information > General > Enrollment > Start Date Student Information > General > Title I > Start Date Enrollment.startDate title1.startDate |
| education Organization Reference | The School Reference represents the identifier assigned to a school. | Reports the Natural Key of the School resource. | M | |
| program Reference | The program associated with the student. | Reports the Natural Key of the Programs resource. | M | |
| student Reference | A unique alpha-numeric code assigned to a student. | Reports the Natural key of the Students resource. | M | |
| endDate | The first day after the last instructional day a student was eligible to receive Title I Part A services. | Schoolwide Program Report Enrollment End Date + 1 additional day
Student Title 1 Program Record Report earliest of the following, + 1 additional day:
| C | Student Information > General > Enrollment > End Date Student Information > General > Title I > End Date Enrollment.endDate 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. | This is optional - does not report. | O | |
| servedOutsideOf RegularSession | Indicates whether the student received services during the summer session or between sessions. | This is optional - does not report. | 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. | This is optional - does not report. | O | |
| titleIPartA Participant Descriptor | Indicates whether the student participates in a program authorized under ESEA, Title I, Part A of the Improving America's Schools Act. |
| M | Student Information > Program Participation > Title 1 School History > Title 1 |
| StudentTitleIPartA Program AssociationSet | See array for field specific logic. | M | Student Information > General > Title I | |
| beginDate |
| M | Student Information > General > Title 1 Student Information > General > Enrollment > Start Date Enrollment.startDate | |
| endDate |
| O | Student Information > General > Title 1 Student Information > General > Enrollment > End Date enrollment.endDate |
Arrays
StudentTitleIPartAProgramAssociationSets
| Data Element Label | Business Requirement | Business Rule | M,C, or O | Location |
|---|---|---|---|---|
| studentTitleIPartAProgram AssociationSetBeginDate | The first instructional day in the current school year a student is assigned to the TitleIPartAParticipant descriptor. | Schoolwide Program Reports Enrollment Start Date. Reports the latest of the following that occurs within the scope year:
| M | Student Information > General > Enrollment > Start Date Enrollment.startDate Student Information > Program Participation > Title 1 > Start Date title1.startDate |
| titleIPartAParticipant Descriptor | Indicates whether the student is participating in a program authorized under ESEA, Title I, Part A of the Improving America's Schools Act |
| M | Student Information > Program Participation > Title 1 School & District Settings > Schools > School Information > School History |
| studentTitleIPartAProgram AssociationSetEndDate | The first day after the last instructional day a student was eligible to receive Title I Part A services. | Schoolwide Program Report Enrollment End Date + 1 additional day
Report earliest of the following, + 1 additional day:
If no date is found, report the last instructional day of the calendar + 1 day. | O | Student Information > Program Participation > Title 1 > End Date title1.endDate |
