xpms.dim_role
TablaSeguridad a nivel de fila activa
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).
Clave primaria: role_code
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| 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.Hace referencia a xpms.dim_department.dept_code |
| staffing_ratio | numeric | Sí | Staffing ratio, read with ratio_basis. |
| ratio_basis | xpms.canon_text | Sí | Basis of the staffing ratio. |
| kit_basis | xpms.canon_text | Sí | Kit or scheduling basis. |
| job_title | xpms.canon_text | Sí | Job title, where canon names one. |