xpms.emergency_protocol
TableRow level security on
The protocol for one code in one operational domain. Global; agencies are resolved per jurisdiction.
Primary key: record_key
| Column | Type | Nullable | Description |
|---|---|---|---|
| record_key | xpms.canon_code | No | Protocol key EMG-nnn. |
| code | xpms.canon_code | No | Emergency code.References xpms.emergency_code.code |
| domain | xpms.canon_text | No | Operational domain.References xpms.operational_domain.domain |
| department | xpms.canon_text | Yes | DEPARTMENT from the Playbook Emergency Codes sheet. |
| category | xpms.canon_text | Yes | CATEGORY from the Playbook Emergency Codes sheet. |
| sub_category | xpms.canon_text | Yes | SUB CATEGORY from the Playbook Emergency Codes sheet. |
| flag | boolean | Yes | FLAG from the Playbook Emergency Codes sheet. |
| notes | xpms.canon_text | Yes | NOTES from the Playbook Emergency Codes sheet. |
| source_row | integer | Yes | Row of the Playbook sheet that mirrors this canon row; NULL when the Playbook has no such row. |
| source_status | xpms.canon_text | Yes | STATUS as recorded on the Playbook row (for example Active). |
| source_created_by | xpms.canon_text | Yes | CREATED BY as recorded on the Playbook row. |
| source_created_at | timestamp without time zone | Yes | CREATED AT as recorded on the Playbook row: a wall-clock time; the Playbook records no time zone. |
| source_updated_at | timestamp without time zone | Yes | UPDATED AT as recorded on the Playbook row: a wall-clock time; the Playbook records no time zone. |