INJ_ILL_BP_VW

(SQL View)
 Index Back

Injury/Ill Body Parts/Incidnt

INJ_ILL_BP_VW is a view of INJURY_ILL_BP that sorts the data by incident number rather than by employee ID/non-employee ID. This functionality is part of the Health and Safety module.

SELECT INCIDENT_NBR ,EMPLID ,EMPL_RCD ,NON_EMPLOYEE_ID ,BODY_PART_CD ,SIDE_OF_BODY ,PRIMARY_INJURY FROM PS_INJURY_ILL_BP

  • Parent record: INJURY_ILL_VW

    • # 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

    Prompt Table: PER_ORG_ASGN_VW

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

    Prompt Table: NE_INCIDNT_SRCH

    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