GPBR_ES5011_BRE

(SQL Table)
 Index Back

Social security calc basis

Social security calculation basis: basesRemun tag fields in S-5011 file.

# 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_ESTAB_IN_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Establishment Inscription Type
1=CNPJ
3=CAEPF
4=CNO
4 GPBR_ESTAB_ID_EST Character(20) VARCHAR2(20) NOT NULL Establishment ID
5 GPBR_COD_LOCAT Character(30) VARCHAR2(30) NOT NULL eSocial Location Code
6 GPBR_OCCUR_CODE Character(1) VARCHAR2(1) NOT NULL Occurrence type code.
7 GPBR_LABOR_CAT_CD Character(3) VARCHAR2(3) NOT NULL eSocial Labor Category Legal Code
8 GPBR_ESOC_AMT_01 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
9 GPBR_ESOC_AMT_02 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
10 GPBR_ESOC_AMT_03 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
11 GPBR_ESOC_AMT_04 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
12 GPBR_ESOC_AMT_05 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
13 GPBR_ESOC_AMT_06 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
14 GPBR_ESOC_AMT_07 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
15 GPBR_ESOC_AMT_08 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
16 GPBR_ESOC_AMT_09 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
17 GPBR_ESOC_AMT_10 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
18 GPBR_ESOC_AMT_11 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
19 GPBR_ESOC_AMT_12 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
20 GPBR_ESOC_AMT_13 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
21 GPBR_ESOC_AMT_14 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
22 GPBR_ESOC_AMT_15 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
23 GPBR_ESOC_AMT_16 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
24 GPBR_ESOC_AMT_17 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
25 GPBR_ESOC_AMT_18 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
26 GPBR_ESOC_AMT_19 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
27 GPBR_ESOC_AMT_20 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
28 GPBR_ESOC_AMT_21 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
29 GPBR_ESOC_AMT_22 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.