Review Physical Delete Exceptions Report
The Review Physical Delete Exceptions Report is one of the PASI Nightly Reports and is responsible for highlighting records that have been logically deleted for more than 30 days, but were not physically deleted as at least one of the 'child records' was updated after the 'parent record' was deleted.
This report is produced everyday at 6:00 am and results in a report being generated and distributed via email.
Generated 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}. |
Email Attachment
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. |