xpms.std_sop

TablaSeguridad a nivel de fila activa

XOS Standard Library: SOP Library (Playbook, provenance imported). Each new org receives an editable copy at creation.

Clave primaria: sop_id

Columnas de xpms.std_sop
Columna	Tipo	Admite nulos	Descripción
source_row	integer	No	Row of the Playbook SOP Library sheet the entry was imported from; the library's default order.
sop_id	xpms.canon_text	No	SOP ID from the Playbook SOP Library sheet.
title	xpms.canon_text	Sí	TITLE from the Playbook SOP Library sheet.
operational_domain	xpms.canon_text	Sí	OPERATIONAL DOMAIN from the Playbook SOP Library sheet.
revision	xpms.canon_text	Sí	REVISION from the Playbook SOP Library sheet.
organization	xpms.canon_text	Sí	ORGANIZATION from the Playbook SOP Library sheet.
project	xpms.canon_text	Sí	PROJECT from the Playbook SOP Library sheet.
department	xpms.canon_text	Sí	DEPARTMENT from the Playbook SOP Library sheet.
category	xpms.canon_text	Sí	CATEGORY from the Playbook SOP Library sheet.
sub_category	xpms.canon_text	Sí	SUB CATEGORY from the Playbook SOP Library sheet.
accountable_role_code	xpms.canon_text	Sí	ACCOUNTABLE ROLE CODE from the Playbook SOP Library sheet.
required_ppe_compliance_tag	xpms.canon_text	Sí	REQUIRED PPE / COMPLIANCE TAG from the Playbook SOP Library sheet.
prerequisites_and_hazards	xpms.canon_text	Sí	PREREQUISITES & HAZARDS from the Playbook SOP Library sheet.
procedure_step_1	xpms.canon_text	Sí	PROCEDURE STEP 1 from the Playbook SOP Library sheet.
procedure_step_2	xpms.canon_text	Sí	PROCEDURE STEP 2 from the Playbook SOP Library sheet.
procedure_step_3	xpms.canon_text	Sí	PROCEDURE STEP 3 from the Playbook SOP Library sheet.
procedure_step_4	xpms.canon_text	Sí	PROCEDURE STEP 4 from the Playbook SOP Library sheet.
reference_doc_id	xpms.canon_text	Sí	REFERENCE DOC ID from the Playbook SOP Library sheet.
status	xpms.canon_text	Sí	STATUS from the Playbook SOP Library sheet.
flag	boolean	Sí	FLAG from the Playbook SOP Library sheet.
notes	xpms.canon_text	Sí	NOTES from the Playbook SOP Library sheet.
created_by	xpms.canon_text	Sí	CREATED BY from the Playbook SOP Library sheet.
created_at	timestamp without time zone	Sí	CREATED AT from the Playbook SOP Library sheet.
updated_at	date	Sí	UPDATED AT from the Playbook SOP Library sheet.