Update Homeroom

Contents

Introduction

This report identifies the homeroom class of the student and updates the Home_Room field in the database with the name of the teacher.

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 must be enrolled in a school included in the report and the school must not be excluded from state reporting.
The student must be actively enrolled in the school on the snapshot date, i.e. his/her enroll status must be 0 (zero).

Class Enrollment Selection

The report selects records from the [CC] table that meet the following criteria:

The enrollment must be assigned to a student included in the report.
The enrollment must be assigned to a school included in the report.
The enrollment start date must occur on or before the snapshot date.
The enrollment end date must occur on or after the snapshot date.
The enrollment must be associated with a section that is marked “Designate as Homeroom” on the Edit Section page.
The enrollment must be associated with a teacher.

Report Input

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

Field	Description
Use	If run at the district level, choose one of the following from the pop-up menu: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Current School Only – Includes all records associated with the current school that meet the selection criteria. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. 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.
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyyor mm-dd-yyyyin order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05.
Snapshot Date	Enter the snapshot date.

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.

Item #	Data Element	Description	[Table]FieldName
1	Student ID	The student’s internal ID.	[Students]ID
2	School ID	The school ID.	[Schools]ID
3	Name	The first and last name of the student in the format: last, first.	[Students]LastFirst
4	Teacher	Indicates the homeroom teacher	N/A

Back to Top