EMPL_HA_IPE_DTL

(SQL Table)
 Index Back

Hazard Table BRA

Hazard Table Brazil

  • Parent record: EMPL_CONDIT_HDR

    • # 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    5 DATETIME_CREATED DateTime(26) TIMESTAMP DateTime Created
    6 HAZARD_ID Character(5) VARCHAR2(5) NOT NULL Hazard ID

    Prompt Table: HAZARD_TBL_BRA

    7 CPE_INFO_BRA Character(1) VARCHAR2(1) NOT NULL CPE_INFO_BRA Information link
    8 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

    Default Value: 0

    9 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

    Default Value: Y

    10 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

    Default Value: 0

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

    Prompt Table: HAZ_UN_VW_BRA

    13 HAZARD_UNITS_BRA Number(14,5) DECIMAL(13,5) NOT NULL Hazard Units
    14 HAZ_TOLERANCE_BRA Number(14,5) DECIMAL(13,5) NOT NULL Tolerance Limit
    15 HAZARD_TECHNIC_BRA Character(40) VARCHAR2(40) NOT NULL Hazard Technique Used Brazil
    16 QUESTION1_BRA Character(1) VARCHAR2(1) NOT NULL Question 1 BRA
    N=No
    Y=Yes
    17 QUESTION2_BRA Character(1) VARCHAR2(1) NOT NULL Question 1 BRA
    N=No
    Y=Yes
    18 QUESTION3_BRA Character(1) VARCHAR2(1) NOT NULL Question 1 BRA
    N=No
    Y=Yes
    19 DESCRLONG Long Character CLOB Long Description