RC_WRKR_JBAN_VW (SQL View)	Index Back
Assignment Summary View This view lists out all the jobs a worker or a POI has. The primary flag indicates which job is the worker's primary job.

RC_WRKR_JBAN_VW

(SQL View)

Assignment Summary View

This view lists out all the jobs a worker or a POI has. The primary flag indicates which job is the worker's primary job.

SELECT A.PERSON_ID , A.WRKR_ASGN_SEQ , A.BO_ID , A.PRIMARY_IND , A.ROLE_TYPE_ID , A.ORIG_HIRE_DT , A.ASGN_START_DT , A.ASGN_END_DT , B.WRKR_JOB_SEQ , B.SETID_JOBCODE , B.JOBCODE , B.SETID_LOCATION , B.LOCATION , B.EFFDT , B.EMPL_STATUS FROM PS_RD_WRKR_ASGN A , PS_RD_WRKR_JOB B WHERE A.PERSON_ID = B.PERSON_ID AND A.WRKR_ASGN_SEQ = B.WRKR_ASGN_SEQ AND A.ROLE_TYPE_ID IN (86 , 87 , 88) AND B.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_RD_WRKR_JOB C WHERE B.PERSON_ID = C.PERSON_ID AND B.WRKR_ASGN_SEQ = C.WRKR_ASGN_SEQ AND B.EFFDT = C.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
Default Value: NEXT
Prompt Table: RD_PERSON

2 WRKR_ASGN_SEQ Number(3,0) SMALLINT NOT NULL Assignment Sequence
Default Value: 0

3 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

4 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
N=No
Y=Yes
Default Value: N

5 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID
Default Value: 86
Prompt Table: RD_W_ROLE_TYPE

6 ORIG_HIRE_DT Date(10) DATE Original Hired Date
Default Value: %Date

7 ASGN_START_DT Date(10) DATE Start date of an assignment. This is different from the Person's Hire date.
Default Value: %Date

8 ASGN_END_DT Date(10) DATE End date of the specific EMPL_RCD assignment. This is different from the Person's Termination date.

9 WRKR_JOB_SEQ Number(3,0) SMALLINT NOT NULL Job Sequence
Default Value: 0

10 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

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

12 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID

13 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.

14 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

15 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Default Value: NEXT Prompt Table: RD_PERSON
2	WRKR_ASGN_SEQ	Number(3,0)	SMALLINT NOT NULL	Assignment Sequence Default Value: 0
3	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
4	PRIMARY_IND	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether or not it is Primary N=No Y=Yes Default Value: N
5	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID Default Value: 86 Prompt Table: RD_W_ROLE_TYPE
6	ORIG_HIRE_DT	Date(10)	DATE	Original Hired Date Default Value: %Date
7	ASGN_START_DT	Date(10)	DATE	Start date of an assignment. This is different from the Person's Hire date. Default Value: %Date
8	ASGN_END_DT	Date(10)	DATE	End date of the specific EMPL_RCD assignment. This is different from the Person's Termination date.
9	WRKR_JOB_SEQ	Number(3,0)	SMALLINT NOT NULL	Job Sequence Default Value: 0
10	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
11	JOBCODE	Character(15)	VARCHAR2(15) NOT NULL	Job Code or Job Title. Prompt Table: JOBCD_WRK_VW
12	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
13	LOCATION	Character(15)	VARCHAR2(15) NOT NULL	This field stores the Location Code.
14	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
15	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