RAT_CODE_VW_BRA

(SQL View)
 Index Back

RAT Proceeding by Estab

RAT Proceeding by Estab

SELECT DISTINCT A.COMPANY , A.EFFDT , A.CREATED_FOR_BRA , CASE WHEN A.AUTH_BY_BRA <> '2' THEN '1' ELSE A.AUTH_BY_BRA END AS AUTH_BY_BRA , CASE WHEN A.PRC_TYPE_BRA = '1' THEN 'A' WHEN A.PRC_TYPE_BRA = '2' THEN 'J' WHEN A.PRC_TYPE_BRA = '4' THEN 'F' ELSE ' ' END AS PRC_TYPE_BRA , A.PROC_NBR_BRA , B.SUSP_CODE_BRA , A.EFF_STATUS FROM PS_LEG_PRO_TBL_BRA A , PS_LEG_PRO_DTL_BRA B WHERE A.COMPANY = B.COMPANY AND A.PRC_TYPE_BRA = B.PRC_TYPE_BRA AND A.PROC_NBR_BRA = B.PROC_NBR_BRA AND A.EFFDT = B.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 CREATED_FOR_BRA Character(2) VARCHAR2(2) NOT NULL Created For table 1070
1=Tax only or Tax and FGTS
2=Minor Work Permit
2=Minor Work Permit
3=Exemption to Contract PCD
3=Exemption to Contract PCD
4=Exemption for Hiring Aprentice
4=Exemption for Hiring Aprentice
5=Occupational Health and Safety
5=Occupational Health and Safety
6=Conv Health Leave to work Acc
6=Conv Health Leave to work Acc
7=FGTS only/Termination Soc Cont
8=Union Contribution
8=Union Contribution
99=Other
99=Other
4 AUTH_BY_BRA Character(1) VARCHAR2(1) NOT NULL Authorized by BRA
1=Taxpayer
2=Other Entity,Company/Employee
5 RAT_PROCEEDING_BRA Character(1) VARCHAR2(1) NOT NULL RAT Process Type Field
A=Administrative
J=Judicial
N=None
6 RAT_NBR_PROCE2_BRA Character(30) VARCHAR2(30) NOT NULL RAT Process Number
7 SUSP_CODE_RAT_BRA Number(14,0) DECIMAL(14) NOT NULL Suspension Code RAT
8 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive