Student Neglected or Delinquent Program Associations (Missouri v3.6)

Tool Search: Ed-Fi

This association represents the McKinney-Vento Homeless Program 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 an enrollment is saved for a student and it overlaps the configured year and the student has an enrollment in the configured year.

  • Does not send a record when enrollment is in a calendar marked as Exclude.
  • Does not send a record when enrollment is in a school marked as Exclude.

  • Does not send a record when enrollment is marked as No Show.

Delete/Post

When any field part of the natural key is changed:

  • Start Date
Put

When any field not part of the natural key is changed.

  • End Date
Delete

All enrollments are deleted for a student.

DeleteWhen the student's enrollment is marked as No Show.
DeleteWhen the Title 1 record is deleted.
DeleteWhen the start/end dates on the Title I record are updated so the 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
NoneWhen a resource is toggled to off after data has sent, all sent data remains in the ODS but no new data sends.
ResyncWhen a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table.
ResyncWhen a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS.
ResyncWhen a mapping is changed in Resource Preferences, a resync needs to be done to reflect the changes.

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. When a district number changes, we would expect an Ed-Fi error and this change would not be supported.    
  • When an Ed-Fi ID changes, a delete/post occurs with the cascading deletes from the Ed-Fi ID Change triggers.          
  • When the Program Name or Program Type Descriptor mapping changes and a resync is completed. 
     
     
     
     
     
     
     
     
     
     
     
  • When the Start Date of the Title 1 program record changes.
     
     
     
     
     
     
     
     
DeleteN/A - no dependent resources.

Scope Year Logic

This table describes scope year logic of this object.

Logic

The record sends to any year the Title 1 record overlaps with when the student has an enrollment in that year.

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 ProgramProgram Type Descriptor
Select all Title 1 Programs that are eligible to report under the Neglected and Delinquent program.Title I Programs
Title1 Part D ProgramNeglected Or Delinquent Program Descriptor
Part D Program ServicesNeglected Or Delinquent Program Services

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.

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 LabelDescriptionM, C or O

Database Location

id The unique identifier of the resource.M
beginDate The month, day, and year on which the Student first received services.

Reports the start date of the Title I record being reported.
M

Program Participation > Title I > Start Date


Title1.startDate

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

Reports the District Number.
M

District Information> State District Number

programReferenceA reference to the Program Resource.

Reports the Natural Key for the Program.
  • educationOrganizationId = Reporting District Code
  • programName = Neglected or Delinquent (Hard-Coded)
  • programTypeDescriptor = Neglected or Delinquent (Hard-Coded)
M
studentReferenceA unique alpha-numeric code assigned to a student.

Reports the Natural Key for the Student resource where the studentUniqueID is the Student State ID.
M
neglectedOrDelinquentProgramServices

Indicates the service(s) being provided to the Student by the Neglected or Delinquent Program.


See Arrays section below.

M

Arrays

Click here to expand...

Neglected Or Delinquent Program Services

Data Element LabelDescriptionM, C, or ODatabase Location
neglectedOrDelinquentProgramServiceDescriptor

Identifies when a student residing in a neglected or delinquent institution is participating in programs for neglected or delinquent students.


Reports selected code

When blank, reports as NO.

MEnrollments > State Reporting fields > Neglected Delinquent

title1services.title1Service

Type/Descriptors

Click here to expand...

Neglected or Delinquent Program Service Descriptor

Ed-Fi CodeEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
DELDelinquenturi://dese.mo.gov/NeglectedOrDelinquentProgramServiceDescriptorDelinquent
NEGNeglecteduri://dese.mo.gov/NeglectedOrDelinquentProgramServiceDescriptorNeglected
NONot Neglected or Delinquenturi://dese.mo.gov/NeglectedOrDelinquentProgramServiceDescriptorNot Neglected or Delinquent