Student Title 1 Part A Program Associations (Nebraska v3.5)

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 at least 1 of the Title 1 service checkboxes are checked, and Targeted Assistance is selected, it qualifies.

  • 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 highest enrollmentID.
  • Do not report if the student's Enrollment has any of the following indicated:

    • No Show
    • Enrollment state exclude
    • Calendar exclude
    • School exclude
PostIf 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.
PostWhen 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 at least one Title 1 service checkbox selected & saved, and additional Title 1 services are selected and saved, update the services field.
  • When any enrollment record that previously had more than one Title 1 service checkbox selected & saved, and at least one Title 1 services are subsequently unchecked and saved, and there is at least one Title 1 service still selected, update the services 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 at least one 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 at least one 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 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. 

Reports the Enrollment Start Date.

M

Student Information > General > Enrollments > General Enrollment Information > Start Date

title1.startDate



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

Report the District Number the enrollment is associated with.

M

programReference The program associated with the student.

Reports the Natural Key of the Programs resource.

M

studentReference

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 Enrollment End Date.
  • Report the endDAte as follows:
    • If students have an endDate on their Title 1 record, report that date.
    • If students do not have endDate's, when looking for the calendar end date, if the calendar end date is beyond 06/30/endYear, report as 06/30/endYear.
    •  If students have a calendar end date of 06/30/endYear, report that date.
  • If a previous year's record was closed without an end date and the school year has changed from the year that the record was created, do not report.
C

Student Information > General > Enrollments > General Enrollment Information > End Date

title1.endDate


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

C

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

titleIPartAParticipant
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.Report the Ed-Fi Code from the mapping on 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 multiple Primary enrollments or no Primary enrollment exists, then use the highest enrollment ID.
MSystem Administration> Resources> School> Title 1

Arrays

Click here to expand...
Data Element LabelBusiness RequirementBusiness RuleM,C, or OData Source GUI PathDatabase Field
serviceDescriptorThe ID of the Service DescriptorReport a service for each Title 1 checkbox that is selected on the enrollment.
  1. Report the Ed-Fi code value that corresponds with the service selected.
  2. See the Services Descriptor Type Descriptor page for code mapping.
MStudent Information > General > Enrollments > Title 1 area
primaryIndicatornot reporting
O

serviceBeginDatenot reporting
O

serviceEndDatenot reporting
O

Type/Descriptors

Click here to expand...
EdFi ValueEdFI DescriptionLocal Campus Field
4Title I Civics GovtCivics
5Title I Early Childhood EducationEarly Childhood Education
6Title I Guidance CounselingGuidance Counseling
7Title I HealthHealth
8Title I MathMath
9Title I Reading ELAReading
10Title I ScienceScience
11Title I Social WorkSocial Work
12Title I Support OtherSupport Other
13Title I Vocational CareerVoc/Career