LOCATN_TBL_BRA

#	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: SET_LOC_VLD_VW
2	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: LOCATION_TBL.EFFDT
4	LOCATION_TYPE_BRA	Character(3)	VARCHAR2(3) NOT NULL	Location Type Brazil EST=Establishment Location WRK=Work Area Location Default Value: EST
5	SEFIP_RISK_LVL_BRA	Character(2)	VARCHAR2(2) NOT NULL	SEFIP Risk Level Brazil 00=Default 01=Non Exp Harmful Agent 02=Exp Ret at 15 years 03=Exp Ret at 20 years 04=Exp Ret at 25 years 05=Non Exp. Harmful Agent M.Jobs 06=Exp. Ret. at 15 years M.Jobs 07=Exp. Ret. at 20 years M.Jobs 08=Exp. Ret. at 25 years M.Jobs 09=Not Applicable Default Value: 00
6	UNHEALTHY_IND_BRA	Character(2)	VARCHAR2(2) NOT NULL	Unhealthy Indicator Brazil 00=Default 01=Minimum Grade 02=Middle Grade 04=Maximum Grade 05=Not Applicable Default Value: 00
7	RISK_INDICATOR_BRA	Character(2)	VARCHAR2(2) NOT NULL	Risk Indicator Brazil 00=Default 01=Applicable 02=Not Applicable Default Value: 00
8	LOCATION_DTL_BRA	Long Character	CLOB	Detailed Local Description