xpms.role

TableRow level security on

The Roles Library (decision D12): owns role codes and job titles. Department derives from the code and is not stored.

Primary key: role_code

Columns of xpms.role
Column	Type	Nullable	Description
role_code	xpms.canon_code	No	Role code DDDD.DD.DD.
class_code	xpms.canon_code	No	Department class, derived from the role code.References xpms.dim_department.dept_code
job_title	xpms.canon_text	No	Job title; the one home of the title.
discipline	xpms.canon_text	No	Discipline.References xpms.role_discipline.name
rank	xpms.canon_text	No	Rank.References xpms.role_rank.label
job_summary	xpms.canon_text	Yes	JOB SUMMARY from the Playbook Roles Library sheet.
key_responsibilities	xpms.canon_text	Yes	KEY RESPONSIBILITIES from the Playbook Roles Library sheet.
qualifications	xpms.canon_text	Yes	QUALIFICATIONS from the Playbook Roles Library sheet.
physical_requirements	xpms.canon_text	Yes	PHYSICAL REQUIREMENTS from the Playbook Roles Library sheet.
required_certifications	xpms.canon_text	Yes	REQUIRED CERTIFICATIONS from the Playbook Roles Library sheet.
default_clearance_tier	xpms.canon_text	Yes	DEFAULT CLEARANCE TIER from the Playbook Roles Library sheet.
default_radio_channel	xpms.canon_text	Yes	DEFAULT RADIO CHANNEL from the Playbook Roles Library sheet.
flag	boolean	Yes	FLAG from the Playbook Roles Library sheet.
notes	xpms.canon_text	Yes	NOTES from the Playbook Roles Library 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.