xpms.v_sheet_crew_shifts

Vista

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

Columnas de xpms.v_sheet_crew_shifts
Columna	Tipo	Admite nulos	Descripción
source_row	integer	Sí	Row number in the source sheet.
shift_id	text	Sí	SHIFT ID (column A), field.
project_id	text	Sí	PROJECT ID (column B), field.
shift_date	text	Sí	SHIFT DATE (column C), field.
department	text	Sí	DEPARTMENT (column D), field.
location_name	text	Sí	LOCATION NAME (column E), field.
personnel_id	text	Sí	PERSONNEL ID (column F), field.
role_code	text	Sí	ROLE CODE (column H), field.
rate_card_id	text	Sí	RATE CARD ID (column I), field.
scheduled_call_time	text	Sí	SCHEDULED CALL TIME (column K), field.
scheduled_wrap_time	text	Sí	SCHEDULED WRAP TIME (column L), field.
scheduled_meal_break_hrs	text	Sí	SCHEDULED MEAL BREAK (HRS) (column M), field.
status	text	Sí	STATUS (column S), field.
flag	text	Sí	FLAG (column T), field.
notes	text	Sí	NOTES (column U), field.
created_by	text	Sí	CREATED BY (column V), field.
created_at	text	Sí	CREATED AT (column W), field.
updated_at	text	Sí	UPDATED AT (column X), field.
crew_name	text	Sí	CREW NAME (column G), computed.
job_title	xpms.canon_text	Sí	JOB TITLE (column J), computed.
net_scheduled_hours	numeric	Sí	NET SCHEDULED HOURS (column N), computed.
pay_basis	text	Sí	PAY BASIS (column O), computed.
standard_rate	numeric	Sí	STANDARD RATE (column P), computed.
hourly_base_rate	numeric	Sí	HOURLY BASE RATE (column Q), computed.
scheduled_pay	numeric	Sí	SCHEDULED PAY (column R), computed.