BO_ROLE_CMS_VW (SQL View)	Index Back
Role Contact Method View Retrieving all Contact methods associated with a BO Role. This view is a worker role security enabled. This view filters out Home Contact Methods. This view filters Home Phone, Home Email and Home Address if the logged in Agent does not have access to view these information. Note: This view is same as BO_ROLE_CM_VW with security enabled.

BO_ROLE_CMS_VW

(SQL View)

Role Contact Method View

Retrieving all Contact methods associated with a BO Role. This view is a worker role security enabled. This view filters out Home Contact Methods. This view filters Home Phone, Home Email and Home Address if the logged in Agent does not have access to view these information. Note: This view is same as BO_ROLE_CM_VW with security enabled.

SELECT A.BO_ID , A.ROLE_TYPE_ID , B.PROFILE_CM_SEQ , A.ROLE_START_DT , C.BO_CM_START_DT , B.CM_USE_START_DT , A.ROLE_END_DT , C.BO_CM_END_DT , B.CM_USE_END_DT , C.CM_TYPE_ID , C.CM_ID , B.PRIMARY_IND , C.CM_NICKNAME , C.CM_PURPOSE_TYPE_ID , C.PHYSICAL_LOCATION FROM PS_BO_ROLE A , PS_BO_CM_USE B , PS_BO_CM C WHERE A.BO_ID = B.BO_ID AND A.ROLE_TYPE_ID = B.ROLE_TYPE_ID AND B.BO_CM_USE_TYPE = 'R' AND A.BO_ID = C.BO_ID AND B.PROFILE_CM_SEQ = C.PROFILE_CM_SEQ AND C.CM_PURPOSE_TYPE_ID NOT IN (15, 30, 35)

# 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 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

3 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.

4 ROLE_START_DT Date(10) DATE Start Date of Role

5 BO_CM_START_DT Date(10) DATE The date that a Contact Method of a Business Object takes effect.

6 CM_USE_START_DT Date(10) DATE Contact Method Use Start Date

7 ROLE_END_DT Date(10) DATE End Date of Role

8 BO_CM_END_DT Date(10) DATE End date of a Contact Method of a Business Object

9 CM_USE_END_DT Date(10) DATE End date of a Contact Method Use

10 CM_TYPE_ID Number(6,0) INTEGER NOT NULL Contact Method Type ID
Prompt Table: CM_TYPE

11 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID

12 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
N=No
Y=Yes

13 CM_NICKNAME Character(30) VARCHAR2(30) NOT NULL Nickname of a Contact Method

14 CM_PURPOSE_TYPE_ID Number(6,0) INTEGER NOT NULL Relationship Contact Method Purpose ID
Prompt Table: CM_PURP_TYPE

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

#	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	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
3	PROFILE_CM_SEQ	Number(31,0)	DECIMAL(31) NOT NULL	The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
4	ROLE_START_DT	Date(10)	DATE	Start Date of Role
5	BO_CM_START_DT	Date(10)	DATE	The date that a Contact Method of a Business Object takes effect.
6	CM_USE_START_DT	Date(10)	DATE	Contact Method Use Start Date
7	ROLE_END_DT	Date(10)	DATE	End Date of Role
8	BO_CM_END_DT	Date(10)	DATE	End date of a Contact Method of a Business Object
9	CM_USE_END_DT	Date(10)	DATE	End date of a Contact Method Use
10	CM_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Contact Method Type ID Prompt Table: CM_TYPE
11	CM_ID	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
12	PRIMARY_IND	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether or not it is Primary N=No Y=Yes
13	CM_NICKNAME	Character(30)	VARCHAR2(30) NOT NULL	Nickname of a Contact Method
14	CM_PURPOSE_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Relationship Contact Method Purpose ID Prompt Table: CM_PURP_TYPE
15	PHYSICAL_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Physical Location (Free-Form)