xpms.dim_role
TableRow level security on
The 61 workforce roles (Bible tab 27) with function name, job title and staffing ratio. Role codes share the URID shape. Tab 27 no longer decides which role codes exist: owner decision 39 (2026-10-23) retires it as their authority in favor of the Roles Library, xpms.role (ruling D12).
Primary key: role_code
| Column | Type | Nullable | Description |
|---|---|---|---|
| role_code | xpms.canon_code | No | Role code DDDD.DD.DD. |
| role | xpms.canon_text | No | Function name of the role. |
| dept_code | xpms.canon_code | No | Department the role belongs to.References xpms.dim_department.dept_code |
| staffing_ratio | numeric | Yes | Staffing ratio, read with ratio_basis. |
| ratio_basis | xpms.canon_text | Yes | Basis of the staffing ratio. |
| kit_basis | xpms.canon_text | Yes | Kit or scheduling basis. |
| job_title | xpms.canon_text | Yes | Job title, where canon names one. |