xpms.dim_discipline
TablaSeguridad a nivel de fila activa
Disciplines (Bible tab 02): canon codes .01 to .49 and adopter extensions .50 to .99 within a department.
Clave primaria: disc_code
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| disc_code | xpms.canon_code | No | Discipline code DDDD.DD. |
| dept_code | xpms.canon_code | No | Department class the discipline belongs to.Hace referencia a xpms.dim_department.dept_code |
| discipline | xpms.canon_text | No | Discipline label in Title Case. |
| source | xpms.canon_text | No | Origin of the discipline: canon, workforce, ramp-up or another tagged extension source. |
| is_extension | boolean | No | True when the discipline segment is .50 to .99 (an extension range). |
| 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. |