Extract Specification
Records: 1
| ID | Specification Code | Version No | Selection Criteria | Ordering Rule | Deduplication Rule | Transformation Rule | Masking Rule | Control Total Requirements | Sample Query Reference | Approved By | |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
1 | SPEC-PAYTXN | 1 | pay_date between 2025-07-01 and 2026-06-30. | employee_id, pay_date | Distinct on (employee_id, pay_date, gross_amount). | - | Exclude TFN and bank account entirely. | Provide record count and sum of gross_amount. | - | Audit Data Manager |