INC_PEOPLE_LNG

(SQL Table)
 Index Back

Incident Witnesses

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. INCIDNT_WITNESS identifies employees and non-employees who witnessed the incident.

  • Related Language Record for INCIDENT_PEOPLE

  • Parent record: INCIDENT_DATA

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

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

    Prompt Table: NE_INCIDNT_SRCH

    4 INCIDENT_ROLE Character(2) VARCHAR2(2) NOT NULL Incident Role
    BP=Bystander/Pedestrian
    DO=Driver/Operator Of Vehicle
    EW=Eyewitness
    IN=Investigator
    IW=Witness
    OP=Other Party
    PA=Passenger In Vehicle
    PO=Property Owner
    PW=Pet Owner
    VO=Vehicle Owner
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 COMMENTS Long Character CLOB Comment