Reenrollments Change Audit

Contents

Introduction

Districts must first enable the plugin DCF: USA OH Audit. Navigate to System > System Settings > Plugin Management Configuration > DCF: USA OH Audit to enable the plugin. The report will export a comma separated value file indicating reenrollment changes or deletes within the time frame chosen in the report parameters.

Selection Criteria

Selection criteria determine which database records are used in the report. For the Reenrollments Change Audit report, student reenrollment records from the AU_Reenrollments table are selected.

School Selection

The report selects which school records to use based on the following criteria:

The school must be associated with a student included in the report.

Student Selection

Students are selected where a record exists with a date that falls within the report start and end dates in the AU_Reenrollments table.

Report Setup

To set up PowerSchool for this report:

Navigate to Start Page > System > System Settings > Plugin Management Configuration > DCF: USA OH Audit enabled.

Report Input

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

Field	Description
Schools for which to run?	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	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. Note: If running the report for a single student, or group of students, select the students prior to running report.
Report Start Date	This represents the earliest date of changes made to the reenrollment record.
Report End Date	This represents the latest date of changes made to the reenrollment record.
Scheduling
Run Now	Select this option to execute the report in the order it is received in the report queue.
Schedule (available Version 7.1.1.)	Enter the start date and start time for the report. Select Run Once and Submit to run the report at the specified date and time. Select Repeat to set future dates (Daily, Weekly, Monthly, Yearly) and Submit.

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.

Note: For documentation of XML report output from the state department of education, refer to http://www.ode.state.oh.us.

Column #	Data Element	Description	[Table]FieldName
1	Who Modified	The name of person who made the change.	[AU_Reenrollments]WHOMODIFIEDID
2	User Type	The user type of the person who made the change.	[AU_Reenrollments]WHOMODIFIEDTYPE
3	IP Address	The IP address of the computer used to make the change.	[AU_Reenrollments]IP_ADDRESS
4	Change Date	The date the change was made.	[AU_Reenrollments]TRANSACTION_DATE
5	Change Type	Indicates the type of change: update, insert or delete. Table values are saved as U, I, or D	[AU_Reenrollments]DML_TYPE
6	Record DCID	The DCID associated with the reenrollment record that was changed.	[AU_Reenrollments]DCID
7	Record ID	The ID associated with the reenrollment record that was changed.	[AU_Reenrollments]ID
8	Student ID	The student's ID associated with the reenrollment change.	[AU_Reenrollments]StudentID
9	Student Name	The student's first and last name comma separated as last, first.	Derived
10	Student Number	The student_number of the student associated with the change.	Derived
11	SSID	The state student number of the student associated with the change.	Derived
12	Old Entry Date	The previous (old) entry date associated with this record.	[AU_Reenrollments]O_ENTRYDATE
13	New Entry Date	The new entry date associated with this record.	[AU_Reenrollments]N_ENTRYDATE
14	Old Entry Code	The previous (old) entry code associated with this record.	[AU_Reenrollments]O_ENTRYCODE
15	New Entry Code	The new entry code associated with this record.	[AU_Reenrollments]N_ENTRYCODE
16	Old Exit Date	The previous (old) exit date associated with this record.	[AU_Reenrollments]O_EXITDATE
17	New Exit Date	The new exit date associated with this record.	[AU_Reenrollments]N_EXITDATE
18	Old Exit Code	The previous (old) exit code associated with this record.	[AU_Reenrollments]O_EXITCODE
19	New Exit Code	The new exit code associated with this record.	[AU_Reenrollments]N_EXITCODE
20	Old School ID	The previous (old) school id associated with this record.	[AU_Reenrollments]O_SCHOOLID
21	New School ID	The new school id associated with this record	[AU_Reenrollments]N_SCHOOLID
22	Old Grade Level	The previous (old) grade level associated with this record.	[AU_Reenrollments]O_GRADE_LEVEL
23	New Grade Level	The new grade level associated with this record.	[AU_Reenrollments]N_GRADE_LEVEL

Back to Top