RD_WORK_G_VW (SQL View)	Index Back
RD_WORK_G_VW SELECT DISTINCT A.PERSON_ID , A.TITLE , A.EMPLID , D.EMPL_STATUS , A.BO_ID , B.FIRST_NAME , B.LAST_NAME , B.NAME_AC FROM PS_RD_PERSON A , PS_BO_NAME B , PS_BO_ROLE C , PS_RB_WORKER D WHERE A.BO_ID = B.BO_ID AND A.BO_ID = C.BO_ID AND A.PERSON_ID = D.PERSON_ID AND C.ROLE_TYPE_ID = 4 AND (MARKET = 'GBL' OR MARKET = ' ')

RD_WORK_G_VW

(SQL View)

RD_WORK_G_VW

SELECT DISTINCT A.PERSON_ID , A.TITLE , A.EMPLID , D.EMPL_STATUS , A.BO_ID , B.FIRST_NAME , B.LAST_NAME , B.NAME_AC FROM PS_RD_PERSON A , PS_BO_NAME B , PS_BO_ROLE C , PS_RB_WORKER D WHERE A.BO_ID = B.BO_ID AND A.BO_ID = C.BO_ID AND A.PERSON_ID = D.PERSON_ID AND C.ROLE_TYPE_ID = 4 AND (MARKET = 'GBL' OR MARKET = ' ')

SELECT A.PERSON_ID , A.TITLE , A.EMPLID , F.EBS_EMPLID , D.EMPL_STATUS , D.PHYSICAL_LOCATION , A.BO_ID , B.FIRST_NAME , B.FIRST_NAME_SRCH , B.LAST_NAME , B.LAST_NAME_SRCH , B.NAME_AC , C.ROLE_START_DT , C.ROW_ADDED_OPRID , D.SYNCID FROM PS_RD_PERSON A LEFT OUTER JOIN PS_RC_EBSWORKER_VW F ON A.BO_ID=F.BO_ID , PS_BO_NAME B , PS_BO_ROLE C , PS_RB_WORKER_ALL D WHERE A.BO_ID = B.BO_ID AND A.BO_ID = C.BO_ID AND A.BO_ID = D.BO_ID AND B.PRIMARY_IND = 'Y' AND C.ROLE_TYPE_ID = 4 AND C.ROLE_START_DT = ( SELECT MIN(E.ROLE_START_DT) FROM PS_BO_ROLE E WHERE C.BO_ID = E.BO_ID AND E.ROLE_TYPE_ID = 4)

Related Language Record: RD_WORK_G_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

2 TITLE Character(35) VARCHAR2(35) NOT NULL Title

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 EBS_EMPLID Character(30) VARCHAR2(30) NOT NULL EBS Employee Number used in the EBS - HR HelpDesk integration.

5 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

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

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

8 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

9 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name

10 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

11 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

12 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

13 ROLE_START_DT Date(10) DATE Start Date of Role

14 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
Prompt Table: RD_OPR_PR_NM_V3

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
2	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EBS_EMPLID	Character(30)	VARCHAR2(30) NOT NULL	EBS Employee Number used in the EBS - HR HelpDesk integration.
5	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
6	PHYSICAL_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Physical Location (Free-Form)
7	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
8	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
9	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
10	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
11	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
12	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
13	ROLE_START_DT	Date(10)	DATE	Start Date of Role
14	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row. Prompt Table: RD_OPR_PR_NM_V3
15	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.