GPBR_ES5003_TBL

(SQL Table)
Index Back

eSocial S-5003 event

Store S-5003 (FGTS data by employee) information returned by the government.

# 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_ID Character(40) VARCHAR2(40) NOT NULL eSocial - Generate ID Number Governant
4 GPBR_RECEIPT_NUM Character(40) VARCHAR2(40) NOT NULL Receipt Num
5 GPBR_CAL_PRD_ID Character(7) VARCHAR2(7) NOT NULL eSocial Period Calculation
6 GPBR_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
7 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
8 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
9 GPBR_NAT_ID Character(11) VARCHAR2(11) NOT NULL eSocial National ID Number
10 DUE_DT Date(10) DATE Expected Birth Date
11 GPBR_DET Number(1,0) SMALLINT NOT NULL eSocial Ind Calculation