xpms.std_sop
TableRow level security on
XOS Standard Library: SOP Library (Playbook, provenance imported). Each new org receives an editable copy at creation.
Primary key: sop_id
| Column | Type | Nullable | Description |
|---|---|---|---|
| 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 | Yes | TITLE from the Playbook SOP Library sheet. |
| operational_domain | xpms.canon_text | Yes | OPERATIONAL DOMAIN from the Playbook SOP Library sheet. |
| revision | xpms.canon_text | Yes | REVISION from the Playbook SOP Library sheet. |
| organization | xpms.canon_text | Yes | ORGANIZATION from the Playbook SOP Library sheet. |
| project | xpms.canon_text | Yes | PROJECT from the Playbook SOP Library sheet. |
| department | xpms.canon_text | Yes | DEPARTMENT from the Playbook SOP Library sheet. |
| category | xpms.canon_text | Yes | CATEGORY from the Playbook SOP Library sheet. |
| sub_category | xpms.canon_text | Yes | SUB CATEGORY from the Playbook SOP Library sheet. |
| accountable_role_code | xpms.canon_text | Yes | ACCOUNTABLE ROLE CODE from the Playbook SOP Library sheet. |
| required_ppe_compliance_tag | xpms.canon_text | Yes | REQUIRED PPE / COMPLIANCE TAG from the Playbook SOP Library sheet. |
| prerequisites_and_hazards | xpms.canon_text | Yes | PREREQUISITES & HAZARDS from the Playbook SOP Library sheet. |
| procedure_step_1 | xpms.canon_text | Yes | PROCEDURE STEP 1 from the Playbook SOP Library sheet. |
| procedure_step_2 | xpms.canon_text | Yes | PROCEDURE STEP 2 from the Playbook SOP Library sheet. |
| procedure_step_3 | xpms.canon_text | Yes | PROCEDURE STEP 3 from the Playbook SOP Library sheet. |
| procedure_step_4 | xpms.canon_text | Yes | PROCEDURE STEP 4 from the Playbook SOP Library sheet. |
| reference_doc_id | xpms.canon_text | Yes | REFERENCE DOC ID from the Playbook SOP Library sheet. |
| status | xpms.canon_text | Yes | STATUS from the Playbook SOP Library sheet. |
| flag | boolean | Yes | FLAG from the Playbook SOP Library sheet. |
| notes | xpms.canon_text | Yes | NOTES from the Playbook SOP Library sheet. |
| created_by | xpms.canon_text | Yes | CREATED BY from the Playbook SOP Library sheet. |
| created_at | timestamp without time zone | Yes | CREATED AT from the Playbook SOP Library sheet. |
| updated_at | date | Yes | UPDATED AT from the Playbook SOP Library sheet. |