|
SELECT A.BO_ID , B.PERSON_ID , B.EMPL_STATUS , B.HR_STATUS , B.SETID_DEPT , B.DEPTID , B.SETID_LOCATION , B.LOCATION , B.SETID_JOBCODE , B.JOBCODE , B.REG_TEMP , B.FULL_PART_TIME , B.OFFICER_CD , B.MANAGER_LEVEL , B.SUPERVISOR_ID , B.PHYSICAL_LOCATION , B.HOLIDAY_SCHEDULE , B.SOURCE_IND FROM PS_RD_PERSON A , PS_RB_WORKER B WHERE A.PERSON_ID = B.PERSON_ID
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BO_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 2 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
|
| 3 |
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
|
| 4 |
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
|
| 5 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
|
| 6 |
DEPTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Department
|
| 7 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location SetID
|
| 8 |
LOCATION |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the Location Code.
|
| 9 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
SETID_JOBCODE field used in the HCM/ CRM sync Application Messages.
|
| 10 |
JOBCODE |
Character(15) |
VARCHAR2(15) NOT NULL |
Job Code or Job Title.
|
| 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
|
| 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
|
| 13 |
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
|
| 14 |
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
|
| 15 |
SUPERVISOR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
ID of a worker's supervisor.
|
| 16 |
PHYSICAL_LOCATION |
Character(30) |
VARCHAR2(30) NOT NULL |
Physical Location (Free-Form)
|
| 17 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
This is the holiday schedule field.
|
| 18 |
SOURCE_IND |
Character(4) |
VARCHAR2(4) NOT NULL |
EIP Source Indicator
CRM=CRM
EBS=EBIZ Suite
EXT=External
HRMS=HCM
SCM=SCM
|