Address Collection | PowerSchool SIS Compliance

Introduction

The administrators can use this report to submit student address, homelessness, and meal eligibility data to CSDE accurately for spring and fall reporting windows. The report reflects student data as of the selected date, including address data valid at that time. The output of the report is in the CSV format.

If address is data is not available, blank values are reported.

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

Only students with active enrollments as of the selected date are included.
Pre‑registered students, no‑Show students, and Early graduates are excluded.
Only the student’s mailing address is included.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Select Students	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current selected school(s) or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
As Of Date	The date as of which address data will be reported.

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.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	Reporting District	The three-digit code for the reporting school district.	[Prefs]Value where [Prefs]Name=districtnumber	Alpha-numeric	3
2	State Assigned Student ID	The student’s state-assigned student ID number.	[Students] State_StudentNumber [S_CT_STU_X]State_Student_ID	Numeric	10
3	Date of Birth	The student’s date of birth.	[Students]DOB	Date	8
4	Eligible for Free/Reduced Price Meals	Indicates if the student is eligible for free/reduced-price meals. Valid values: F - Free R - Reduced N - No	[S_CT_STU_X]Lunch_Certification, if populated. If [S_CT_STU_X]Lunch_Certification equals FS, AF, OT, or FM, a value of 'F' is reported. If [S_CT_STU_X]Lunch_Certification equals RM, a value of 'R' is reported. Otherwise: [Students]LunchStatus	Char	1
5	Homeless (based on McKinney‑Vento indicator)	Indicates the student's homeless code.	[S_CT_STU_Demographics_X]Homeless	Char	1
6	Address Line 1	The first line of the address.	[Students]Mailing_Street	Alpha-numeric	50
7	Address Line 2	The second line of the address. This is optional.	[Students]Mailing_Street	Alpha-numeric	50
8	City	The city to which the which the student belongs.	[Students]Mailing_City	Char	25
9	State Code	The state to which the which the student belongs.	[Students]Mailing_State	Alpha-numeric	2
10	Zip Code	The Zip code of the student’s address	[Students]Mailing_Zip	Numeric	9
11	End of Record Marker	X displays in this field.	Set to “X”