xpms.v_sheet_incident_cad_log

Vista

The Playbook Incident CAD Log sheet as the database holds it: one row per source row, computed columns reproduced in SQL.

Columnas de xpms.v_sheet_incident_cad_log
Columna	Tipo	Admite nulos	Descripción
source_row	integer	Sí	Row number in the source sheet.
record_id	text	Sí	RECORD ID (column A), field.
organization	text	Sí	ORGANIZATION (column B), field.
project_id	text	Sí	PROJECT ID (column C), field.
department	text	Sí	DEPARTMENT (column D), field.
category	text	Sí	CATEGORY (column E), field.
sub_category	text	Sí	SUB CATEGORY (column F), field.
incident_timestamp	text	Sí	INCIDENT TIMESTAMP (column G), field.
emergency_code_id	text	Sí	EMERGENCY CODE ID (column H), field.
severity_level	text	Sí	SEVERITY LEVEL (column I), field.
location_id	text	Sí	LOCATION ID (column J), field.
reported_by	text	Sí	REPORTED BY (column K), field.
lead_responder_id	text	Sí	LEAD RESPONDER ID (column L), field.
dispatch_agency_unit	text	Sí	DISPATCH AGENCY / UNIT (column M), field.
dispatch_time	text	Sí	DISPATCH TIME (column N), field.
on_scene_time	text	Sí	ON SCENE TIME (column O), field.
cleared_time	text	Sí	CLEARED TIME (column P), field.
police_report_number	text	Sí	POLICE REPORT NUMBER (column Q), field.
incident_summary	text	Sí	INCIDENT SUMMARY (column R), field.
resolution_protocol	text	Sí	RESOLUTION PROTOCOL (column S), field.
follow_up_required	text	Sí	FOLLOW UP REQUIRED (column T), field.
status	text	Sí	STATUS (column U), field.
flag	text	Sí	FLAG (column V), field.
notes	text	Sí	NOTES (column W), field.
created_by	text	Sí	CREATED BY (column X), field.
created_at	text	Sí	CREATED AT (column Y), field.
updated_at	text	Sí	UPDATED AT (column Z), field.