HAZ_CODE_VW_BRA

(SQL View)
 Index Back

eSocial Hazard Factor Table

eSocial Hazard Factor Table Values

SELECT CASE WHEN T.HAZARD_TYP2_BRA = '3' THEN 'B' WHEN T.HAZARD_TYP2_BRA = '4' THEN 'E' WHEN T.HAZARD_TYP2_BRA = '1' THEN 'F' WHEN T.HAZARD_TYP2_BRA = '5' THEN 'M' WHEN T.HAZARD_TYP2_BRA = '2' THEN 'Q' WHEN T.HAZARD_TYP2_BRA = '6' THEN 'T' END AS HAZARD_TYP2_BRA , T.HAZARD_CODE_BRA , T.DESCR50 FROM PS_HAZA_CODE_BRA T WHERE T.EFFDT = ( SELECT MAX(T2.EFFDT) FROM PS_HAZA_CODE_BRA T2 WHERE T.HAZARD_CODE_BRA = T2.HAZARD_CODE_BRA) UNION SELECT ' ' AS HAZARD_TYP2_BRA , T1.HAZARD_CODE_BRA , T1.DESCR50 FROM PS_HAZA_CODE_BRA T1 WHERE T1.EFFDT = ( SELECT MAX(T21.EFFDT) FROM PS_HAZA_CODE_BRA T21 WHERE T1.HAZARD_CODE_BRA = T21.HAZARD_CODE_BRA)

  • Related Language Record: HAZ_LNG_VW_BRA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HAZARD_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Hazard Type Brazil
    B=Biological Risk
    E=Ergonomic Risk
    F=Physical Risk
    M=Mechanical Risk
    Q=Chemical Risk
    T=Other
    2 HAZARD_CODE_BRA Character(9) VARCHAR2(9) NOT NULL Hazard Code BRA
    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50