P 2 K_SH_VEHICLE_REPORTS

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 nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
HIN_IDNumber(10)IDYInvolved in P2K_SH_INCIDENTS
ECT_IDNumber(10)ID[ARC1] Driven by P2K_HR_CONTACTS
EID_IDNumber(10)ID[ARC1]Driven by P2K_HR_IDENTITIES
DSP_IDNumber(10)IDYRegistered in P2K_CM_STATE_PROVINCES
VEHICLE_YEARNumber(5)NUMBER5Y
VEHICLE_MAKEVarchar2(16)VARCHAR16Y
VEHICLE_TYPEVarchar2(16)VARCHAR16Y
VEHICLE_PLATESVarchar2(16)VARCHAR16Y
ECT_ID_OWNED_BYNumber(10)ID[ARC2]Owned by P2K_HR_CONTACTS
EID_ID_OWNED_BYNumber(10)ID[ARC2]Owned byP2K_HR_IDENTITIES
ROAD_CONDITIONSVarchar2(50)DESCRIPTION
WEATHER_CONDITIONSVarchar2(50)DESCRIPTION
VEHICLE_SPEEDVarchar2(16)VARCHAR16
COMPANY_VEHICLEVarchar2(1)TOGGLE
SEAT_BELT_WORNVarchar2(1)TOGGLE
PHOTOS_TAKENVarchar2(1)TOGGLE
VEHICLE_DAMAGEVarchar2(4000)VARCHAR4000
VEHICLE_OPERATOR_STATEMENTVarchar2(4000)VARCHAR4000
INSURANCE_COMPANYVarchar2(50)DESCRIPTION
INSURANCE_POLICYVarchar2(16)VARCHAR16
RECOVERY_COSTNumber(18)AMT12V6
REPAIR_COSTNumber(18)AMT12V6
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

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