Create history/journal tables for auditing purposes

bcgov / SIMS

Student Information Management System. Post-Secondary Student Financial Aid System

Apache License 2.0

21 stars 13 forks source link

Create history/journal tables for auditing purposes #3223

Open JasonCTang opened 1 month ago

JasonCTang commented 1 month ago

User Story As a Privacy and Security Officer (David Malcolm), I need the ability to determine when records were updated, what was updated and who updated them.C

Cloned record in journal table each time a record is inserted.
Cloned record in journal table each time any field is updated.

Acceptance Criteria

sslaws commented 3 weeks ago

Jason to determine what tables we need to journal.