xpms.v_sheet_sop_library

Vista

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

Columnas de xpms.v_sheet_sop_library
Columna	Tipo	Admite nulos	Descripción
source_row	integer	Sí	Row number in the source sheet.
sop_id	xpms.canon_text	Sí	SOP ID (column A), field.
title	xpms.canon_text	Sí	TITLE (column B), field.
operational_domain	xpms.canon_text	Sí	OPERATIONAL DOMAIN (column C), field.
revision	xpms.canon_text	Sí	REVISION (column D), field.
organization	xpms.canon_text	Sí	ORGANIZATION (column E), field.
project	xpms.canon_text	Sí	PROJECT (column F), field.
department	xpms.canon_text	Sí	DEPARTMENT (column G), field.
category	xpms.canon_text	Sí	CATEGORY (column H), field.
sub_category	xpms.canon_text	Sí	SUB CATEGORY (column I), field.
accountable_role_code	xpms.canon_text	Sí	ACCOUNTABLE ROLE CODE (column J), field.
required_ppe_compliance_tag	xpms.canon_text	Sí	REQUIRED PPE / COMPLIANCE TAG (column L), field.
prerequisites_and_hazards	xpms.canon_text	Sí	PREREQUISITES & HAZARDS (column M), field.
procedure_step_1	xpms.canon_text	Sí	PROCEDURE STEP 1 (column N), field.
procedure_step_2	xpms.canon_text	Sí	PROCEDURE STEP 2 (column O), field.
procedure_step_3	xpms.canon_text	Sí	PROCEDURE STEP 3 (column P), field.
procedure_step_4	xpms.canon_text	Sí	PROCEDURE STEP 4 (column Q), field.
reference_doc_id	xpms.canon_text	Sí	REFERENCE DOC ID (column R), field.
status	xpms.canon_text	Sí	STATUS (column T), field.
flag	boolean	Sí	FLAG (column U), field.
notes	xpms.canon_text	Sí	NOTES (column V), field.
created_by	xpms.canon_text	Sí	CREATED BY (column W), field.
created_at	timestamp without time zone	Sí	CREATED AT (column X), field.
updated_at	date	Sí	UPDATED AT (column Y), field.
accountable_role_title	xpms.canon_text	Sí	ACCOUNTABLE ROLE TITLE (column K), computed.
reference_document_name	xpms.canon_text	Sí	REFERENCE DOCUMENT NAME (column S), computed.