RC_WRKR_JOB (SQL View)	Index Back
Current Primary Job This record contains the current primary job information of the worker and POI. This record contains all workers and POIs who has a primary job and the primary job is current.

RC_WRKR_JOB

(SQL View)

Current Primary Job

This record contains the current primary job information of the worker and POI. This record contains all workers and POIs who has a primary job and the primary job is current.

SELECT JOB.PERSON_ID , 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, 88) 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 AND JOB.EFFDT <=%CurrentDateIn

Parent record: RD_PERSON

# 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 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object 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
Default Value: A

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 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

6 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

7 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

8 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

9 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SETID_DEPT_VW

10 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
Prompt Table: DEPT_TBL_WRK_VW

11 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SETID_LOCATN_VW

12 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.
Prompt Table: LOCATION_WRK_VW

13 PHYSICAL_LOCATION Character(30) VARCHAR2(30) NOT NULL Physical Location (Free-Form)

14 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

15 JOBCODE Character(15) VARCHAR2(15) NOT NULL Job Code or Job Title.
Prompt Table: JOBCD_WRK_VW

16 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL This is the holiday schedule field.
Prompt Table: HOLIDAY_VW

17 SUPERVISOR_ID Character(15) VARCHAR2(15) NOT NULL ID of a worker's supervisor.
Prompt Table: RB_WORKER_SRCH

18 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

19 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

20 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

21 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

22 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

23 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

24 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.

25 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	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	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object 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 Default Value: A
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	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
6	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
7	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
8	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
9	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SETID_DEPT_VW
10	DEPTID	Character(15)	VARCHAR2(15) NOT NULL	Department Prompt Table: DEPT_TBL_WRK_VW
11	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SETID_LOCATN_VW
12	LOCATION	Character(15)	VARCHAR2(15) NOT NULL	This field stores the Location Code. Prompt Table: LOCATION_WRK_VW
13	PHYSICAL_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Physical Location (Free-Form)
14	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
15	JOBCODE	Character(15)	VARCHAR2(15) NOT NULL	Job Code or Job Title. Prompt Table: JOBCD_WRK_VW
16	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	This is the holiday schedule field. Prompt Table: HOLIDAY_VW
17	SUPERVISOR_ID	Character(15)	VARCHAR2(15) NOT NULL	ID of a worker's supervisor. Prompt Table: RB_WORKER_SRCH
18	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
19	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
20	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
21	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
22	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
23	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
24	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.
25	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time