HAZ_CON_MAT_TBL

(SQL Table)
 Index Back

Hazardous Conditn/Matrl Codes

Use HAZ_CON_MAT_TBL to identify hazardous conditions and/or materials that exist or to which employees are exposed in the workplace. This is an edit table used in the Health and Safety module.

  • Related Language Record: HAZ_CON_MAT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SETID_TBL

    2 HAZARD_ID Character(5) VARCHAR2(5) NOT NULL Hazard ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 HAZARD_TYPE Character(1) VARCHAR2(1) NOT NULL Hazard Type
    C=Condition
    M=Material

    Default Value: C

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 HAZARD_CLASS Character(1) VARCHAR2(1) NOT NULL Hazardous Class
    A=Compressed Gases
    B=Flammable and Combustible
    C=Oxidizing Material
    D=Poisonous and Infectious
    E=Corrosive Material
    F=Dangerously Reactive
    9 HAZARD_DIVISION Character(1) VARCHAR2(1) NOT NULL Hazardous Division
    1=Immediate and Seriously Toxic
    2=Other Toxic Affects
    3=Biohazardous Infectious