The Review Physical Delete Exceptions Report is one of the PASI Nightly Reports and is responsible for highlighting the following two scenarios:
This report is produced everyday at 6:00 am and results in an Excel file being generated and distributed via email.
Sent To | PASITechnicalOpsTeam@gov.ab.ca |
---|---|
Subject | PASI Monitor: Review Physical Delete Exceptions for YYYY-MM-DD [Contains Records / No Records] |
Body |
This report is produced daily by PASI.Monitor running on {Server}. |
Attached to the email is a Microsoft Excel file that contains a summary of the records that were not deleted.
Parent Table | Identifies the parent table containing the records that were not deleted. |
---|---|
Child Table | Identifies the child table containing the records that were updated after the parent record was deleted. |
Num of Child Records Updated after Parent Records Deleted | Identifies the number of records in the child table updated after its parent record was deleted. |
Num of Child Records Were Deleted | Identifies the number of deleted records in the child table that were updated after its parent record was deleted. |
Num of Child Records Were Not Deleted | Identifies the number of non-deleted records in the child table that were updated after its parent record was deleted. |
Changes done in release 9.22: