xpms.emergency_protocol
TablaSeguridad a nivel de fila activa
The protocol for one code in one operational domain. Global; agencies are resolved per jurisdiction.
Clave primaria: record_key
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| record_key | xpms.canon_code | No | Protocol key EMG-nnn. |
| code | xpms.canon_code | No | Emergency code.Hace referencia a xpms.emergency_code.code |
| domain | xpms.canon_text | No | Operational domain.Hace referencia a xpms.operational_domain.domain |
| department | xpms.canon_text | Sí | DEPARTMENT from the Playbook Emergency Codes sheet. |
| category | xpms.canon_text | Sí | CATEGORY from the Playbook Emergency Codes sheet. |
| sub_category | xpms.canon_text | Sí | SUB CATEGORY from the Playbook Emergency Codes sheet. |
| flag | boolean | Sí | FLAG from the Playbook Emergency Codes sheet. |
| notes | xpms.canon_text | Sí | NOTES from the Playbook Emergency Codes sheet. |
| source_row | integer | Sí | Row of the Playbook sheet that mirrors this canon row; NULL when the Playbook has no such row. |
| source_status | xpms.canon_text | Sí | STATUS as recorded on the Playbook row (for example Active). |
| source_created_by | xpms.canon_text | Sí | CREATED BY as recorded on the Playbook row. |
| source_created_at | timestamp without time zone | Sí | 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 | Sí | UPDATED AT as recorded on the Playbook row: a wall-clock time; the Playbook records no time zone. |