Indiana Ed-Fi Data v2.4/3.1 - Student Title 1 Part A Program Associations

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 1 record and the record overlaps a configured year and the student has an enrollment in the configured year.

  • The program selected on the student's Title one record must be selected in the 'Select all Title 1 Programs that are eligible to report under the Title I Part A program' droplist in Resource Preferences.
  • A school is marked as 'Schoolwide Program - Title 1 A' or Schoolwide Program - Title 1 A and C' report all active students with enrollment start date and end date as the eligibility dates.
  • 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

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.

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

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

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


Identity Mapping Object Key

campusObjectTypeObject Key Data Source
Title1title1ID


Event Queue Detail

This table describes the Event Queue Detail of this object.

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 1 is missing for the school reporting for the titleIPartAParticipantDescriptor field (see logic below to determine which school is being used).
NOT AN ERROR: If School is marked as 'Schoolwide' and nothing is populated in the event queue (i.e., Nothing is Sending)..

System Administration > Resources > School > Title 1 field

Title 1 field has to have a value of:

  1. 'Schoolwide Program - Title 1 A', or
  2. 'Schoolwide Program - Title 1 A and C'

To fix this, click 'Original Record' > New School History > Make the new Title 1 selection > Save.


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. 
  1. Report the start date from the Title I record being reported, unless Schoolwide.
  2. If schoolwide, report enrollment start date.
M

Student Information > Program Participation > Title I > Start Date


Student Info > General > Enrollment > startDate


title1.startDate


enrollment.startDate

educationOrganization
Reference 
The education organization where the student is participating in or receiving the program services.

Report as the following:


10+District+School

M
programReference The program associated with the student.Program Reference is:
  1. programName
  2. programType
    • See programReference section below
M
studentReference

A unique alpha-numeric code assigned to a student.

Reports the student Ed-Fi ID.

MCensus > Demographics

identity.edfiID
endDate The month, day, and year on which the student exited the program or stopped receiving services. 
  1. Report the end date from the Title I record being reported.
  2. If schoolwide, report end date of the enrollment.
C

Student Information > General > Title I > End Date


Student Information > General > Enrollment > End Date


title1.endDate

enrollment.

endDate

reasonExitedDescriptor A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Reports if there is an end status

  1. Index > Student Information > General > Title 1 Tab (title1IN)

This field will be located here with the descriptor values in a drop list. 


2. If Schoolwide, ALWAYS report End of Year (EOY)

CStudent Information > General > Title 1 
servedOutsideOfRegularSession Indicates whether the student received services during the summer session or between sessions.

This is optional - does not report.

O
serviceDescriptorAn 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.
  1. Reports services received by the student on the Title 1 Tab.
    • Report services in an array if there is more than one Current Active Title1 program.
  2. Services on this tab are broken into three categories:
    • Instructional Services
    • Support Services
    • Extended Time Opportunities
  3. If schoolwide, report services selected in the School tool. (System Administration > Resources> School> Title 1)
  4. See Service Descriptor section below.
MStudent Information > General > Title I

System Administration> Resources> School> Title 1
titleIPartAParticipantDescriptor 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 the School Editor that the reporting enrollment is associated with.
  1. Use the most recent School History record for the Title I Program status.
  2. If the student has more than 1 enrollment in more than 1 school, use the school that has a Title I Program Participation on School History.
    • If more than 1 school has a Title I Program Participation record than use the school from the student's Primary enrollment.
    • If there are multiple Primary enrollments or no Primary enrollment exists, then use the highest enrollment ID.
MSystem Administration > Resources > School > Title 1


Type/Descriptors

Click here to expand...

Reason Exited Descriptor

Code ValueDescriptionNamespaceShort Description
01Transferred to Regular Educationhttp://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlTransferred to Regular Education
02Attained the goals identified in the students ISP.http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlAttained the goals identified in the students ISP.
03Made satisfactory progress toward goals identified in the ISP.http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlMade satisfactory progress toward goals identified in the ISP.
04Did not make satisfactory progress toward ISP but remained in the program.http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlDid not make satisfactory progress toward ISP but remained in the program.
05Transferred/returned to other school setting prior to completing program.http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlTransferred/returned to other school setting prior to completing program.
06Dropped out of program, not returning to any educational setting.http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlDropped out of program, not returning to any educational setting.
07Expelled from program, not returned to any educational setting.http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlExpelled from program, not returned to any educational setting.
10Incarceratedhttp://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlIncarcerated
11Earned High School Diplomahttp://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlEarned High School Diploma
12Received Certificatehttp://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlReceived Certificate
13Reached Maximum Age of 22http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlReached Maximum Age of 22
14Deceasedhttp://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlDeceased
15Dropouthttp://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlDropout
16Moved, KNOWN to be continuing in an Educational Program ONLYhttp://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlMoved, KNOWN to be continuing in an Educational Program ONLY
17Moved, but continuing Special Education services under IDEA in Indianahttp://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlMoved, but continuing Special Education services under IDEA in Indiana
99No longer qualifieshttp://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlNo longer qualifies
End of Year (EOY)End of Year (EOY)http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xmlEnd of Year (EOY)


