xpms.v_sheet_production_schedule

Vista

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

Columnas de xpms.v_sheet_production_schedule
Columna	Tipo	Admite nulos	Descripción
source_row	integer	Sí	Row number in the source sheet.
activity_id	text	Sí	ACTIVITY ID (column A), field.
project_id	text	Sí	PROJECT ID (column B), field.
parent_activity_id	text	Sí	PARENT ACTIVITY ID (column C), field.
wbs_code	text	Sí	WBS CODE (column D), field.
phase_code	text	Sí	PHASE CODE (column E), field.
phase	text	Sí	PHASE (column F), field.
act	text	Sí	ACT (column G), field.
gate	text	Sí	GATE (column H), field.
activity_name	text	Sí	ACTIVITY NAME (column I), field.
activity_type	text	Sí	ACTIVITY TYPE (column J), field.
deliverable	text	Sí	DELIVERABLE (column K), field.
sop_id	text	Sí	SOP ID (column L), field.
owner_role	text	Sí	OWNER ROLE (column M), field.
personnel_id	text	Sí	PERSONNEL ID (column N), field.
start_date	text	Sí	START DATE (column O), field.
end_date	text	Sí	END DATE (column P), field.
duration_days	text	Sí	DURATION (DAYS) (column Q), field.
critical_path	text	Sí	CRITICAL PATH (column R), field.
status	text	Sí	STATUS (column V), field.
flag	text	Sí	FLAG (column W), field.
notes	text	Sí	NOTES (column X), field.
total_tasks	numeric	Sí	TOTAL TASKS (column S), computed.
completed_tasks	numeric	Sí	COMPLETED TASKS (column T), computed.
progress_pct	numeric	Sí	PROGRESS (%) (column U), computed.