| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
Prompt Table:
RD_PERSON
|
| 2 |
WRKR_ASGN_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Assignment Sequence
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
Default Value: 0
|
| 5 |
WRKR_JOB_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Job Sequence
Default Value: 0
|
| 6 |
BO_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 7 |
JOB_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee.
In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable
P=Primary Job
S=Secondary Job
Default Value: P
|
| 8 |
EMPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Employment Status. e.g., Active, Leave of Absence, Terminated, Retired, etc.
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
Default Value: A
|
| 9 |
HR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
An indication whether a worker is still on payroll.
HR_STATUS = "A" if EMPL_STATUS in ("A", "L", "P", "S", "W");
HR_STATUS = "A" if EMPL_STATUS not in ("A", "L", "P", "S", "W");
A=Active
I=Inactive
Default Value: A
|
| 10 |
SOURCE_IND |
Character(4) |
VARCHAR2(4) NOT NULL |
EIP Source Indicator
CRM=CRM
EBS=EBIZ Suite
EXT=External
HRMS=HCM
SCM=SCM
Default Value: CRM
|
| 11 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies whether the worker is a Regular employee or a Temporary employee.
R=Regular
T=Temporary
Default Value: R
|
| 12 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies whether the employee works Full Time or Part Time.
F=Full-Time
P=Part-Time
Default Value: F
|
| 13 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
This field stores the General Ledger Business Unit. Used for the Integration with Contracts/Billing from CRM.
Prompt Table:
SP_BU_FS_NONVW
|
| 14 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table:
SETID_DEPT_VW
|
| 15 |
DEPTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Department
Prompt Table:
DEPT_TBL_WRK_VW
|
| 16 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location SetID
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table:
SETID_LOCATN_VW
|
| 17 |
LOCATION |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the Location Code.
Prompt Table:
LOCATION_WRK_VW
|
| 18 |
PHYSICAL_LOCATION |
Character(30) |
VARCHAR2(30) NOT NULL |
Physical Location (Free-Form)
|
| 19 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
SETID_JOBCODE field used in the HCM/ CRM sync Application Messages.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table:
SETID_JOBCD_VW
|
| 20 |
JOBCODE |
Character(15) |
VARCHAR2(15) NOT NULL |
Job Code or Job Title.
Prompt Table:
JOBCD_WRK_VW
|
| 21 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
This is the holiday schedule field.
Prompt Table:
HOLIDAY_VW
|
| 22 |
SUPERVISOR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
ID of a worker's supervisor.
Prompt Table:
RB_WORKER_SRCH
|
| 23 |
OFFICER_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Officer Code for a company. E.g., Chairman, Director, President, Treasurer, etc.
C=Chairman
D=Director
N=None
O=Officer
P=President
S=Secretary
T=Treasurer
V=Vice President
Default Value: N
|
| 24 |
MANAGER_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Manager Level.
0=Chief Operating Officer
1=Director
2=Senior Officer
3=Vice President
4=Senior Manager
5=Mid-Level Manager
6=First-Line Manager
7=Supervisor
8=All Other Positions
9=Non-Manager
Default Value: 9
|
| 25 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 26 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 27 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 28 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 29 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 30 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|