| # |
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 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 4 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 5 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 6 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
GPBR_CMP_FLG_VW
|
| 7 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
GPBR_ES_EMP_VW
|
| 8 |
GPBR_ES_MAP_DT |
Date(10) |
DATE |
eSocial Mapping Date
|
| 9 |
GPBR_ES_PS |
Date(10) |
DATE |
eSocial on PeopleSoft Date
|
| 10 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 11 |
GPBR_EVENT_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
eSocial - Event Code
|
| 12 |
GPBR_ES_SOURCE |
Character(4) |
VARCHAR2(4) NOT NULL |
Source process Batch
ILB=Initial Loading Basic Tables
ILE=Initial Loading Employee
MBT=Mapping Basic Tables
MNP=Mapping Non Periodic
PHR=Pre-Hiring Tables
TER=Termination
Default Value: PHR
|
| 13 |
GPBR_ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
eSocial Action
ADD=Row Inserted
COR=Row Correction
DEL=Row Deleted
UPD=Row Updated
Default Value: ADD
|
| 14 |
GPBR_ORIG_ESOC |
Character(1) |
VARCHAR2(1) NOT NULL |
eSocial Process Origin Drivers/Stages
B=Batch Process
E=External Process
I=Initial Load Process
M=Manual Process
O=On-Line Process
Default Value: O
|
| 15 |
GPBR_ES_STATUS_PH |
Character(4) |
VARCHAR2(4) NOT NULL |
Status Pre-Hiring
AEXC=Await Exclusion
CANC=Canceled
COMP=Complete
ERRO=Error
HIRE=Hired
HPRO=Hiring in Progress
PEHR=Pending Hiring
RDY=Ready
RECT=Rectified
WHIR=Withdraw Hiring
WPHR=Withdraw Pre-Hiring
XSEN=Wait for Return
|
| 16 |
USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 17 |
ACTION_DATE |
Date(10) |
DATE |
Date of action
|
| 18 |
GPBR_PROTOC |
Character(50) |
VARCHAR2(50) NOT NULL |
Protocol
|
| 19 |
GPBR_RECEIPT_NUM |
Character(40) |
VARCHAR2(40) NOT NULL |
Receipt Num
|
| 20 |
GPBR_PRE_DRV_SEQ |
Number(30,0) |
DECIMAL(30) NOT NULL |
eSocial Pre Driver Sequence
|
| 21 |
GPBR_RECEIPT_PREV |
Character(40) |
VARCHAR2(40) NOT NULL |
Register Previous
|
| 22 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 23 |
SETID_EMPL_CLASS |
Character(5) |
VARCHAR2(5) NOT NULL |
Employee class Set ID
|
| 24 |
EMPL_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Classification
|
| 25 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 26 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
|
| 27 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 28 |
CBO_CD_BRA |
Character(7) |
VARCHAR2(7) NOT NULL |
Occupation Code for Brazil
|
| 29 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 30 |
CONT_SAL_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Salary Type Brazil
1=Monthly
2=Fortnightly
3=Weekly
4=Daily
5=Hourly
6=Per Task
7=Commission
8=Other
|
| 31 |
CNTR_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Type Bra
1=Indeterminate
2=Indeterminate w/probation prd
3=Determinate
|
| 32 |
CONTRACT_END_DT |
Date(10) |
DATE |
Contract End Date
|
| 33 |
REG_ESOCIAL_BRA |
Character(30) |
VARCHAR2(30) NOT NULL |
eSocial Reg. Number
|