This is version 1 2 3 4 5 6 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Alias: HVR#

Unique Keys:
Child Table:
Parent Table:

This table records vehicle information pertinent to a safety incident.

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
HIN_ID	Number(10)	ID	Y	Link to P2K_CM_UNITS
ECT_ID	Number(10)	ID		Link to P2K_CM_UNITS
EID_ID	Number(10)	ID		Link to P2K_CM_UNITS
DSP_ID	Number(10)	ID	Y	Link to P2K_CM_UNITS
VEHICLE_YEAR	Number(5)	NUMBER5	Y
VEHICLE_MAKE	Varchar2(16)	VARCHAR16	Y
VEHICLE_TYPE	Varchar2(16)	VARCHAR16	Y
VEHICLE_PLATES	Varchar2(16)	VARCHAR16	Y
ECT_ID_OWNED_BY	Number(10)	ID		Link to P2K_CM_UNITS
EID_ID_OWNED_BY	Number(10)	ID		Link to P2K_CM_UNITS
ROAD_CONDITIONS	Varchar2(50)	DESCRIPTION
WEATHER_CONDITIONS	Varchar2(50)	DESCRIPTION
VEHICLE_SPEED	Varchar2(16)	VARCHAR16
COMPANY_VEHICLE	Varchar2(1)	TOGGLE
SEAT_BELT_WORN	Varchar2(1)	TOGGLE
PHOTOS_TAKEN	Varchar2(1)	TOGGLE
VEHICLE_DAMAGE	Varchar2(4000)	VARCHAR4000
VEHICLE_OPERATOR_STATEMENT	Varchar2(4000)	VARCHAR4000
INSURANCE_COMPANY	Varchar2(50)	DESCRIPTION
INSURANCE_POLICY	Varchar2(16)	VARCHAR16
RECOVERY_COST	Number(18)	AMT12V6
REPAIR_COST	Number(18)	AMT12V6
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y

User Fields: Allowed
Audit Logging: Allowed