GPBR_ES5011_TBL (SQL Table)	Index Back
eSocial S-5011 event Store S-5011 (social contribution by employer) information returned by the government.

GPBR_ES5011_TBL

(SQL Table)

eSocial S-5011 event

Store S-5011 (social contribution by employer) 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_DET Number(1,0) SMALLINT NOT NULL eSocial Ind Calculation

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 GPBR_RECEIPT_NUM Character(40) VARCHAR2(40) NOT NULL Receipt Num

9 GPBR_SOC_AMT_FLG Character(1) VARCHAR2(1) NOT NULL Indicates the existence of social security amounts.

10 GPBR_TOT_DED_AMT Number(17,2) DECIMAL(16,2) NOT NULL Total deducted amount from the social security beneficiary.

11 GPBR_SOC_DUE_AMT Number(17,2) DECIMAL(16,2) NOT NULL Social security due amount.

12 TAX_CLASSIF_BRA Character(2) VARCHAR2(2) NOT NULL Tax Classification Field.

13 IND_CONSTRUC_BRA Character(1) VARCHAR2(1) NOT NULL Construction Indicator for Brazil Company.

14 OTHER_SECTORS_BRA Character(1) VARCHAR2(1) NOT NULL Other Sectors
0=Not Applicable
1=Fully Replaced
2=Partially Replaced

15 GPBR_ES_PERC_RE Number(6,2) DECIMAL(5,2) NOT NULL eSocial % Reduction

16 GPBR_TAX_DUE Character(2) VARCHAR2(2) NOT NULL % Tax Due
1=0,200
2=0,400
3=0,600
4=0,800
5=1,000

17 PIS_COFINS_TAX_BRA Character(1) VARCHAR2(1) NOT NULL PIS/COFINS Tax Indicator.

18 GPBR_CALC_AMT_RT Number(6,4) DECIMAL(5,4) NOT NULL Rate used to calculate the amount deduction for social security contribution.

19 GPBR_CALC_AMT13_RT Number(6,2) DECIMAL(5,2) NOT NULL Rate used to calculate the deduction amount upon Christmas bonus for social security contribution.

#	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_DET	Number(1,0)	SMALLINT NOT NULL	eSocial Ind Calculation
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	GPBR_RECEIPT_NUM	Character(40)	VARCHAR2(40) NOT NULL	Receipt Num
9	GPBR_SOC_AMT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates the existence of social security amounts.
10	GPBR_TOT_DED_AMT	Number(17,2)	DECIMAL(16,2) NOT NULL	Total deducted amount from the social security beneficiary.
11	GPBR_SOC_DUE_AMT	Number(17,2)	DECIMAL(16,2) NOT NULL	Social security due amount.
12	TAX_CLASSIF_BRA	Character(2)	VARCHAR2(2) NOT NULL	Tax Classification Field.
13	IND_CONSTRUC_BRA	Character(1)	VARCHAR2(1) NOT NULL	Construction Indicator for Brazil Company.
14	OTHER_SECTORS_BRA	Character(1)	VARCHAR2(1) NOT NULL	Other Sectors 0=Not Applicable 1=Fully Replaced 2=Partially Replaced
15	GPBR_ES_PERC_RE	Number(6,2)	DECIMAL(5,2) NOT NULL	eSocial % Reduction
16	GPBR_TAX_DUE	Character(2)	VARCHAR2(2) NOT NULL	% Tax Due 1=0,200 2=0,400 3=0,600 4=0,800 5=1,000
17	PIS_COFINS_TAX_BRA	Character(1)	VARCHAR2(1) NOT NULL	PIS/COFINS Tax Indicator.
18	GPBR_CALC_AMT_RT	Number(6,4)	DECIMAL(5,4) NOT NULL	Rate used to calculate the amount deduction for social security contribution.
19	GPBR_CALC_AMT13_RT	Number(6,2)	DECIMAL(5,2) NOT NULL	Rate used to calculate the deduction amount upon Christmas bonus for social security contribution.