Student Homeless Program Association

Resource Overview

Ed-Fi endpoint: /data/v3/studentHomelessProgramAssociations
Published view/entity: Student Homeless Programs
Purpose: Homeless programs that a student participates in or receives services from
Source query: StudentHomelessProgAssoc
Dependencies: studentSchoolAssociations

This association represents the homeless program for the student.

Primary PowerSchool Source Data

[Students]
[S_TN_STU_X]
[S_TN_REN_X]

Selection Criteria

Records are published if the following criteria are met:

The student's school of enrollment must not be excluded from state reporting.
The student's school of enrollment must have an Ed-Fi State School number.
The student must not be excluded from state reporting.
A student record has been published for the student.

Resource Output

Data Element (Ed-Fi target)	Data View Column Name	Submission	[Table]Field (PowerSchool Source)	Business Rules	Comments
beginDate	BeginDate	Y	[CST_PUBPUBLISHED_TMP]RUNTIMEPROP_3; [S_TN_STU_STUCLASSIFICATION_C]BeginDate; [CST_PUBENROLLMENT_TMP]entryDate; Transformation: CASE WHEN tmp.RUNTIMEPROP_3 = 'C' THEN TO_CHAR(tnStuClassC.BeginDate, 'YYYY-MM-DD') ELSE TO_CHAR(enr.entryDate, 'YYYY-MM-DD') END	Required by the production resource definition when the resource is published.	JSON type: datetime. Query alias: BeginDate.
educationOrganizationReference.educationOrganizationId	LEAOrgID	Y	Staging rule: studentHomelessProgAssoc CST_PUBWORKFLOW.formatLEADistrictIDBase(p_profileid, 0, 0, 'districtnumber', 1)	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: LEAOrgID.
programReference.educationOrganizationId	EduOrgID	Y	Staging rule: studentHomelessProgAssoc '630'	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: EduOrgID.
programReference.programName	ProgramName	Y	Staging rule: studentHomelessProgAssoc 'Homeless'	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: ProgramName.
programReference.programTypeDescriptor	ProgramType_DX	Y	Staging rule: studentHomelessProgAssoc 'Homeless'	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: ProgramType_DX.
studentReference.studentUniqueId	StudentUID	Y	[Students]DCID; Transformation: EDFI_TN_LIB.getStudentUniqueId(p_profileid, stu.dcid)	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: StudentUID.
awaitingFosterCare	AwaitingFosterCare	Conditional	Staging rule: studentHomelessProgAssoc null	Submit when the source alias is populated and the parent structure is applicable.	JSON type: string. Query alias: AwaitingFosterCare.
endDate	EndDate	Conditional	[CST_PUBPUBLISHED_TMP]RUNTIMEPROP_3; [S_TN_STU_STUCLASSIFICATION_C]EndDate; [CST_PUBENROLLMENT_TMP]EndDate; Transformation: CASE WHEN tmp.RUNTIMEPROP_3 = 'C' THEN CASE WHEN tnStuClassC.EndDate IS NOT NULL THEN TO_CHAR(tnStuClassC.EndDate-1, 'YYYY-MM-DD') ELSE null END ELSE TO_CHAR(enr.endDate, 'YYYY-MM-DD') END	Submit when the source alias is populated and the parent structure is applicable.	JSON type: datetime. Query alias: EndDate.
homelessPrimaryNighttimeResidenceDescriptor	HomelessNighttimeResidence	Conditional	[S_TN_STU_X]HomelessPrimaryNightTimeRes; Transformation: case WHEN tnStuX.HomelessPrimaryNightTimeRes= '01' THEN 'Shelters' WHEN tnStuX.HomelessPrimaryNightTimeRes= '02' THEN 'Doubled-up' WHEN tnStuX.HomelessPrimaryNightTimeRes= '03' THEN 'Unsheltered' WHEN tnStuX.HomelessPrimaryNightTimeRes= '04' THEN 'Hotels/motels' END	Submit when the source alias is populated and the parent structure is applicable.	JSON type: string. Query alias: HomelessNighttimeResidence.
homelessProgramServices[].homelessProgramServiceDescriptor	HomelessProgramService_DX	Conditional	[CST_PUBENROLLMENT_TMP]Record_type; [S_TN_STU_X]HomelessServedByMcKinney; [S_TN_REN_X]HomelessServedByMcKinney; transformation: CASE WHEN (enr.record_type = 'S' AND UPPER(tnStuX.HomelessServedByMcKinney) = 'Y') OR (enr.record_type = 'R' AND UPPER(tnRenX.HomelessServedByMcKinney) = 'Y') THEN 'Mckinney-Vento' ELSE null END	Submit when the source alias is populated and the parent structure is applicable.	JSON type: string. Query alias: HomelessProgramService_DX.
homelessProgramServices[].primaryIndicator	PrimaryIndicator	Conditional	Staging rule: studentHomelessProgAssoc null	Submit when the source alias is populated and the parent structure is applicable.	JSON type: string. Query alias: PrimaryIndicator.
homelessProgramServices[].serviceBeginDate	ServiceBeginDate	Conditional	Staging rule: studentHomelessProgAssoc null	Submit when the source alias is populated and the parent structure is applicable.	JSON type: datetime. Query alias: ServiceBeginDate.
homelessProgramServices[].serviceEndDate	ServiceEndDate	Conditional	Staging rule: studentHomelessProgAssoc null	Submit when the source alias is populated and the parent structure is applicable.	JSON type: datetime. Query alias: ServiceEndDate.
homelessUnaccompaniedYouth	HomelessUnaccompaniedYouth	Conditional	[CST_PUBENROLLMENT_TMP]Record_type; [S_TN_STU_X]HomelessUnaccompaniedYouth; [S_TN_REN_X]HomelessUnaccompaniedYouth; transformation: CASE WHEN enr.record_type = 'S' THEN DECODE(tnStuX.HomelessUnaccompaniedYouth, 'Y', 1, 0) WHEN enr.record_type = 'R' THEN DECODE(tnRenX.HomelessUnaccompaniedYouth, 'Y', 1, 0) END	Submit when the source alias is populated and the parent structure is applicable.	JSON type: boolean. Query alias: HomelessUnaccompaniedYouth.
reasonExitedDescriptor	ExitReason_DX	Conditional	Staging rule: studentHomelessProgAssoc null	Submit when the source alias is populated and the parent structure is applicable.	JSON type: string. Query alias: ExitReason_DX.
servedOutsideOfRegularSession	ServedOutsideOfRegularSession	Conditional	Staging rule: studentHomelessProgAssoc null	Submit when the source alias is populated and the parent structure is applicable.	JSON type: boolean. Query alias: ServedOutsideOfRegularSession.