INJ_PEOPLE_CAN

(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.

  • 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 IP_EMPLID_CAN Character(11) VARCHAR2(11) NOT NULL EmplID

    Prompt Table: PERSON_NAME

    5 IP_NON_EMPLID_CAN Character(11) VARCHAR2(11) NOT NULL Non-Employee ID

    Prompt Table: NE_PERS_NM_VW

    6 INJURY_ROLE_CAN Character(2) VARCHAR2(2) NOT NULL Injury Role
    IW=Witness
    OP=Other Party
    7 RESPONSIBLE_SW Character(1) VARCHAR2(1) NOT NULL Responsible For Incident

    Y/N Table Edit

    Default Value: N

    8 COMMENTS Long Character CLOB Comment