| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 2 |
GPBR_PROC_NUM |
Character(30) |
VARCHAR2(30) NOT NULL |
Proceeding Number
|
| 3 |
GPBR_ESOC_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Competency Year
|
| 4 |
GPBR_ESOC_MONTHCD |
Character(2) |
VARCHAR2(2) NOT NULL |
eSocial Competency Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
|
| 5 |
GPBR_CPF_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
eSocial National ID Number
|
| 6 |
PRC_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Type
1=Administrative
2=Judicial
3=Benefit Number - INSS
4=FAP - Process before 2019
|
| 7 |
PROC_NBR_BRA |
Character(21) |
VARCHAR2(21) NOT NULL |
Proceeding Number BRA
|
| 8 |
SUSP_CODE_BRA |
Number(14,0) |
DECIMAL(14) NOT NULL |
Suspension Code BRA
|
| 9 |
PERIOD_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Period Type.
1=Monthly
2=Annual (13th Salary)
|
| 10 |
SUSP_DED_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Suspended Deduction Type.
1=Public Pension
2=Private Pension
3=FAPI
4=Funpresp
5=Alimony
7=Dependents
|
| 11 |
AMOUNT1_BRA |
Number(17,2) |
DECIMAL(16,2) NOT NULL |
Amount
|