The Physical Delete Processor will physically remove (delete), from the PASI database, records that are deemed to be transitory. This process will be run in the evening in Production and set to run once an hour in the test environments. Parent Records (and all associated child records) that are logically deleted for 30 days will qualify for the process.

Records that qualify for disposable using this processor are:

• Records with Is Deleted = True, and
• The Last Updated On is greater than 30 calendars days in the past.

The following type of records will be considered by this processor:

• Authorized User
  • Authorized User Audit Event
• Awarded Student Credential
  • Awarded Student Credential Audit Event
• Classroom Accommodation
  • Classroom Accommodation Audit Event
  • Classroom Accommodation Status Processor Trigger
  • Submit Classroom Accommodation Status Acknowledgement
• Course Enrolment
  • Course Enrolment Audit Event
  • Course Enrolment Status Processor Trigger
  • Submit Course Enrolment Status Acknowledgement
• Diploma Exam Registration Request
• Diploma Exam Mark
  • Diploma Exam Mark Audit Event
  • Diploma Exam Mark Component
  • Diploma Exam Mark Component Audit Information
• Diploma Exam Registration Fee
• Diploma Exam Sitting
  • Diploma Exam Sitting Audit Event
• Diploma Exam Waived Fee
• Electronic Notes
• Evaluated Mark
  • Evaluated Mark Audit Event
  • Evaluated Mark Status Processor Trigger
  • Submit Evaluated Mark Status Acknowledgement
• GED Exam Mark
  • GED Exam Mark Audit Event
• Home Education Notification
• Home Education Registration
  • Home Education Registration Audit Event
• Information Disclosure Restriction
• Medical Alert
• myPass Connection
  • myPass Connection Audit Event
• Official Mark
  • Official Mark Audit Event
  • Official Mark Selection
• Parent/Guardian
  • Parent/Guardian Audit Event
• Pathway Completion
  • Pathway Completion Audit Event
• Responsible School
  • Audit Event
  • Validation Status
  • Responsible School Status Processor Trigger
• Section
  • Section Audit Event
  • Section Status Processor Trigger
  • Submit Section Status Acknowledgement
• Student Address
• Student Citizenship
• Student Credential Requirement Achievement
  • Student Credential Requirement Achievement Audit Event
• Student Credential Requirement Exemption
  • Student Credential Requirement Exemption Audit Event
• Student Email
• Student External Credential
  • Student External Credential Audit Event
• Student Name
• Student Phone Number
• Student Record Custodian
• Student School Enrolment
  • Student School Enrolment Audit Event
  • Student School Enrolment Status Processor Trigger
  • Submit Student School Enrolment Status Acknowledgement
• Validation Status
  • Core Alert

• A trigger that permanently fails will be updated and re-processed the next time the cache is loaded.
• The trigger is tracked (in memory) the first time it fails so it can be ignored upon re-entry (to avoid an infinite loop).
• The next time the cache is loaded any triggers created after the original failed trigger was updated will be processed again.
• If the data is not fixed, the trigger will fail everyday and be updated everyday on each node.
• The next day the cache is loaded the trigger would be updated after the cache loads.
• In this case everything that was triggered throughout the day will have to be re-processed the next day.

The output of the processor is to physically delete all records (including all child records and status records related to the parent record identified above) that have been deemed transitory. Additionally, all records that have been deleted will have an entry written to the Deleted Record Audit table.