RB_CNSM_CONT_VW (SQL View)	Index Back
The Contact Customer view This view returns all the customers the person belongs to.

RB_CNSM_CONT_VW

(SQL View)

The Contact Customer view

This view returns all the customers the person belongs to.

SELECT A.PERSON_ID , C.PERSON_ID , A.BO_ID , C.BO_ID , B.START_DT , B.ROLE_TYPE_ID_1 , B.ROLE_TYPE_ID_2 , B.REL_TYPE_ID FROM PS_RD_PERSON A , PS_BO_REL B , PS_RD_PERSON C WHERE A.BO_ID = B.BO_ID_2 AND B.BO_ID_1 = C.BO_ID AND B.ROLE_TYPE_ID_1 = 8 AND B.ROLE_TYPE_ID_2 = 9 AND B.REL_TYPE_ID IN (13, 14) AND B.START_DT <= %CurrentDateIn AND B.END_DT > %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PERSON_ID_CONT Character(15) VARCHAR2(15) NOT NULL Person ID
Prompt Table: RD_PERSON_NM_VW

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

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

5 START_DT Date(10) DATE Start date field to store start date value.

6 ROLE_TYPE_ID_1 Number(12,0) DECIMAL(12) NOT NULL Role Type ID
Default Value: 8

7 ROLE_TYPE_ID_2 Number(12,0) DECIMAL(12) NOT NULL Role Type ID
Default Value: 9

8 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
2	PERSON_ID_CONT	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RD_PERSON_NM_VW
3	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
4	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
5	START_DT	Date(10)	DATE	Start date field to store start date value.
6	ROLE_TYPE_ID_1	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID Default Value: 8
7	ROLE_TYPE_ID_2	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID Default Value: 9
8	REL_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Relationship Type ID