Student Address

Introduction

Extracts student addressess for the specified date range. The physical address is extracted from the Home Address fields and mailing address is extracted from the Mailing Address fields.

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.

Students Selection

The report selects records from the [Students] table based on the following criteria:

Address must be entered in Address Line 1 and Line 2. Address Line is reported blank.
Student must at least have a Home Address in the system. If Home Address does not exist, the address field is left blank except the last updated element.
The school must not be excluded from state reporting.
The student must not be excluded from enrollment reporting.

Report Input

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

Field	Description
Select Schools	Choose one of the following: Current School Only – This option is for troubleshooting purposes and Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – This option is only available when running the report from the District Office. Includes all student records on the PowerSchool server that meet selection criteria.
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 school or district that meet the selection criteria. If running the report for a single student, or group of students, select the students prior to running report.
Start Date	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy for the first day of the report date range.
End Date	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy for the last day of the report date range.
SFTP Connections

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Name	Field Length
1	idPersonId	The unique student identification number assigned by the state.	[Students]State_StudentNumber	State Student ID	9
2	addressType	The type of address reported for the student.	NA	NA	1
3	addressLine1	The first line of the address. Generally contains a building/house number, street name, post office number, etc. Do not use post office box number for the physical address.	Physical: [Students]Street Mailing: [Students]Mailing_Street	Home Address Street Mailing Address Street	60
4	addressLine2	The second line of the address. Generally contains additional information such as apartments, suites, ATTN, company name, C/O or delivery instructions.	NA	NA	60
5	addressCity	The name of the city in which this address is located.	Physical: [Students]City Mailing: [Students]Mailing_City	Home Address City Mailing Address City	50
6	addressState	The two-character abbreviation of the state.	Physical: [Students]State Mailing: [Students]Mailing_State	Home Address State Mailing Address State	2
7	addressZipCode	The five or nine digit zip code for the mailing address.	Physical: [Students]ZIP Mailing: [Students]Mailing_ZIP	Home Address ZIP Mailing Address ZIP	9
8	lastUpdated	The date the student’s address record was last updated. If unavailable, the date the student record was last updated.	[Students]Transaction_Date	NA	10