EMP_HAZ_DTL_BRA

(SQL Table)
 Index Back

Employee Hazard IPE Details

Employee Hazard IPE Details Brazil

  • Related Language Record: EMP_H_D_BRA_LNG

  • Parent record: EMP_CON_HDR_BRA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 HAZ_AGE_CODE_BRA Character(9) VARCHAR2(9) NOT NULL Hazard Agent Code.

    Prompt Table: HAZ_AGE_TBL_BRA

    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    6 HAZARD_ID Character(5) VARCHAR2(5) NOT NULL Hazard ID

    Prompt Table: HAZARD_TBL_BRA

    7 HAZ_EVAL_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Hazard Evaluation Type Brazil
    L=Qualitative
    N=Quantitative
    8 HAZ_UNIT_ID_BRA Character(10) VARCHAR2(10) NOT NULL Hazard Unit

    Prompt Table: HAZ_UN_VW_BRA

    9 HAZARD_UNITS_BRA Number(14,5) DECIMAL(13,5) NOT NULL Hazard Units
    10 HAZ_TOLERANCE_BRA Number(14,5) DECIMAL(13,5) NOT NULL Tolerance Limit
    11 HAZARD_TECHNIC_BRA Character(40) VARCHAR2(40) NOT NULL Hazard Technique Used Brazil
    12 DESCRLONG Long Character CLOB Long Description
    13 CPE_INFO_QU1_BRA Character(1) VARCHAR2(1) NOT NULL CPE Information Question 1 Does the Company implement collective protection measures (CPEs) to eliminate or reduce worker�s exposure to the risk factor?
    0=Not Applicable
    1=Not Implement
    2=Implement
    14 CPE_INFO_QU2_BRA Character(1) VARCHAR2(1) NOT NULL CPE Information Question 2 Are CPEs effective in neutralizing risks to the worker?
    N=No
    Y=Yes
    15 CPE_INFO_QU3_BRA Character(1) VARCHAR2(1) NOT NULL CPE Information Question 3 Utilization of IPE: Mandatory
    0=Not Applicable
    1=Not Used
    2=Used
    16 IPE_INFO_QU1_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
    N=No
    Y=Yes
    17 IPE_INFO_QU2_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
    N=No
    Y=Yes
    18 IPE_INFO_QU3_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
    N=No
    Y=Yes
    19 IPE_INFO_QU4_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
    N=No
    Y=Yes
    20 IPE_INFO_QU5_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
    N=No
    Y=Yes
    21 IPE_INFO_QU6_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
    N=No
    Y=Yes
    22 IPE_EFF_BRA Character(1) VARCHAR2(1) NOT NULL IPE Code BRA Value
    N=No
    Y=Yes
    23 PROCEED_NBR_BRA Character(20) VARCHAR2(20) NOT NULL Proceeding Number