Student Homeless Program Associations (Arizona 7.1)

This association represents the McKinney-Vento Homeless Program program(s) that a student participates in or from which the Student receives services.

This resource only sends with 24-25 configurations and future year configurations.

For 23-24 configurations and prior, Homeless information reports as part of the Student Needs Resource.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	Report a record when a student has a Homeless record that overlaps an enrollment in the current configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude If there are multiple enrollments, use the following priority list to determine which one should report: Primary > Partial > SPED Earliest Start Date Latest Enrollment ID
Delete/Post/Put	A DELETE / POST will be performed if the data element being altered is part of the resource's natural key. A PUT will be performed otherwise. When the following information on a Homeless record is changed: Homeless Program ID (New Homeless record) Start Date End Date Primary Night Time Residence Unaccompanied Youth When the following information on an Enrollment is changed: Enrollment ID (New Enrollment) Start Date End Date No Show State Exclude
Delete	When the enrollment being reported off of is deleted. When the enrollment is changed to no longer overlap the configured year. When the student is excluded through their enrollment, calendar, grade level, or school. When the Homeless record being reported off of is deleted. When the Homeless record is changed to no longer overlap the enrollment in the current configured year.

Action

Trigger

Post

Report a record when a student has a Homeless record that overlaps an enrollment in the current configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
If there are multiple enrollments, use the following priority list to determine which one should report:
- Primary > Partial > SPED
- Earliest Start Date
- Latest Enrollment ID

Delete/Post/Put

A DELETE / POST will be performed if the data element being altered is part of the resource's natural key. A PUT will be performed otherwise.

When the following information on a Homeless record is changed:
- Homeless Program ID (New Homeless record)
- Start Date
- End Date
- Primary Night Time Residence
- Unaccompanied Youth
When the following information on an Enrollment is changed:
- Enrollment ID (New Enrollment)
- Start Date
- End Date
- No Show
- State Exclude

Delete

When the enrollment being reported off of is deleted.
When the enrollment is changed to no longer overlap the configured year.
When the student is excluded through their enrollment, calendar, grade level, or school.
When the Homeless record being reported off of is deleted.
When the Homeless record is changed to no longer overlap the enrollment in the current 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.

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.

Resource Preferences

Data Element Label	Mapping Needed	Comments
homelessPrimaryNighttimeResidenceDescriptor	Homeless Primary Night Time Residence
homelessUnaccompaniedYouth	Homeless Unaccompanied Youth	This mapping only shows in states where the Unaccompanied Youth field is a droplist. If it is a checkbox, the mapping does not show.
Select the Program Type Descriptor associated with this Program.	Program Type Descriptor

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	Logic	M, C or O	Data Source GUI Path	Location
beginDate	Reports the latest of the following values: Homeless Start Date Enrollment Start Date Notes: If there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the earliest start date (where the start status is NOT ZZZ) for the enrollment start date Note, the enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status or be before or equal to the ZZZ end status	M		Homeless > Start Date Homeless.startDate
education Organization Reference	Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = School Entity ID	M		School Information > Ed-Fi School ID Schoool.entityID
programReference	Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationId = School Override District Entity ID If NULL, uses the District Entity ID programName = Homeless (Hard-Coded). programTypeDescriptor = McKinney-Vento Act (Hard-Coded).	M		School Information > District Entity ID District Information > Entity ID CustomSchool.value INNER JOIN CampusAttribute ON CustomSchool.attributeID = CampusAttribute.attributeID District.entityID
studentReference	Reports the fields that are part of the Natural Key for the Students resource.	M
endDate	Reports the earliest of the following dates: Homeless End Date Enrollment End Date Last Instructional Day of the Year Notes: If there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the earliest start date (where the start status is NOT ZZZ) for the enrollment start date The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status or be before or equal to the ZZZ end status	C		Homeless > End Date Homeless.enddate
homelessPrimary Nighttime ResidenceDescriptor	Report the Ed-Fi Code mapped to the value selected for Primary Night Time Residence.	O		Homeless > Primary Night Time Residence homeless.primaryNightTime Residence
homeless UnaccompaniedYouth	Report True when Unaccompanied Youth is Yes. Report False in all other situations.	O	Student Information> Program Participation>	Homeless > Unaccompanied Youth Homeless.unacommpanied Youth

Type/Descriptors

Click here to expand...

Homeless Primary Nighttime Residence Descriptor

IC Code	Ed-Fi Code	Description	Namespace
1	1	Sheltered	uri://ed-fi.org/HomelessPrimaryNighttimeResidenceDescriptor
2	2	Doubled Up	uri://ed-fi.org/HomelessPrimaryNighttimeResidenceDescriptor
3	3	Unsheltered	uri://ed-fi.org/HomelessPrimaryNighttimeResidenceDescriptor
4	4	Hotels/Motels	uri://ed-fi.org/HomelessPrimaryNighttimeResidenceDescriptor