xpms.dim_discipline
TableRow level security on
Disciplines (Bible tab 02): canon codes .01 to .49 and adopter extensions .50 to .99 within a department.
Primary key: disc_code
| Column | Type | Nullable | Description |
|---|---|---|---|
| disc_code | xpms.canon_code | No | Discipline code DDDD.DD. |
| dept_code | xpms.canon_code | No | Department class the discipline belongs to.References 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 | 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. |