xpms.dim_department
TableRow level security on
The ten locked department classes (Bible tab 01, Section 3.2), listed in numeric order. 4000 is Environment.
Primary key: dept_code
| Column | Type | Nullable | Description |
|---|---|---|---|
| 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 | Yes | Bible note, such as the 4.0 label correction for 4000. |
| executive_lead | xpms.canon_text | Yes | EXECUTIVE LEAD from the Playbook Departments sheet. |
| core_function | xpms.canon_text | Yes | CORE FUNCTION from the Playbook Departments sheet. |
| scope | xpms.canon_text | Yes | SCOPE from the Playbook Departments sheet. |
| source_row | integer | Yes | Row of the Playbook sheet that mirrors this canon row; NULL when the Playbook has no such row. |
| source_status | xpms.canon_text | Yes | STATUS as recorded on the Playbook row (for example Active). |
| source_created_by | xpms.canon_text | Yes | CREATED BY as recorded on the Playbook row. |
| source_created_at | timestamp without time zone | Yes | 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 | Yes | UPDATED AT as recorded on the Playbook row: a wall-clock time; the Playbook records no time zone. |