xpms.v_sheet_staffing_requisition

Vista

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

Columnas de xpms.v_sheet_staffing_requisition
Columna	Tipo	Admite nulos	Descripción
source_row	integer	Sí	Row number in the source sheet.
req_id	text	Sí	REQ ID (column A), field.
event_phase	text	Sí	EVENT PHASE (column B), field.
role_code	text	Sí	ROLE CODE (column C), field.
headcount	text	Sí	HEADCOUNT (column F), field.
duration_days	text	Sí	DURATION (DAYS) (column G), field.
status	text	Sí	STATUS (column J), field.
flag	text	Sí	FLAG (column K), field.
notes	text	Sí	NOTES (column L), field.
created_by	text	Sí	CREATED BY (column M), field.
created_at	text	Sí	CREATED AT (column N), field.
updated_at	text	Sí	UPDATED AT (column O), field.
rate_card_id	xpms.canon_code	Sí	RATE CARD ID (column D), computed.
job_title	xpms.canon_text	Sí	JOB TITLE (column E), computed.
standard_rate	numeric	Sí	STANDARD RATE (column H), computed.
total_estimated_cost	numeric	Sí	TOTAL ESTIMATED COST (column I), computed.