ILL_ACTGER_P_VW

(SQL View)
 Index Back

Incident Prevent Action

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. Use INCDNT_ACTN_TYP and INCIDENT_ACTION to specify actions that could have been taken to prevent the incident or could be taken afterward to correct the hazard and prevent a recurrence.

select EMPLID, EMPL_RCD, NON_EMPLOYEE_ID, ILLNESS_NBR_GER, HAZARD_ID, INCIDENT_CAUSE, ACTION_SEQUENCE, CORRECTIVE_PREVENT, ACTION_CATEGORY, ACTION_STATUS, RESPONSIBLE_ID, EST_COMPLETION_DT, ACT_COMPLETION_DT, %subrec(INC_ACTGER_SBR,A), CORRECTIVE_ACTION from PS_ILL_ACTION_GER A where CORRECTIVE_PREVENT = 'P'

  • Parent record: INCDNT_ACTN_TYP

    • # 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 Rcd Nbr

    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 ILLNESS_NBR_GER Character(8) VARCHAR2(8) NOT NULL Illness Number
    5 HAZARD_ID Character(5) VARCHAR2(5) NOT NULL Hazard ID

    Prompt Table: HAZ_CON_MAT_TBL

    6 INCIDENT_CAUSE Character(40) VARCHAR2(40) NOT NULL Incident Cause
    7 ACTION_SEQUENCE Number(2,0) SMALLINT NOT NULL Action Sequence
    8 CORRECTIVE_PREVENT Character(1) VARCHAR2(1) NOT NULL Corrective or Preventive Actn
    C=Corrective Action
    P=Preventive Action

    Default Value: P

    9 ACTION_CATEGORY Character(3) VARCHAR2(3) NOT NULL Action Category
    BAR=Install Protective Barrier
    COM=Employee Communication
    EQP=Utilize Safety Equipment
    FIX=Fix or repair
    INS=Conduct Inspections
    PRO=Institute Safety Procedures
    TRN=Safety Training
    WRN=Warning signs
    10 ACTION_STATUS Character(1) VARCHAR2(1) NOT NULL Action Status
    C=Completed
    I=In Progress
    P=Planned
    R=Recommended
    V=Existing

    Default Value: R

    11 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID

    Prompt Table: PERSON_NAME

    12 EST_COMPLETION_DT Date(10) DATE Estimated Completion Date
    13 ACT_COMPLETION_DT Date(10) DATE Actual Completion Date
    14 PREVENT_ACT_CD_GER Character(3) VARCHAR2(3) NOT NULL Preventative Action Code

    Prompt Table: PREVENT_ACT_GER

    15 CORRECT_ACT_CD_GER Character(3) VARCHAR2(3) NOT NULL Corrective Actions

    Prompt Table: CORRECT_ACT_GER

    16 CORRECTIVE_ACTION Long Character CLOB Corrective Action