xpms.v_sheet_personnel_roster

View

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

Columns of xpms.v_sheet_personnel_roster
Column	Type	Nullable	Description
source_row	integer	Yes	Row number in the source sheet.
personnel_id	text	Yes	PERSONNEL ID (column A), field.
organization	text	Yes	ORGANIZATION (column B), field.
project_id	text	Yes	PROJECT ID (column C), field.
first_name	text	Yes	FIRST NAME (column D), field.
last_name	text	Yes	LAST NAME (column E), field.
preferred_name	text	Yes	PREFERRED NAME (column F), field.
email	text	Yes	EMAIL (column G), field.
phone	text	Yes	PHONE (column H), field.
company	text	Yes	COMPANY (column I), field.
role_code	text	Yes	ROLE CODE (column J), field.
department	text	Yes	DEPARTMENT (column L), field.
category	text	Yes	CATEGORY (column M), field.
sub_category	text	Yes	SUB CATEGORY (column N), field.
clearance_tier	text	Yes	CLEARANCE TIER (column O), field.
zone_access	text	Yes	ZONE ACCESS (column P), field.
credential	text	Yes	CREDENTIAL (column Q), field.
credential_record_id	text	Yes	CREDENTIAL RECORD ID (column R), field.
on_site_start	text	Yes	ON SITE START (column S), field.
on_site_end	text	Yes	ON SITE END (column T), field.
dietary_restrictions	text	Yes	DIETARY RESTRICTIONS (column U), field.
shirt_size	text	Yes	SHIRT SIZE (column V), field.
special_accommodations	text	Yes	SPECIAL ACCOMMODATIONS (column W), field.
emergency_contact_name	text	Yes	EMERGENCY CONTACT NAME (column X), field.
emergency_contact_phone	text	Yes	EMERGENCY CONTACT PHONE (column Y), field.
status	text	Yes	STATUS (column Z), field.
flag	text	Yes	FLAG (column AA), field.
notes	text	Yes	NOTES (column AB), field.
created_by	text	Yes	CREATED BY (column AC), field.
created_at	text	Yes	CREATED AT (column AD), field.
updated_at	text	Yes	UPDATED AT (column AE), field.
position	xpms.canon_text	Yes	POSITION (column K), computed.