Wisconsin Ed-Fi Data v3.1 - Student Homeless Program Associations

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.

Action	Trigger
Post	When a new Homeless record is saved for a student.
Post	When a new Enrollment is created within the duration of the Homeless record. Do not post a record when the Enrollment for the student is marked No Show, State Exclude, or WISE Exclude. Do not send records if the Calendar Exclude or Summer School Exclude check box is checked in the calendar the student is enrolled or the calendar is in a School marked Exclude. Do not send records if the Grade Level Exclude check box is checked on the grade the student is enrolled. Do not report if State Enrollment Type = Coursework Only or PPP: Parentally Placed Private. If Ed-Fi Configuration Profile = Choice + Private Opt In or Ed-Fi Configuration Profile = Choice ONLY, do not report a record. If a Homeless record previously had a Primary Night Time Residence value not mapped to an Ed-Fi value, and has now been updated to a different value. When a new enrollment is created that overlaps with the Homeless record.
Put	When an enrollment record driving the Homeless record is ended.
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 Primary Night Time Residence Unaccompanied Youth
Delete	When an enrollment is deleted or one of the check boxes for No Show, State Exclude, or WISE Exclude are checked.
Delete	If a Homeless record's Primary Night Time Residence value is changed to a value not mapped to an Ed-Fi Value
Delete	If the Homeless record is deleted.

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.

Action	Trigger
None	If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
Resync	If 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.
Resync	If 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.
Resync	If a mapping is changed in Resource Preferences, a resync will need 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.

Action	Trigger
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.
Delete	Cascading Deletes: N/A - no dependent resources.

Action

Trigger

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.

Delete

Cascading 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 homeless record overlaps with if the student has an enrollment in that year.
Data will only send for the years that have valid configuration.

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
homeless	Post/Put/Delete	The 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 Label	Business Requirement	Logic	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
beginDate	The month, day, and year on which the Student first received services. Begin date should be within the school year. The ODS / API v3.1 rejects input if a datetime value is provided to a date-only field.	For the relevant homeless record, if the homeless record starts within the config year, report the homeless record start date If the homeless record starts before the enrollment associated with the record, report the enrollment start date If additional enrollments are created after the homeless record start date, report the enrollment start date on each associated record.	M	Student Information > Program Participation > Homeless > start date Student Information > General > Enrollment > start date	homeless.startDate
educationOrganizationReference	A reference to the related School resource.	A reference to the Student School Association Resource Report from any enrollment active within the start and end dates of the Homeless record Report School Ed-Fi Number first from the School Override on Enrollment If School Override is NULL, report from the Enrollment school Reports the fields that are part of the Natural Key for the School resource	M	Calculated from Student Information > General > Enrollment and System Administration > Resources > School > Ed-Fi School Number
programReference	A reference to the Program Resource.	Report code value : H. Program Name : Education for Homeless Children and Youth. Program Type Descriptor: Post the code value of the descriptor educationOrganizationId (integer): 48856.	M
studentReference	A unique alpha-numeric code assigned to a student.	Reports the Natural Key for the Student resource.	M
awaitingFosterCare	State defined definition for awaiting foster care.	This is optional, does not report.	O
endDate	The month, day, and year on which the student exited the program or stopped receiving services. End date should be within the school year.	Report the end date of the homeless record If the record does not have an end date, report 6/30/xxxxwhere xxxx is the end year of the config year the record is posting to	O	Student Information> Program Participation> Homeless> End Date	homeless.enddate
homelessPrimaryNighttimeResidenceDescriptor	The primary nighttime residence of the student at the time the student is identified as homeless.	Reports the Ed-Fi Code from the mapped value in the Homeless Resource Preferences for this field. If mapping does not exist, do not report.	O	Student Information> Program Participation> Homeless> Primary Night Time Residence	homeless.primaryNightTimeResidence
homelessProgramServices	Indicates the service(s) being provided to the Student by the Homeless Program.	This is optional, does not report.	O
homelessUnaccompaniedYouth	A homeless unaccompanied youth is a youth who is not in the physical custody of a parent or guardian and who fits the McKinney-Vento definition of homeless. Students must be both unaccompanied and homeless to be included as an unaccompanied homeless youth.	If Unaccompanied Youth = Yes on the Homeless record, report 'TRUE'. Otherwise, report 'FALSE'.	O	Student Information> Program Participation> Homeless> Unaccompanied Youth	homeless.unacommpaniedYouth
reasonExitedDescriptor	This descriptor defines the reason a student exited a program.	This is optional, does not report.	O
servedOutsideRegularSession	Indicates whether the Student received services during the summer session or between sessions.	This is optional, does not report.	O

Type/Descriptors

Click here to expand...

Homeless Primary Nighttime Residence Descriptor

Code Value	Description
Shelters and Transitional Housing	Shelters and Transitional Housing
Doubled-up	Doubled-up
Hotels/Motels	Hotels/Motels
Unsheltered	Unsheltered
Unknown - do not send wo WISE