xpms.dim_category
TablaSeguridad a nivel de fila activa
Categories (Bible tab 03). The category URID DDDD.DD.DD is the universal semantic key; there is no fourth segment.
Clave primaria: cat_urid
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| cat_urid | xpms.canon_code | No | Category URID DDDD.DD.DD. |
| disc_code | xpms.canon_code | No | Discipline the category belongs to.Hace referencia a 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 | Sí | 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 | 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. |