School Conflicts Audit File

Contents

Introduction

Generates a list of students who have transferred between schools within the district but the process is incomplete.

Known Issue Description: If a student is attending a school and then transfers to another school within the district, but there is a delay between leaving the first school and entering the second school, some Consolidated Collections reports may be incorrect when the report is run during the delay period.

Known Issue Resolution: When students transfer between schools, the transfer procedure must be completed to ensure the student's records are reported correctly. Until the student is successfully enrolled in their new school, some Consolidated Collections reports may be incorrect.

The transfer procedure includes three steps to be considered complete:

Start Page > Student Selection > Functions > Transfer Student Out
Start Page > Student Selection > Functions > Transfer to Another School
Start Page > Student Selection > Functions > Re-Enroll Student

The purpose of this report is to identify students who have not been reenrolled at the second school. The output shows student details plus [Students]SchoolID and [Students]Enrollment_SchoolID that not match.

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 occurred during the current school year, based on the following criteria:

When a start date and end date are provided to the report then students with enrollments within the date range are selection for report inclusion.
The Start Date must be on or before the last day of the current term.
The End Date must be on or after the last day of the current term.
The Start Date must be before the End Date.

Back to Top

Report Input

To generate the School Conflicts Audit File report, do the following:

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

Field	Description
Report Start Date*	Enter a date in the format mm/dd/yyyy.
Report End Date*	Enter a date in the format mm/dd/yyyy.

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	Data Type	Field Length
1	Student Number	Students student number.	[Students]Student_Number	int	10
2	Student Name	Students name.	[Students]LastFirst	varchar	40
3	Enroll Status	Enrollment status description. Code is converted to words.	[Students]Enroll_Status	int	1
4	Entry Date	Students current entry date.	[Students]EntryDate	date	10
5	Exit Date	Students current exit date.	[Students]ExitDate	date	10
6	School ID	Value of student's current school.	[Students]SchoolID	varchar	4
7	School Name	School Name of student's current school.	[Schools]Name	varchar	40
8	EnrollmentSchool ID	Value of student's current enrollment school ID.	[Students]Enrollment_SchoolID	varchar	4
9	Enrollment School Name	School Name of student's current enrollment school ID.	[Schools]Name	varchar	40

Back to Top