Attendance – SQL Script to delete duplicate attendance data in bulk for LA’s (3.76)

Description

A SQL script is available to delete duplicate attendance data in bulk.

• Script to manage delete duplicate attendance data on mass for LA’s.

The script will:

• Identify and correct all duplicate student attendance records so that a student has a single attendance record for school / academic year combination
• Produce a summary output for any duplicate student attendance information that has been deleted for an audit purpose

Once that script is run using SQL Plus or similar, it will generate a CSV output file with a list of records being deleted. Users can verify the details in that file and can commit / rollback as required.

The following message will be displayed after the list of students:

If records have been identified and displayed these are duplicate attendance records and will be deleted. If you are happy with these results, please commit changes else rollback.

Click image to enlarge. Use browser back button to return.