|
SELECT JOB.PERSON_ID , JOB.EFFDT , JOB.BO_ID , JOB.EMPL_STATUS , JOB.HR_STATUS , JOB.SOURCE_IND , JOB.REG_TEMP , JOB.FULL_PART_TIME , JOB.BUSINESS_UNIT_GL , JOB.SETID_DEPT , JOB.DEPTID , JOB.SETID_LOCATION , JOB.LOCATION , JOB.PHYSICAL_LOCATION , JOB.SETID_JOBCODE , JOB.JOBCODE , JOB.HOLIDAY_SCHEDULE , JOB.SUPERVISOR_ID , JOB.OFFICER_CD , JOB.MANAGER_LEVEL , %subrec(RB_AUDIT_SBR, PER) FROM PS_RD_WRKR_JOB JOB , PS_RD_WRKR_ASGN ASGN , PS_RD_PERSON PER WHERE ASGN.PERSON_ID = PER.PERSON_ID AND ASGN.ROLE_TYPE_ID IN (86, 87) AND ASGN.PRIMARY_IND = 'Y' AND JOB.PERSON_ID = ASGN.PERSON_ID AND JOB.WRKR_ASGN_SEQ = ASGN.WRKR_ASGN_SEQ AND JOB.WRKR_JOB_SEQ = ASGN.WRKR_JOB_SEQ
|
| # |
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 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
BO_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 4 |
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
|
| 5 |
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
|
| 6 |
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
|
| 7 |
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
|
| 8 |
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
|
| 9 |
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
|
| 10 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table:
SETID_DEPT_VW
|
| 11 |
DEPTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Department
Prompt Table:
DEPT_TBL_WRK_VW
|
| 12 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location SetID
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table:
SETID_LOCATN_VW
|
| 13 |
LOCATION |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the Location Code.
Prompt Table:
LOCATION_WRK_VW
|
| 14 |
PHYSICAL_LOCATION |
Character(30) |
VARCHAR2(30) NOT NULL |
Physical Location (Free-Form)
|
| 15 |
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
|
| 16 |
JOBCODE |
Character(15) |
VARCHAR2(15) NOT NULL |
Job Code or Job Title.
Prompt Table:
JOBCD_WRK_VW
|
| 17 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
This is the holiday schedule field.
Prompt Table:
HOLIDAY_VW
|
| 18 |
SUPERVISOR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
ID of a worker's supervisor.
Prompt Table:
RB_WORKER_SRCH
|
| 19 |
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
|
| 20 |
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
|
| 21 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 22 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 23 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 24 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 25 |
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.
|
| 26 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|