RB_TSK_PH_VW (SQL View)	Index Back
View to get Phone Number. View to get phone number of the person. Used by Task Management.

RB_TSK_PH_VW

(SQL View)

View to get Phone Number.

View to get phone number of the person. Used by Task Management.

SELECT A.BO_ID , B.PROFILE_CM_SEQ , A.CM_PURPOSE_TYPE_ID , C.PHONE , C.CM_CONCAT , C.CM_CONCAT_UPPER FROM PS_CM C , PS_BO_ABE_DTL B , PS_BO_CM A WHERE A.CM_TYPE_ID = 2 AND A.BO_ID = B.BO_ID AND B.ABE_SEQ = 1 AND A.PROFILE_CM_SEQ = B.PROFILE_CM_SEQ AND A.CM_ID = C.CM_ID AND B.ROW_ADDED_DTTM = ( SELECT MIN(D.ROW_ADDED_DTTM) FROM PS_BO_ABE_DTL D , PS_BO_CM E WHERE B.BO_ID = D.BO_ID AND B.BO_ID = E.BO_ID AND E.CM_TYPE_ID = 2)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID_PERSON Number(31,0) DECIMAL(31) NOT NULL Business Object ID

2 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.

3 CM_PURPOSE_TYPE_ID Number(6,0) INTEGER NOT NULL Relationship Contact Method Purpose ID

4 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.

5 CM_CONCAT Character(100) VARCHAR2(100) NOT NULL Concatenated Contact Method

6 CM_CONCAT_UPPER Character(100) VARCHAR2(100) NOT NULL Uppper Concatenated Contact Method

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_PERSON	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
2	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.
3	CM_PURPOSE_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Relationship Contact Method Purpose ID
4	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.
5	CM_CONCAT	Character(100)	VARCHAR2(100) NOT NULL	Concatenated Contact Method
6	CM_CONCAT_UPPER	Character(100)	VARCHAR2(100) NOT NULL	Uppper Concatenated Contact Method