xpms.role

TablaSeguridad a nivel de fila activa

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

Clave primaria: role_code

Columnas de xpms.role
Columna	Tipo	Admite nulos	Descripción
role_code	xpms.canon_code	No	Role code DDDD.DD.DD.
class_code	xpms.canon_code	No	Department class, derived from the role code.Hace referencia a 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.Hace referencia a xpms.role_discipline.name
rank	xpms.canon_text	No	Rank.Hace referencia a xpms.role_rank.label
job_summary	xpms.canon_text	Sí	JOB SUMMARY from the Playbook Roles Library sheet.
key_responsibilities	xpms.canon_text	Sí	KEY RESPONSIBILITIES from the Playbook Roles Library sheet.
qualifications	xpms.canon_text	Sí	QUALIFICATIONS from the Playbook Roles Library sheet.
physical_requirements	xpms.canon_text	Sí	PHYSICAL REQUIREMENTS from the Playbook Roles Library sheet.
required_certifications	xpms.canon_text	Sí	REQUIRED CERTIFICATIONS from the Playbook Roles Library sheet.
default_clearance_tier	xpms.canon_text	Sí	DEFAULT CLEARANCE TIER from the Playbook Roles Library sheet.
default_radio_channel	xpms.canon_text	Sí	DEFAULT RADIO CHANNEL from the Playbook Roles Library sheet.
flag	boolean	Sí	FLAG from the Playbook Roles Library sheet.
notes	xpms.canon_text	Sí	NOTES from the Playbook Roles Library sheet.
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.