HAZ_LNG_VW_BRA (SQL View)	Index Back
eSocial Hazard Factor Table eSocial Hazard Factor Table Values

HAZ_LNG_VW_BRA

(SQL View)

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_TYPE_BRA , T.HAZARD_CODE_BRA , T.LANGUAGE_CD , T.DESCR50 FROM PS_HAZA_T_LNG_BRA T WHERE T.EFFDT = ( SELECT MAX(T2.EFFDT) FROM PS_HAZA_T_LNG_BRA T2 WHERE T.HAZARD_CODE_BRA = T2.HAZARD_CODE_BRA AND T.LANGUAGE_CD = T2.LANGUAGE_CD)

Related Language Record for HAZ_CODE_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50