GPBR_DRVJUD_XRF

(SQL Table)
Index Back

eSocial Judicial Cross Refer

eSocial Proceeding Number Cross Reference Table This record is composed by fields that are common to events of Juducial Proceeding (S-1070). Each event that shall be sent to the government has an entry on this table.

# 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 GPBR_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code
4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
5 PRC_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Process Type
1=Administrative
2=Judicial
3=Benefit Number - INSS
4=FAP - Process before 2019
6 PROC_NBR_BRA Character(21) VARCHAR2(21) NOT NULL Proceeding Number BRA
7 GPBR_ES_PS Date(10) DATE eSocial on PeopleSoft Date
8 GPBR_PRV_DT Date(10) DATE eSocial Previous Date