INC_ACTION_C_VW

(SQL View)
 Index Back

Incident Corrective 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 INCIDENT_NBR, HAZARD_ID, INCIDENT_CAUSE, ACTION_SEQUENCE, CORRECTIVE_PREVENT, ACTION_CATEGORY, ACTION_STATUS, RESPONSIBLE_ID, EST_COMPLETION_DT, ACT_COMPLETION_DT, %subrec(INC_ACTCAN_SBR,A), %subrec(INC_ACTGER_SBR,A), CORRECTIVE_ACTION from PS_INCIDENT_ACTION A where CORRECTIVE_PREVENT = 'C'

  • Related Language Record: INC_ACTNCVW_LNG

  • Parent record: INCDNT_ACTN_TYP

    • # 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 HAZARD_ID Character(5) VARCHAR2(5) NOT NULL Hazard ID

    Prompt Table: HAZ_CON_MAT_TBL

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

    Default Value: C

    6 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
    7 ACTION_STATUS Character(1) VARCHAR2(1) NOT NULL Action Status
    C=Completed
    I=In Progress
    P=Planned
    R=Recommended
    V=Existing

    Default Value: R

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

    Prompt Table: PERSON_NAME

    9 EST_COMPLETION_DT Date(10) DATE Estimated Completion Date
    10 ACT_COMPLETION_DT Date(10) DATE Actual Completion Date
    11 PREVENT_ACT_CD_CAN Character(5) VARCHAR2(5) NOT NULL Preventative Action Code

    Prompt Table: PREVENT_ACT_CAN

    12 OTHER_PREV_DESCR Character(40) VARCHAR2(40) NOT NULL Other Preventative Action Desc
    13 PREVENT_ACT_CD_GER Character(3) VARCHAR2(3) NOT NULL Preventative Action Code

    Prompt Table: PREVENT_ACT_GER

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

    Prompt Table: CORRECT_ACT_GER

    15 CORRECTIVE_ACTION Long Character CLOB Corrective Action