P 2 K_SH_VEHICLE_REPORTS
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 nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
HIN_IDNumber(10)IDYLink to P2K_SH_INCIDENTS
ECT_IDNumber(10)ID Link to P2K_HR_CONTACTS
EID_IDNumber(10)ID Link to P2K_HR_IDENTITIESS
DSP_IDNumber(10)IDYLink to 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 Link to P2K_HR_CONTACTS
EID_ID_OWNED_BYNumber(10)ID Link to P2K_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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation