INCIDENT_PEOPLE

(SQL Table)
 Index Back

Incident People

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. INCIDENT_PEOPLE identifies employees and non-employees who had some kind of role in the incident. For example, investigators & witnesses.

  • Related Language Record: INC_PEOPLE_LNG

  • 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_NAME

    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 RESPONSIBLE_SW Character(1) VARCHAR2(1) NOT NULL Responsible For Incident

    Y/N Table Edit

    Default Value: N

    6 TRUSTWORTHY_SW Character(1) VARCHAR2(1) NOT NULL Trustworthy Person

    Y/N Table Edit

    Default Value: N

    7 ABLE_TO_ANSWER_SW Character(1) VARCHAR2(1) NOT NULL Able To Answer Questions

    Y/N Table Edit

    Default Value: N

    8 CONFIRM_STATEMENT Character(1) VARCHAR2(1) NOT NULL Confirm Statement
    N=Does not confirm statement
    U=Unknown confirmation
    Y=Confirms statements
    9 DRUG_INFLUENCE_SW Character(1) VARCHAR2(1) NOT NULL Under The Influence Of Drugs

    Y/N Table Edit

    Default Value: N

    10 DRUG_CLASS_CD Character(1) VARCHAR2(1) NOT NULL Drug Class
    A=Alcohol
    H=Hard Drugs
    M=Medication
    O=Other Drugs
    S=Soft Drugs
    11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    12 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    13 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    14 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    15 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    16 CITY Character(30) VARCHAR2(30) NOT NULL City
    17 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    18 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    19 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    20 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    21 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    22 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    23 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    24 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    25 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    26 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    27 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    28 MGMNT_REP_SW_CAN Character(1) VARCHAR2(1) NOT NULL Management Representative

    Y/N Table Edit

    Default Value: N

    29 LABOR_REP_SW_CAN Character(1) VARCHAR2(1) NOT NULL Labor Representative

    Y/N Table Edit

    Default Value: N

    30 WCB_INVSGTR_TYPE Character(3) VARCHAR2(3) NOT NULL classification of the type of employer investigator LBR = Worker Representative MNG = Employer Representative OTH = other
    OTH=Other
    31 HS_INSURANCE_FRA Character(30) VARCHAR2(30) NOT NULL Accident Insurance
    32 INSURANCE_GER Character(50) VARCHAR2(50) NOT NULL Insurance Details
    33 COMMENTS Long Character CLOB Comment