Student Title 1 Part A Program Associations (Missouri v3.6)

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.

In order for a Title 1 service to report, at least one of the Title 1 service checkboxes must be marked AND the Targeted Assistance checkbox must be marked on the student's enrollment in Student Information > General > Enrollments > State Reporting Fields.

ActionTrigger
Post

When an enrollment is created and saved, and the Title 1 service checkbox is checked.


Only report a single record per school, per student, per enrollment Start Date.

If there are multiple enrollments in the same school that qualify, and have the same enrollment Start Date, report based on primacy of Service Type:

  1. P: Primary
  2. S: Partial
  3. N: Special Ed

If there are multiple enrollments in the same school that qualify, with the same Service Type and enrollment Start Date, report the newest start date.


Do not report if the student's Enrollment has any of the following indicated:

  • No Show
  • Calendar exclude
  • School exclude

If the service type is being changed for the enrollment record being reported in this resource, report a new record for the new properly reported enrollment, if previously not the reporting enrollment.


When any field part of the natural key is updated

Put

Update the record if any other fields in this resource are changed that are not part of the natural key


When any enrollment record that previously had the Title 1 service checkbox selected & saved, update the titleIPartAProgramServices field

Delete

If the service type is being changed for the enrollment record being reported in this resource, delete the record if the enrollment is no longer the reported enrollment.

DeleteWhen any field part of the natural key is updated.
DeleteWhen any enrollment record that previously had the Title 1 service checkbox selected & saved, and all Title 1 services in that enrollment record are subsequently unchecked & saved, delete the record.
DeleteWhen any enrollment record that previously had the Title 1 service checkbox selected & saved, and the enrollment record is subsequently deleted, delete the 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.

Resource Preferences

Data Element Label

Mapping Needed

Select the Program Type Descriptor associated with this Program.Program Type Descriptor
Select all Title 1 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

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 Requirement and Business 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. 

Reports the Enrollment Start Date.
M

Student Information > General > Enrollments > Start Date


title1.startDate

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

Reports the fields that are part of the Natural Key for the Local Education Agency resource.
  • educationOrganizationId = State District Number
MSystem Administration > Resources > District Information > State District Number
programReference The program associated with the student.

  1. Reports the fields that are part of the Natural Key for the Programs resource.

    • educationOrganizationId = District Ed-Fi Number
    • programName = Title I Part A (Hard-Coded)
    • programTypeDescriptor = Title I Part A (Hard-Coded)
MStudent Information > General > Enrollments > State Reporting Fields > Title 1
studentReference

A unique alpha-numeric code assigned to a student.


  1. Reports the fields that are part of the Natural Key for the Students resource.

    • studentUniqueId = Student State ID
M
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.

Reports Active (Hard-coded)

  • There is only one descriptor code. Everyone that has a Title 1 Program (Individual or Schoolwide) is going to be active. For the Title 1 Program to report, this is a required field, thus we must report Active.
MStudent Information > General > Enrollments > State Reporting Fields > Title 1
titleIPartAProgramServicesAn unordered collection of studentTitleIPartAProgramAssociationTitleIPartAProgramServices. Indicates the service(s) being provided to the Student by the Title I Part A Program.

See array section below.

M

Arrays

Click here to expand...

Title I Part A Program Services

Data Element Label
Business Requirement and Business Rules
M,C, or O
Data Source GUI Path and Database Field
titleIPartAProgramServiceDescriptor

Indicates the service being provided to the student by the Title I Part A Program.


Returns user-entered value for SES if exists,WHEN:
  1. The Title 1 check box on the Student Enrollment is checked and if Sys Admin> Resources> School> School History> Title 1 has a value = 1
    OR
  2. Sys Admin> Resources> School> School History> Title 1 has a value = 2
    OR
  3. The student's FRAM Eligibility = Free or Reduced
    1. Else, do not report.
M

Student Information > General > Enrollments > State Reporting Fields > SES


Student Information > General > Enrollments > State Reporting Fields > Title 1


Sys Admin > Resources > School > School History > Title 1


FRAM > Eligibility



Type/Descriptors

Click here to expand...

titleIPartAParticipantDescriptor

Code Value
Short Description
Description
Namespace
ActiveActiveActiveuri://dese.mo.gov/TitleIPartAParticipantDescriptor

Title I Part A Program Service Descriptor

Code Value

Short Description

Description

Namespace

AApplied for Supplemental ServicesApplied for Supplemental Servicesuri://dese.mo.gov/TitleIPartAProgramServiceDescriptor
EEligible for Supplemental ServicesEligible for Supplemental Servicesuri://dese.mo.gov/TitleIPartAProgramServiceDescriptor
OOffered Supplemental ServicesOffered Supplemental Servicesuri://dese.mo.gov/TitleIPartAProgramServiceDescriptor
RReceived Supplemental ServicesReceived Supplemental Servicesuri://dese.mo.gov/TitleIPartAProgramServiceDescriptor