xpms.dim_department
TablaSeguridad a nivel de fila activa
The ten locked department classes (Bible tab 01, Section 3.2), listed in numeric order. 4000 is Environment.
Clave primaria: dept_code
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| dept_code | xpms.canon_code | No | Four-digit class code, 0000 to 9000. |
| department | xpms.canon_text | No | Department label in Title Case. |
| source | xpms.canon_text | No | Where the class comes from in canon (canon). |
| note | xpms.canon_text | Sí | Bible note, such as the 4.0 label correction for 4000. |
| executive_lead | xpms.canon_text | Sí | EXECUTIVE LEAD from the Playbook Departments sheet. |
| core_function | xpms.canon_text | Sí | CORE FUNCTION from the Playbook Departments sheet. |
| scope | xpms.canon_text | Sí | SCOPE from the Playbook Departments sheet. |
| source_row | integer | Sí | Row of the Playbook sheet that mirrors this canon row; NULL when the Playbook has no such row. |
| source_status | xpms.canon_text | Sí | STATUS as recorded on the Playbook row (for example Active). |
| source_created_by | xpms.canon_text | Sí | CREATED BY as recorded on the Playbook row. |
| source_created_at | timestamp without time zone | Sí | CREATED AT as recorded on the Playbook row: a wall-clock time; the Playbook records no time zone. |
| source_updated_at | timestamp without time zone | Sí | UPDATED AT as recorded on the Playbook row: a wall-clock time; the Playbook records no time zone. |