GPBR_JUD_ADD_VW

(SQL View)
Index Back

Basic Table - Proceeding Table

eSocial XML Framework View Table Stores the information about node tag "inclusao" event S-1070 - Basic Table - Judicial Proceeding Table

SELECT A.GPBR_DRIVER_SEQ , A.GPBR_DRV_SPLIT_SEQ , A.PRC_TYPE_BRA , A.PROC_NBR_BRA , B.GPBR_ES_PS , A.AUTH_BY_BRA , A.CREATED_FOR_BRA , A.ENV_OBSER_BRA , A.STATE , A.CODE_CITY_BRA , A.COURTID_BRA FROM %Table(GPBR_STG_JUD01) A , %Table(GPBR_DRIVER_DAT) B WHERE A.GPBR_DRIVER_SEQ = B.GPBR_DRIVER_SEQ AND A.GPBR_DRV_SPLIT_SEQ = B.GPBR_DRV_SPLIT_SEQ AND B.GPBR_STATUS = 'XRDY' AND B.GPBR_ACTION = 'ADD'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPBR_DRIVER_SEQ Number(30,0) DECIMAL(30) NOT NULL Driver Sequence
2 GPBR_DRV_SPLIT_SEQ Number(20,0) DECIMAL(20) NOT NULL eSocial - Split Sequence
3 PRC_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Process Type
1=Administrative
2=Judicial
3=Benefit Number - INSS
4=FAP - Process before 2019
4 PROC_NBR_BRA Character(21) VARCHAR2(21) NOT NULL Proceeding Number BRA
5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 AUTH_BY_BRA Character(1) VARCHAR2(1) NOT NULL Authorized by BRA
1=Taxpayer
2=Other Entity,Company/Employee
7 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
8 ENV_OBSER_BRA Long Character CLOB ENV_OBSER_BRA
9 STATE Character(6) VARCHAR2(6) NOT NULL State
10 CODE_CITY_BRA Number(7,0) INTEGER NOT NULL Code City Brazil
11 COURTID_BRA Number(4,0) SMALLINT NOT NULL Court ID Value BRA