RC_EBSWORKER_VW (SQL View)	Index Back
EBS Worker This view contains the EBS Employee Number along with the PSFT CRM BO_ID and is used for BO Search in the EBS - HR HelpDesk Case and 360 Degree View.

RC_EBSWORKER_VW

(SQL View)

EBS Worker

This view contains the EBS Employee Number along with the PSFT CRM BO_ID and is used for BO Search in the EBS - HR HelpDesk Case and 360 Degree View.

SELECT A.BO_ID , B.EBS_EMPLID FROM PS_RC_EBSPSFTID_VW A , PS_RC_EBSEMPLID_VW B WHERE A.EOTF_MAP_NAME = B.EOTF_MAP_NAME AND A.EOTF_COMMONELEMENT = B.EOTF_COMMONELEMENT

# 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 EBS_EMPLID Character(30) VARCHAR2(30) NOT NULL EBS Employee Number used in the EBS - HR HelpDesk integration.

#	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	EBS_EMPLID	Character(30)	VARCHAR2(30) NOT NULL	EBS Employee Number used in the EBS - HR HelpDesk integration.