xpms.v_sheet_roles_library

View

The Playbook Roles Library sheet as the database holds it: one row per source row, computed columns reproduced in SQL.

Columns of xpms.v_sheet_roles_library
Column	Type	Nullable	Description
source_row	integer	Yes	Row number in the source sheet.
role_code	text	Yes	ROLE CODE (column A), field.
job_title	text	Yes	JOB TITLE (column B), field.
department	text	Yes	DEPARTMENT (column C), field.
discipline	text	Yes	DISCIPLINE (column D), field.
rank	text	Yes	RANK (column E), field.
job_summary	text	Yes	JOB SUMMARY (column F), field.
key_responsibilities	text	Yes	KEY RESPONSIBILITIES (column G), field.
qualifications	text	Yes	QUALIFICATIONS (column H), field.
physical_requirements	text	Yes	PHYSICAL REQUIREMENTS (column I), field.
required_certifications	text	Yes	REQUIRED CERTIFICATIONS (column J), field.
default_clearance_tier	text	Yes	DEFAULT CLEARANCE TIER (column K), field.
default_radio_channel	text	Yes	DEFAULT RADIO CHANNEL (column L), field.
status	text	Yes	STATUS (column M), field.
flag	text	Yes	FLAG (column N), field.
notes	text	Yes	NOTES (column O), field.
created_by	text	Yes	CREATED BY (column P), field.
created_at	text	Yes	CREATED AT (column Q), field.
updated_at	text	Yes	UPDATED AT (column R), field.