xpms.dim_category
TableRow level security on
Categories (Bible tab 03). The category URID DDDD.DD.DD is the universal semantic key; there is no fourth segment.
Primary key: cat_urid
| Column | Type | Nullable | Description |
|---|---|---|---|
| cat_urid | xpms.canon_code | No | Category URID DDDD.DD.DD. |
| disc_code | xpms.canon_code | No | Discipline the category belongs to.References xpms.dim_discipline.disc_code |
| category | xpms.canon_text | No | Category label in Title Case. |
| source | xpms.canon_text | No | Origin of the category: canon or a tagged extension source. |
| xyz | xpms.xyz_tag | Yes | SCHEMA FAMILY (XYZ) from the Playbook Categories & URID Master sheet: X Resource, Y Process, Z Timeline. |
| is_extension | boolean | No | True when the discipline or category segment is .50 to .99. |
| 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. |