Student Title 1 Part A Program Associations (Texas v4.0)

Tool Search Term: 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 I record that has been mapped to an Ed-Fi Code AND the record overlaps a configured year AND the student has an enrollment in the configured year AND the School Editor that the reporting enrollment is associated with has a School History record for Title I Program. The program selected on the student's Title I record must be selected in the 'Select all Title I Programs that are eligible to report under the Title I Part A program' drop list 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

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

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. If the Title 1 drop list is changed on the School/School history record, a resync must be completed. All records associated with the old program type will be deleted and new records will post with new program.
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.
If the Title 1 drop list is changed on the School/School history record, a resync must be completed. All records associated with the old program type will be deleted and new records will post with new program.

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 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

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 month, day, and year on which the student first received services.	Reports the start date from the Title I record being reported.	M	Student Information > General > Title I > Start Date title1.startDate
education Organization Reference	The education organization where the student is participating in or receiving the program services.	Reports the District Number to which the enrollment is associated.	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 month, day, and year on which the student exited the program or stopped receiving services.	Reports the end date from the Title I record being reported.	C	Student Information > General > 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.	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 is participating in a program authorized under ESEA, Title I, Part A of the Improving America's Schools Act.	Reports the mapped Ed-Fi Code of Title 1 Program.	M	Student Information > General > Title I
StudentTitleIPartAProgram AssociationSet		See array for field specific logic.	M	Student Information > General > Title I

Arrays

StudentTitleIPartAProgramAssociationSet

Data Element Label	Business Requirement	Business Rule	M,C, or O	Location
studentTitleIPartAProgram AssociationSetBeginDate		Reports the Title I Start Date.	M	Student Information > General > Title I > Start Date title1.startDate
titleIPartAParticipantDescriptor	Indicates whether the student is participating in a program authorized under ESEA, Title I, Part A of the Improving America's Schools Act	Reports the mapped Ed-Fi Code of Title I Program.	M	Student Information > General > Title I
studentTitleIPartAProgramAssociation SetEndDate		Reports the Title I End Date.	O	Student Information > General > Title I > End Date title1.endDate

Data Element Label

Business Requirement

Business Rule

M,C, or O

Location

studentTitleIPartAProgram
AssociationSetBeginDate

Reports the Title I Start Date.

Student Information > General > Title I > Start Date

title1.startDate

titleIPartAParticipantDescriptor

Indicates whether the student is participating in a program authorized under ESEA,

Title I, Part A of the Improving America's Schools Act

Reports the mapped Ed-Fi Code of Title I Program.

Student Information > General > Title I

studentTitleIPartAProgramAssociation
SetEndDate

Reports the Title I End Date.