LA EdLink Homeless Services
On this page:
Introduction
This report collects homeless services information and creates an extract file for submission to the EdLink warehouse. Use PowerSchool's Remote Connection Management feature to set up a SFTP connection to allow for automatic uploading of files to EdLink. Use with the report's scheduling feature to set up a recurring upload of files to EdLink.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Student Selection
The report selects records from the [Students] table that meet the following criteria:
- The student’s school exit date must occur after the school year start date.
- The student’s school entry date must occur on or before the school year end date.
- The student’s school entry date must occur on or before the report run date (Pre-registered students will not be included in the file).
- The student’s school exit date must occur after their school entry date.
- The student, the student’s school, and the student’s school enrollment must not be excluded from state reporting.
- the student must have Homeless Services identified under the 'Services Provided to Student' section on the Homeless tab.
- Students with entry and exit dates for the same day will be included in the file.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools | Indicate which schools to include in the report by selecting from the following options: If sub-districts are not enabled:
If sub-districts are enabled:
|
Select Students | Indicate which students to include in the report by selecting one of the following options:
If you are running the report for a single student, or a group of students, select the students before running the report. |
School Year | Select the school year for which to run the report. The options are controlled by the Term currently selected by the user. |
Identify as a Partial File | Select this checkbox if the file being generated is not including all students that should be reported to EdLink. As a partial file, the file name will have '_partial' plus a unique number added to the name to ensure each file is unique when it is uploaded to EdLink. |
SFTP connections | If the extract is to be automatically uploaded to EdLink, select the SFTP connection that has been defined for reporting to EdLink. |
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Data Element | Description | [Table]FieldName |
SCHOOL_YEAR | The year of a school session. Required. | Derived from: [Term]First Day [Term]LastDay |
LOCAL_STUDENT_KEY | The student’s state-assigned identifier. Required. | [Students]State_StudentNumber |
HOMELESS_SERVICES_CODE | A unique identifier of each homeless service record submitted. Required. Valid values:
If NULL, this field is extracted as a <tab> <tab> in the report. | [S_LA_STU_Homeless_C]HomelessService_(Service Code)_(Month) where (Service Code) is a numeric value from 01 to 21 representing the service delivered to the student and where (Month) is the month the service was delivered. |
HOMELESS_STUDENT_TYPE | The type of student for which the homeless data is being submitted. Valid values:
If NULL, this field is extracted as a <tab> <tab> in the report. | [Students]Homeless_TypeOfStudent [S_LA_REN_X]Homeless_TypeOfStudent |
JANUARY_SERVICE_INDICATOR | Identifies whether or not the service was provided during January. | [S_LA_STU_Homeless_C]HomelessService_(Service Code)_JAN where (Service Code) is a numeric value from 01 to 21 representing the service delivered to the student |
FEBRUARY_SERVICE_INDICATOR | Identifies whether or not the service was provided during February. | [S_LA_STU_Homeless_C]HomelessService_(Service Code)_FEB where (Service Code) is a numeric value from 01 to 21 representing the service delivered to the student |
MARCH_SERVICE_INDICATOR | Identifies whether or not the service was provided during March. | [S_LA_STU_Homeless_C]HomelessService_(Service Code)_MAR where (Service Code) is a numeric value from 01 to 21 representing the service delivered to the student |
APRIL_SERVICE_INDICATOR | Identifies whether or not the service was provided during April. | [S_LA_STU_Homeless_C]HomelessService_(Service Code)_APR where (Service Code) is a numeric value from 01 to 21 representing the service delivered to the student |
MAY_SERVICE_INDICATOR | Identifies whether or not the service was provided during May. | [S_LA_STU_Homeless_C]HomelessService_(Service Code)_MAY where (Service Code) is a numeric value from 01 to 21 representing the service delivered to the student |
JUNE_SERVICE_INDICATOR | Identifies whether or not the service was provided during June. | [S_LA_STU_Homeless_C]HomelessService_(Service Code)_JUN where (Service Code) is a numeric value from 01 to 21 representing the service delivered to the student |
JULY_SERVICE_INDICATOR | Identifies whether or not the service was provided during July. | [S_LA_STU_Homeless_C]HomelessService_(Service Code)_JUL where (Service Code) is a numeric value from 01 to 21 representing the service delivered to the student |
AUGUST_SERVICE_INDICATOR | Identifies whether or not the service was provided during August. | [S_LA_STU_Homeless_C]HomelessService_(Service Code)_AUG where (Service Code) is a numeric value from 01 to 21 representing the service delivered to the student |
SEPTEMBER_SERVICE_INDICATOR | Identifies whether or not the service was provided during September. | [S_LA_STU_Homeless_C]HomelessService_(Service Code)_SEP where (Service Code) is a numeric value from 01 to 21 representing the service delivered to the student |
OCTOBER_SERVICE_INDICATOR | Identifies whether or not the service was provided during October. | [S_LA_STU_Homeless_C]HomelessService_(Service Code)_OCT where (Service Code) is a numeric value from 01 to 21 representing the service delivered to the student |
NOVEMBER_SERVICE_INDICATOR | Identifies whether or not the service was provided during November. | [S_LA_STU_Homeless_C]HomelessService_(Service Code)_NOV where (Service Code) is a numeric value from 01 to 21 representing the service delivered to the student |
DECEMBER_SERVICE_INDICATOR | Identifies whether or not the service was provided during December. | [S_LA_STU_Homeless_C]HomelessService_(Service Code)_DEC where (Service Code) is a numeric value from 01 to 21 representing the service delivered to the student |
UNACCOMPANIED_YOUTH_INDICATOR | Indicates whether the student is an unaccompanied youth. Required if the Homeless_Student_Type is 02 or 03; otherwise, an "N" is reported. | [S_LA_STU_X]UnaccompaniedYouth_TF |