EMP_CODE_VW_BRA

(SQL View)
 Index Back

Proceding by employee

Proceding by employee

SELECT DISTINCT A.COMPANY , A.CREATED_FOR_BRA , A.AUTH_BY_BRA , A.PROC_NBR_BRA , A.EFFDT , A.EFF_STATUS , B.SUSP_CODE_BRA 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 AND A.PRC_TYPE_BRA = '2'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 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
3 AUTH_BY_BRA Character(1) VARCHAR2(1) NOT NULL Authorized by BRA
1=Taxpayer
2=Other Entity,Company/Employee
4 PROC_NB2_BRA Character(21) VARCHAR2(21) NOT NULL Proceeding Number BRA
5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
7 CODE_SUSP_BRA Number(14,0) DECIMAL(14) NOT NULL Suspension Code