INCDNT_VEH_EMPL

(SQL Table)
 Index Back

Vehicle/Equip Empls Involved

This is one of several records used in the Health and Safety module to record in-depth information about a health/safety-related incident in the workplace. INCDNT_VEH_EMPL identifies employees and non-employees and their specific role as a driver or passenger of a particular vehicle in a vehicle incident. This allows for the tracking of driver safety records related to incidents.

  • Parent record: INCIDNT_VEHICLE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

    Prompt Table: INCIDENT_DATA

    2 PROPERTY_ID Character(10) VARCHAR2(10) NOT NULL Property Code

    Prompt Table: VEH_EQUIP_VW

    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON_NAME

    4 NON_EMPLOYEE_ID Character(11) VARCHAR2(11) NOT NULL Non-Employee ID

    Prompt Table: NE_INCIDNT_SRCH

    5 EMPLOYEE_ROLE Character(1) VARCHAR2(1) NOT NULL Employee Role
    B=Bystander/Pedestrian
    D=Driver|Operator
    P=Passenger