BO_PRSNCM_PHON (SQL View)	Index Back
Person Phone This is the Person Phone view.

BO_PRSNCM_PHON

(SQL View)

Person Phone

This is the Person Phone view.

SELECT A.PERSON_ID , B.CM_TYPE_ID , B.CM_USE_START_DT , B.CM_ID , B.PROFILE_CM_SEQ , B.CM_USE_END_DT , B.PRIMARY_IND , B.CM_NICKNAME , B.CM_PURPOSE_TYPE_ID , B.PHYSICAL_LOCATION , B.COUNTRY_CODE , B.PHONE , B.EXTENSION FROM PS_RD_PERSON A , PS_BO_ROLECM_PHON B WHERE A.BO_ID = B.BO_ID AND B.ROLE_TYPE_ID = 1 AND B.BO_CM_START_DT <= %CurrentDateIn AND B.BO_CM_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 CM_TYPE_ID Number(6,0) INTEGER NOT NULL Contact Method Type ID

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

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

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

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

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

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

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

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

11 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.

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

13 EXTENSION Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
2	CM_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Contact Method Type ID
3	CM_USE_START_DT	Date(10)	DATE	Contact Method Use Start Date
4	CM_ID	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
5	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.
6	CM_USE_END_DT	Date(10)	DATE	End date of a Contact Method Use
7	PRIMARY_IND	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether or not it is Primary N=No Y=Yes
8	CM_NICKNAME	Character(30)	VARCHAR2(30) NOT NULL	Nickname of a Contact Method
9	CM_PURPOSE_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Relationship Contact Method Purpose ID Prompt Table: CM_PURP_TYPE
10	PHYSICAL_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Physical Location (Free-Form)
11	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
12	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.
13	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension.