| # |
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 |
LOCAT_TYPE_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
eSocial Location Type
|
| 7 |
ESTAB_TYPE_CD_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Establishment Type Code
1=Micro
2=Small
3=Other
|
| 8 |
ESTAB_ID_BRA |
Character(20) |
VARCHAR2(20) NOT NULL |
Establishment ID Brazil
|
| 9 |
GPBR_REG_ESOCIAL |
Character(30) |
VARCHAR2(30) NOT NULL |
eSocial eSocial Register
|
| 10 |
GPBR_LABOR_CAT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
eSocial Labor Category Legal Code
|
| 11 |
GPBR_PER_REF |
Character(7) |
VARCHAR2(7) NOT NULL |
eSocial Reference Period
|
| 12 |
GPBR_GATHER_ATTRIB |
Character(2) |
VARCHAR2(2) NOT NULL |
Gathering Attribute
01=01 Case Of Amnesty
02=02 Illness To Work Accident
03=03 Labor Claim
04=LC w/Employment Recognition
05=05 Collective Dispute
06=06 Collective Agreement
07=07 Collective Convention
08=08 Previous Reconciliation
|
| 13 |
GPBR_FG_TP_AMT |
Character(2) |
VARCHAR2(2) NOT NULL |
FGTS amount type.
|
| 14 |
GPBR_FG_AMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates the existence of FGTS amounts.
|
| 15 |
GPBR_PIN_NUM_ITEN |
Character(30) |
VARCHAR2(30) NOT NULL |
eSocial Wage Code
|
| 16 |
GPBR_ID_TAB_WAGE |
Character(30) |
VARCHAR2(30) NOT NULL |
eSocial Wage Code
|
| 17 |
GPBR_ESOC_AMT_01 |
Number(17,2) |
DECIMAL(16,2) NOT NULL |
eSocial generic amount.
|
| 18 |
PROCEED_NBR_BRA |
Character(20) |
VARCHAR2(20) NOT NULL |
Proceeding Number
|