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

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.

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

DeleteWhen the Title I record has been deleted.
DeleteWhen the Title I record no longer overlaps the configured year.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf 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.
ResyncIf 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.
ResyncIf a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes.
ResyncPrograms 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

ActionTrigger
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.
DeleteCascading 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 ITitle I Part A Participant Type

Identity Mapping Object Key

campusObjectTypeObject Key Data Source
Title1title1ID

Event Queue Detail

Campus TableEd-Fi ActionFields
title1Post/Put/DeleteThe primary table for sending data for this resource.

Error Log

ErrorPossible 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 LabelBusiness RequirementBusiness RulesM, 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
servicesAn 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.

MStudent Information > General > Title I
StudentTitleIPartAProgram
AssociationSet

See array for field specific logic.


MStudent Information > General > Title I

Arrays

StudentTitleIPartAProgramAssociationSet

Data Element LabelBusiness RequirementBusiness RuleM,C, or OLocation
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

Type/Descriptors

Title I Part A Participant Descriptor

Code ValueDescriptionNamespaceShort Description
Local Neglected ProgramLocal Neglected Programuri://ed-fi.org/TitleIPartAParticipantDescriptorLocal Neglected Program
Private school students participatingPrivate school students participatinguri://ed-fi.org/TitleIPartAParticipantDescriptorPrivate school students participating
Public Schoolwide ProgramPublic Schoolwide Programuri://ed-fi.org/TitleIPartAParticipantDescriptorPublic Schoolwide Program
Public Targeted Assistance ProgramPublic Targeted Assistance Programuri://ed-fi.org/TitleIPartAParticipantDescriptorPublic Targeted Assistance Program
Was not servedWas not serveduri://ed-fi.org/TitleIPartAParticipantDescriptorWas not served