| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
GPBR_ES_EMP_VW
|
| 4 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
GPBR_CMP_PH_VW
|
| 5 |
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
|
| 6 |
GPBR_EVENT_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
eSocial - Event Code
|
| 7 |
HIRE_DT |
Date(10) |
DATE NOT NULL |
First Start Date
|
| 8 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Default Value: OPR_DEF_TBL_HR.REG_REGION
Prompt Table:
REG_STANDARD_VW
|
| 9 |
SETID_EMPL_CLASS |
Character(5) |
VARCHAR2(5) NOT NULL |
Employee class Set ID
|
| 10 |
EMPL_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Classification
Prompt Table:
EMPL_CLASS_TBL
Set Control Field: REG_REGION
|
| 11 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT
Prompt Table:
BUSUNIT_HR_VW
|
| 12 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
Default Value: OPR_DEF_TBL_HR.SETID
|
| 13 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 14 |
CBO_CD_BRA |
Character(7) |
VARCHAR2(7) NOT NULL |
Occupation Code for Brazil
Prompt Table:
CBO_CD_TBL_BRA
|
| 15 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 16 |
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
|
| 17 |
CNTR_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Type Bra
1=Indeterminate
2=Indeterminate w/probation prd
3=Determinate
|
| 18 |
CONTRACT_END_DT |
Date(10) |
DATE |
Contract End Date
|