INJURY_ILL_BP

(SQL Table)
 Index Back

EE Injury/Illness Body Parts

This is one of several records used in the Health and Safety module to record details about work-related injuries and illnesses suffered by employees or non-employees. Use INJURY_ILL_BP to identify the body parts involved in a person's injury or illness. This record is subordinate to INJURY_ILL.

  • Parent record: INJURY_ILL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Prompt Table: PER_ORG_ASGN_VW

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

    Prompt Table: NE_INCIDNT_SRCH

    4 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

    Prompt Table: INCIDENT_DATA

    5 BODY_PART_CD Character(5) VARCHAR2(5) NOT NULL Body Part Code

    Prompt Table: BODY_PART_TBL

    6 SIDE_OF_BODY Character(1) VARCHAR2(1) NOT NULL Side of Body
    B=Back
    F=Front
    L=Left
    R=Right
    7 PRIMARY_INJURY Character(1) VARCHAR2(1) NOT NULL Primary Injury

    Y/N Table Edit

    Default Value: N