Resources Checklist

Audit-grade golden records: a twelve-point checklist.

What an auditor asks about a golden record, and the evidence that answers each question.

THE TWELVE POINTS01Source, rule and time per value02Every source key kept03Merges can be undone04Versioned thresholds05Rule results stored06Dated hierarchy versions07Certified security changes08Sensitive reads logged09Uncapped audit trail10Point-in-time reads11Chained entries12Signed extracts
The checklist

#The pointThe evidence
1Every value carries its source, rule and timethe survivorship view per field
2Every source key is keptthe cross-reference as a join
3A merge can be undoneunmerge with history
4Thresholds are versionedconfiguration history
5Rule results are stored with the rows judgedrule runs with versions
6Hierarchy changes are versions with dateshierarchy history
7Security changes are approved and certifiedpolicy history and the quarterly certification
8Sensitive reads are logged with a purposethe ledger
9The audit trail has no cap and includes rule and agent changesthe ledger
10A point-in-time read covers master data and transactionsAS OF in SQL
11Entries are chainedhash chain
12Extracts are signedthe audit pack
How to use it

Ask for each item to be shown on screen with your data, and for the query that produces it. A point that needs a report request or a support ticket to answer scores half.

See your first domain built on your data

Bring two systems that hold the same customers, suppliers or materials. In one working day we connect them, run the match on live rows, review the queue with your steward and publish the first golden view with its API.