xpms.v_sheet_sop_library
View
The Playbook SOP Library sheet as the database holds it: one row per source row, computed columns reproduced in SQL.
| Column | Type | Nullable | Description |
|---|---|---|---|
| source_row | integer | Yes | Row number in the source sheet. |
| sop_id | xpms.canon_text | Yes | SOP ID (column A), field. |
| title | xpms.canon_text | Yes | TITLE (column B), field. |
| operational_domain | xpms.canon_text | Yes | OPERATIONAL DOMAIN (column C), field. |
| revision | xpms.canon_text | Yes | REVISION (column D), field. |
| organization | xpms.canon_text | Yes | ORGANIZATION (column E), field. |
| project | xpms.canon_text | Yes | PROJECT (column F), field. |
| department | xpms.canon_text | Yes | DEPARTMENT (column G), field. |
| category | xpms.canon_text | Yes | CATEGORY (column H), field. |
| sub_category | xpms.canon_text | Yes | SUB CATEGORY (column I), field. |
| accountable_role_code | xpms.canon_text | Yes | ACCOUNTABLE ROLE CODE (column J), field. |
| required_ppe_compliance_tag | xpms.canon_text | Yes | REQUIRED PPE / COMPLIANCE TAG (column L), field. |
| prerequisites_and_hazards | xpms.canon_text | Yes | PREREQUISITES & HAZARDS (column M), field. |
| procedure_step_1 | xpms.canon_text | Yes | PROCEDURE STEP 1 (column N), field. |
| procedure_step_2 | xpms.canon_text | Yes | PROCEDURE STEP 2 (column O), field. |
| procedure_step_3 | xpms.canon_text | Yes | PROCEDURE STEP 3 (column P), field. |
| procedure_step_4 | xpms.canon_text | Yes | PROCEDURE STEP 4 (column Q), field. |
| reference_doc_id | xpms.canon_text | Yes | REFERENCE DOC ID (column R), field. |
| status | xpms.canon_text | Yes | STATUS (column T), field. |
| flag | boolean | Yes | FLAG (column U), field. |
| notes | xpms.canon_text | Yes | NOTES (column V), field. |
| created_by | xpms.canon_text | Yes | CREATED BY (column W), field. |
| created_at | timestamp without time zone | Yes | CREATED AT (column X), field. |
| updated_at | date | Yes | UPDATED AT (column Y), field. |
| accountable_role_title | xpms.canon_text | Yes | ACCOUNTABLE ROLE TITLE (column K), computed. |
| reference_document_name | xpms.canon_text | Yes | REFERENCE DOCUMENT NAME (column S), computed. |