H01 - Student Address

Introduction

The Student Record - Address report extracts student residential address data. One record is transmitted for each student at each school in the system.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The report selects records from the [Students] table that are associated with the schools included in the report. The record must have an entry and exit date for the school enrollment that occur during the report date range.

Back to Top

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. Select schools to include in the report 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.
Current Selection Students	Run the report for the current selection of students or all students.
Report Start Date	Enter the start date of the report. Note: Enter the date in a format of MM/DD/YYYY.
Report End Date	Enter the end date of the report. Note: Enter the date in a format of MM/DD/YYYY.
File Path and File Suffix	The File Path and File Suffix must both be valid in order to save the results to a location on the server. The File Name will be the district number, date, and time, in the format dddYYYYMMDDHHmi, followed by the provided file suffix. For example a report run at district 999 on August 1, 2014 at 9:15 AM with a suffix of _AAA.txt will save the results to a file named 999201408010915_AAA.txt in the provided location. If no path is given, or if PowerSchool is unable to write to the given folder, the report will run but will not be saved to the server.

Back to Top

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.

The students with Dexter Mosely set as Yes in the State Information page are not included in the report output.

ID	Data Element	Description	[Table]FieldName	Length
H001	Fiscal Year	The fiscal year of the record. The report extracts the year based on the last day in the current school calendar.	[Terms]LastDay	4
H002	Period	The reporting period. Always 1.	N/A	1
H003	System Code	The school system code. This is the district number in PowerSchool.	[Prefs]Value [Prefs]Name=districtnumber	3
H004	School Code	The school code. Note: If the HomeSchool Override Number is set up, it will be used. If not, the alternate school number is reported if populated. Otherwise, the school number is reported.	[S_GA_STU_X]SchoolNumberOverride [S_GA_REN_X]SchoolNumberOverride [Schools]Alternate_School_Number [Schools]School_Number [Students]SchoolID = [Schools]School_Number	4
H005	Filler		N/A
H006	Record Type	Identifies the record layout. Always H01.	N/A	3
H007	Address Line 1	The first line of the student's residential address.	[Students]Street	30
H008	Address Line 2	The second line of the student's residential address, if applicable. Note: This field is not available in PowerSchool.	N/A	30
H009	City	The student's residential city.	[Students]City	25
H010	State	The student's residential state.	[Students]State	2
H011	Zip Code	The student's residential zip code.	[Students]Zip	5
H012	GTID	The identification number assigned to each student to uniquely identify the student throughout his/her public education years in the Georgia public school system.	[Students]State_StudentNumber	10
Filler	Filler	Filler	N/A	11

Back to Top