Title 1 Part A Participant Type

Code ValueDescriptionNamespaceShort Description
EligibleEligibleN/AEligible


Program Type

Code ValueDescriptionNamespaceShort description
Title I Part ATitle I Part AN/ATitle I Part A
Title I Part A and Migrant Title I Part CTitle I Part A and Migrant Title I Part CN/ATitle I Part A and Migrant Title I Part C
Title I Part D Subpart 1&2Title I Part D Subpart 1&2N/ATitle I Part D Subpart 1&2


Service Descriptor

Code ValueDescriptionNamespaceShort Description
After School Extended TimeAfter School Extended Timehttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlAfter School Extended Time
Before School Extended TimeBefore School Extended Timehttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlBefore School Extended Time
Extended-Day KindergartenExtended-Day Kindergartenhttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlExtended-Day Kindergarten
Guidance SupportGuidance Supporthttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlGuidance Support
Health SupportHealth Supporthttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlHealth Support
Home Visitation SupportHome Visitation Supporthttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlHome Visitation Support
Jump Start Extended TimeJump Start Extended Timehttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlJump Start Extended Time
Math InstructionMath Instructionhttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlMath Instruction
Other Extended TimeOther Extended Timehttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlOther Extended Time
Prekindergarten Extended TimePrekindergarten Extended Timehttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlPrekindergarten Extended Time
Reading InstructionReading Instructionhttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlReading Instruction
Saturday School Extended TimeSaturday School Extended Timehttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlSaturday School Extended Time
Science InstructionScience Instructionhttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlScience Instruction
Social Studies InstructionSocial Studies Instructionhttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlSocial Studies Instruction
Summer School Extended TimeSummer School Extended Timehttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlSummer School Extended Time
Vocational EducationVocational Educationhttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlVocational Education
Year Round Sessions Extended TimeYear Round Sessions Extended Timehttp://doe.in.gov/Descriptor/ServiceDescriptor.xmlYear Round Sessions Extended Time

Service Descriptor mapping with Campus Values on School

Campus HeaderCampus ValueIDOE Value
Instructional Services


ReadingReading Instruction

MathMath Instruction

ScienceScience Instruction 

VocationalVocational Education

Social StudiesSocial Studies Instruction
Support Services


GuidanceGuidance Support

HealthHealth Support

Home VisitationHome Visitation Support
Extended Time Opportunities


PrekindergartenPrekindergarten Extended Time

Extended-Day KindergartenExtended-Day Kindergarten

Before SchoolBefore School Extended Time

After SchoolAfter School Extended Time

Saturday SchoolSaturday School Extended Time

Summer SchoolSummer School Extended Time

Jump StartJump Start Extended Time

Year-RoundYear Round Session Extended Time

Other Extended Time OpportunitiesOther Extended Time



Arrays

Click here to expand...

References

ReferenceBusiness RequirementBusiness RulesM, C, or OLocation
EducationalOrganizationID ReferenceThe number of the school reporting.EducationOrganizationID
  • Reports as 10+District+School
    • EX: 1012348765
M
Programs ReferenceThe detailed information about the Title 1 Program the student is in.
  1. ProgramTYPE
    • Reports the program type as referenced in the Descriptor - Type section:
      • ESA Title 1 Program Field on Title1 Tab
  2. Program Name
    • Reports the school's program information form Schoo l> Title 1
      • If Null, report Not Title 1 Eligible 
  3. EdOrgID
    • Reports a hard coded 1088000000
M

Student Information > General > Title 1 Tab


System Administration > Resources > School > Title 1 Program

Student ReferenceReports the students Unique ID if enrolled in a Title 1 program
  1. STN / EdFi ID
    • Reports the student's Ed-FiID.
MStudent Information > General > Demographics