Alias: HVR#

(P2K_SH_VEHICLE_REPORTS)

Unique Keys: none
Child Table: P2K_SH_VEHICLE_PASSENGERS
Parent Table: P2K_SH_INCIDENTS
ERD: ERD-SH40

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	Involved in P2K_SH_INCIDENTS
ECT_ID	Number(10)	ID	[ARC1]	Driven by P2K_HR_CONTACTS
EID_ID	Number(10)	ID	[ARC1]	Driven by P2K_HR_IDENTITIES
DSP_ID	Number(10)	ID	Y	Registered in P2K_CM_STATE_PROVINCES
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	[ARC2]	Owned by P2K_HR_CONTACTS
EID_ID_OWNED_BY	Number(10)	ID	[ARC2]	Owned byP2K_HR_IDENTITIES
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

Notes

[ARC1] Only one of ECT_ID or EID_ID (driver of vehicle) must be supplied

[ARC2] Only one of ECT_ID_OWNED_BY or EID_ID_OWNED_BY (owner of vehicle) may be supplied (optional)

---

Notes #

Click to create a new notes page