RC_SS_WRKPOI_VW (SQL View)	Index Back
Worker and POI View View to Fetch BO_ID_CONTACT and Wroker and POI

RC_SS_WRKPOI_VW

(SQL View)

Worker and POI View

View to Fetch BO_ID_CONTACT and Wroker and POI

SELECT n.BO_ID , p.EMPLID ,n.BO_NAME_DISPLAY , p.PERSON_ID , n.FIRST_NAME , n.LAST_NAME , n.MIDDLE_NAME , e.EMAIL_ADDR FROM %Table(BO_NAME) n LEFT OUTER JOIN %Table(BO_PRIM_EMAL_VW) E ON N.BO_ID = E.BO_ID , %Table(RD_PERSON) p WHERE p.BO_ID IN ( SELECT r.BO_ID FROM %Table(BO_ROLE) r WHERE r.ROLE_TYPE_ID IN (4, 88) AND r.ROLE_START_DT <= %CurrentDateIn AND r.ROLE_END_DT > %CurrentDateIn ) AND n.BO_ID = p.BO_ID AND n.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

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

3 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

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

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

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

7 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name

8 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
4	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
5	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
6	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
7	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Middle Name
8	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.