| # |
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 |
EMPL_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Classification
|
| 4 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 5 |
HPROV_CD_BRA |
Character(10) |
VARCHAR2(10) NOT NULL |
Health Provider Code
|
| 6 |
GPBR_IDE_DMDEV |
Character(30) |
VARCHAR2(30) NOT NULL |
eSocial Unique payment identifier.
|
| 7 |
GPBR_COM_INS_TYPEE |
Character(2) |
VARCHAR2(2) NOT NULL |
Company Inscription Type
|
| 8 |
GPBR_ESTAB_ID_EST |
Character(20) |
VARCHAR2(20) NOT NULL |
Establishment ID
|
| 9 |
GPBR_COD_LOCAT |
Character(30) |
VARCHAR2(30) NOT NULL |
eSocial Location Code
|
| 10 |
HPROV_CNPJ_BRA |
Character(14) |
VARCHAR2(14) NOT NULL |
Health Provider CNPJ
|
| 11 |
DEPENDENT_BENEF |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default
|
| 12 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 13 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 14 |
GPBR_PERS_NAME |
Character(70) |
VARCHAR2(70) NOT NULL |
Used to keep a person name.
|
| 15 |
RELATIONSHIP |
Character(2) |
VARCHAR2(2) NOT NULL |
Relationship to Employee
|
| 16 |
GPBR_DEP_TYPE_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
eSocial Dependent Type Legal Code
00=Not Applicable
01=Spouse
02=Partner with Chilldren/<5 yrs
03=Child/StepChild
04=Child/StepChild Univ. Student
04=Child/StepChild Univ. Student
06=Siblings/GrandChild
07=Siblings/Grandchild Univ.Stdnt
07=Siblings/Grandchild Univ.Stdnt
09=Parents/Grand/GreatGra Parents
10=Poor Minors
11=Disabled Person with Guardian
12=Ex Spouse
99=Aggregate / Others
|
| 17 |
GPBR_VLREC |
Number(17,2) |
DECIMAL(16,2) NOT NULL |
eSocial Payment
|