xpms.v_sheet_incident_cad_log

View

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

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