xpms.v_sheet_personnel_roster

Vista

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

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