Minnesota Ed-Fi Data v3.1 - Student Title 1 Part A Program Associations

Classic View: System Administration > Ed-Fi 

Search Terms: 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.

ActionTrigger
Post

When a new enrollment is saved for a student, and there is a Title 1 tab record saved that overlaps the enrollment record OR when a new Title 1 tab record is saved that overlaps one or more enrollment records, OR the school record tied to the enrollment has Title 1 = SWELIGSWPROG: Schoolwide Program.

  • When a student has two enrollments in the same School, Calendar & Schedule Structure with the same start date, report from the enrollment service type in the following order:

    1. P: Primary Enrollment
    2. S: Partial/Ancillary
    3. N: Special Ed Services
  • When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record.
  • When a student has two or more consecutive enrollments tied to the same school, if they overlap, the Title I program records will be broken into multiple non-overlapping records, with the. start date of the record matching the start date of the related enrollment, but the end date of the record calculated as the day before the enrollment start date of the next enrollment record.
  • When a student has two or more consecutive enrollments tied to the different schools, if they overlap, multiple Title I records will be sent.
  • Do not send records if the Calendar Exclude check box is checked in the calendar the student is enrolled.

  • Do not send records if the School Exclude check box is checked in the calendar the student is enrolled.
  • Do not send a record if the No Show check box is checked.
  • When a new Title 1 record is saved for a student, and there is a reportable enrollment record that overlaps the Title 1 record.
  • When the Title 1 record's Start Date or End Date are updated so that they newly overlap a reportable enrollment record.
  • When the Enrollment record's Start Date or End Date are updated so that they newly longer overlap an Title 1 record.
  • Do not send records if the Calendar Grade Level "Exclude from State Reporting" checkbox is selected for the grade level that the student's enrollment is tied to.
Put

When the start date for an enrollment is changed.

  • When an enrollment with a lower priority is changed, data will not send.
  • When an enrollment is updated for a student.
  • When the Title 1 record is updated for a student.
Delete

When an enrollment is deleted.

  • When a student has two enrollments in the same school for the same start date, records with lower priority will not trigger a delete.
  • When the No Show check box is checked.
  • When the Title 1 record is deleted.
  • When the Title 1 record's Start Date or End Date are updated so that they no longer overlap a reportable enrollment 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.

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

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

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.
  1. Report the Start Date from the Title 1 tab record.
    • If the Enrollment Start Date takes place after the Title 1 tab record Start Date, report the Enrollment Start Date.
  2. Report the Enrollment Start Date if the reporting is based on the School Title 1 record.
M

Student Information > Program Participation > Title 1 > Start Date


Student Information > General > Enrollments > Start Date

Title1.startDate


Enrollment.startDate



education
Organization
Reference 
educationOrganizationId

The identifier assigned to an education organization.

  1. Report the Ed-Fi School ID
  2. If Ed-Fi School ID is NULL, report:
    1. ttddddsssmmm

      where:

      • tt = district type
      • dddd = district number, left zero filled
      • sss = school number, left zero filled
      • mmm = 000 for all organizations reported in Ed-Fi
M

System Administration > Resources > School > school record > Ed-Fi School ID


tt: System Administration > Resources > District Information > district record > Type


dddd: System Administration > Resources > District Information > district record > State District Number


SSS: System Administration > Resources > School > school record > State School Number

School.entityID

District.type

District.number

School.number

program
Reference 

educationOrganizationId

The identifier assigned to an education organization.

programName

The formal name of the Program of instruction, training, services, or benefits available through federal, state, or local agencies.

programTypeDescriptor

The type of program.

  1. Report the following values within the program

    • educationOrganizationId:
      • Report the Ed-Fi District Number, if it exists
      • If Ed-Fi District Number is NULL, report:
        • ttddddsss

          where:

          1. tt = district type
          2. dddd = district number, left zero filled
          3. sss = 000
    • programName: 'Served in a Title I Part A Program'
    • programTypeDescriptor: 'Title I Part A'
M

System Administration > Resources > District Information > district record > Ed-Fi District Number


tt: System Administration > Resources > District Information > district record > Type


dddd: System Administration > Resources > District Information > district record > State District Number

District.entityID

District.type

District.number

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.
  1. Report the End Date from the Title 1 tab record, if it exists.
    • If the Enrollment Start Date takes place after the Title 1 record Start Date, report the Enrollment Start Date.
  2. Report the Enrollment End Date, if it exists, if the reporting is based on the School Title 1 record.
  3. If no Title 1 tab record End Date or enrollment End Date exists, do not report.
C

Student Information > Program Participation > Title 1 > End Date


Student Information > General > Enrollments > Enrollment End Date

Title1.endDate


Enrollment.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 - do not report.

O

servedOutsideOf
RegularSession 
Indicates whether the student received services during the summer session or between sessions.

This is optional - do not report.

O

servicesAn 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

titleIPartA
Participant
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.

This is optional - do not report.

O