| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
GPBR_COMPBRA_VW
|
| 2 |
GPBR_PROC_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Proceeding Source.
1=Judicial
2=Submitted to CCP or NINTER
|
| 3 |
GPBR_PROC_NUM |
Character(30) |
VARCHAR2(30) NOT NULL |
Proceeding Number
|
| 4 |
GPBR_CPF_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
eSocial National ID Number
|
| 5 |
SEQNBR |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 6 |
REG_ESOCIAL_BRA |
Character(30) |
VARCHAR2(30) NOT NULL |
eSocial Reg. Number
Prompt Table:
%EDITTABLE
|
| 7 |
GPBR_EMP_LBR_CATEG |
Character(3) |
VARCHAR2(3) NOT NULL |
eSocial Employee Labor Category Code.
Prompt Table:
GPBR_LCAT_CD_VW
|
| 8 |
GPBR_HIRE_TSV_DT |
Date(10) |
DATE |
Hire TSV Date
|
| 9 |
GPBR_PRC_CNTR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Type.
1=Employee-No Change
2=Employee-Hire Date Changed
3=Employee-TerminationDtChanged
4=Employee-Hire and Term Changed
5=Employment Relation Recognized
6=TSVE-No Employment Relation
7=Empl Record prior to eSocial
8=Indirect Liability
9=Unified Employment Contracts
|
| 10 |
ORIG_HIRE_DT |
Date(10) |
DATE |
Original Start Date
|
| 11 |
GPBR_ESOC_SENT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Sent to eSocial Indicator.
N=No
Y=Yes
|
| 12 |
GPBR_REINSTMT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Reinstatement
N=No
Y=Yes
|
| 13 |
GPBR_EMP_CAT_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Category Changed.
N=No
Y=Yes
|
| 14 |
GPBR_NAT_ACTV_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Nature of Activity Changed.
N=No
Y=Yes
|
| 15 |
GPBR_RSN_TERM_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reason for Termination Changed.
N=No
Y=Yes
|
| 16 |
GPBR_CNTR_UNI_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Contractual Unification Indicator.
N=No
Y=Yes
|
| 17 |
CBO_CD_BRA |
Character(7) |
VARCHAR2(7) NOT NULL |
Occupation Code for Brazil
Prompt Table:
GPBR_CBO_CD_VW
|
| 18 |
GPBR_NAT_ACTV |
Character(1) |
VARCHAR2(1) NOT NULL |
eSocial Nature of Activity
0=Not Applicable
1=URBAN
2=RURAL
|
| 19 |
GPBR_WORK_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
eSocial Work Type
0=Not Applicable
1=CLT
2=RJP
|
| 20 |
GPBR_SOC_SEC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
eSocial Social Security Type
0=Not Applicable
1=RGPS
2=RPPS
3=RPSE
|
| 21 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 22 |
GPBR_PARCIAL_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Parcial Time
0=Not a part-time contract
1=Limited to 25 hours per week
2=Limited to 30 hours per week
3=Limited to 26 hours per week
|
| 23 |
GPBR_CONTRACT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Type.
1=Indeterminate
2=Determinate - Defined in Days
3=Determinate - Fact Occurred
|
| 24 |
CONTRACT_END_DT |
Date(10) |
DATE |
Contract End Date
|
| 25 |
GPBR_CNTRCT_CLAUSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Clause of Mutual Termination Rights
N=No
Y=Yes
|
| 26 |
GPBR_INSCR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Inscription Type.
1=CNPJ
2=CPF
|
| 27 |
GPBR_CNPJ_PREV |
Character(14) |
VARCHAR2(14) NOT NULL |
CNPJ Number Previous
|
| 28 |
GPBR_REG_ESOC_PREV |
Character(30) |
VARCHAR2(30) NOT NULL |
Register Previous Number
|
| 29 |
GPBR_ORIG_DATE1 |
Date(10) |
DATE |
Date 1
|
| 30 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 31 |
GPBR_TERM_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
eSocial:Termination Legal Code.
Prompt Table:
GPBR_TER_CD_VW
|
| 32 |
GPBR_TERM_NOTIF |
Date(10) |
DATE |
Termination Notification
|
| 33 |
GPBR_ESTAB_IN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
eSocial Establishment Inscription Type
1=CNPJ
3=CAEPF
4=CNO
|
| 34 |
GPBR_CNPJ |
Character(14) |
VARCHAR2(14) NOT NULL |
Establlishment CNPJ Number
|
| 35 |
GPBR_DATE1 |
Date(10) |
DATE NOT NULL |
Date 1
|
| 36 |
GPBR_DATE2 |
Date(10) |
DATE NOT NULL |
Date Field used by Negative Delta Writable Array
|
| 37 |
GPBR_PRC_REPERCUSS |
Character(1) |
VARCHAR2(1) NOT NULL |
Proceeding Repercussion.
1=With Payment of Remunation Amt
2=Without Payment of Remun Amt
|
| 38 |
GPBR_ESOC_AMT_01 |
Number(17,2) |
DECIMAL(16,2) NOT NULL |
eSocial generic amount.
|
| 39 |
GPBR_ESOC_AMT_02 |
Number(17,2) |
DECIMAL(16,2) NOT NULL |
eSocial generic amount.
|
| 40 |
GPBR_ESOC_AMT_03 |
Number(17,2) |
DECIMAL(16,2) NOT NULL |
eSocial generic amount.
|
| 41 |
GPBR_ESOC_AMT_04 |
Number(17,2) |
DECIMAL(16,2) NOT NULL |
eSocial generic amount.
|
| 42 |
GPBR_ESOC_AMT_05 |
Number(17,2) |
DECIMAL(16,2) NOT NULL |
eSocial generic amount.
|
| 43 |
GPBR_FGTS_PAID |
Character(1) |
VARCHAR2(1) NOT NULL |
FGTS Paid
N=No
Y=Yes
|
| 44 |
GPBR_DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description.
|
| 45 |
GPBR_ALIMONY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Alimony Indicator
0=No Alimony
1=Percentage
2=Amount
3=Percentage and Amount
|
| 46 |
GPBR_ALIM_FGTS_PER |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Alimony percentage deduction of FGTS amount.
|
| 47 |
GPBR_ALIM_FGTS_AMT |
Signed Number(23,2) |
DECIMAL(21,2) NOT NULL |
Alimony deduction of FGTS amount.
|
| 48 |
GPBR_PRC_REPER_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Proceeding Repercussion Indicator.
1=With Tax Impact and/or FGTS
2=Without Tax Impact or FGTS
3=Exclusive for Income Statement
|
| 49 |
GPBR_UNEMP_BEN_REP |
Character(1) |
VARCHAR2(1) NOT NULL |
Unemployment Benefit Replacement.
N=No
Y=Yes
|