Metadata Catalogue
6 of 6 tables
| Table | Source | Description | Sensitivity | Quality | Updated |
|---|---|---|---|---|---|
| HR.EMPLOYEE_MASTER | HR Oracle Prod | Authoritative record of all employees including personal identifiers, employment status, and organisational unit. Generated 14:02 by AI classifier. | PII | 92 | 2 hours ago |
| FIN.PAYROLL_RUN | Finance SQL Server | Monthly payroll execution table with gross/net pay, tax and pension contributions per employee per pay period. | Restricted | 88 | 5 hours ago |
| REG.RTI_SUBMISSION | Regulatory S3 Lake | HMRC Real Time Information submissions for PAYE reporting. Authoritative regulatory record. | Official | 95 | 1 day ago |
| ANALYTICS.WORKFORCE_FACT | Analytics Snowflake | Aggregated workforce fact table for executive dashboards. Headcount, attrition, diversity metrics by month/grade/dept. | Official | 78 | 1 day ago |
| CITIZEN.APPLICATION | Citizen Postgres | Public-facing citizen service application records. Contains identifiers, contact details, application state. | PII | 84 | 12 hours ago |
| REF.DEPARTMENT | HR Oracle Prod | Reference list of departments and organisational hierarchy. | Public | 99 | 2 days ago |