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

RC_BO_WRK_POIV2

(SQL View)

Worker and POI View

View to Fetch BO_ID_CONTACT and Wroker and POI

SELECT n.BO_ID , %Substring(n.BO_NAME_DISPLAY, 1, 50) , p.EMPLID , p.PERSON_ID , n.FIRST_NAME , n.LAST_NAME , n.MIDDLE_NAME FROM %Table(BO_NAME) n , %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 NAME Character(50) VARCHAR2(50) NOT NULL Name

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

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

#	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	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
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