BO_PR_PPHON_VW

(SQL View)
 Index Back

Person Rep Primary Phone

This is the Person Rep Primary Phone view.

SELECT DISTINCT B.PERSON_ID , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.CM_TYPE_ID , A.CM_USE_START_DT , A.CM_ID , A.PROFILE_CM_SEQ , A.CM_USE_END_DT , A.CM_NICKNAME , A.CM_PURPOSE_TYPE_ID , A.PHYSICAL_LOCATION , A.COUNTRY_CODE , A.PHONE , A.EXTENSION FROM PS_RD_PERSON B , PS_BO_REP_PPHON_VW A WHERE B.BO_ID = A.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
3 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
4 CM_TYPE_ID Number(6,0) INTEGER NOT NULL Contact Method Type ID
5 CM_USE_START_DT Date(10) DATE Contact Method Use Start Date
6 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID
7 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.
8 CM_USE_END_DT Date(10) DATE End date of a Contact Method Use
9 CM_NICKNAME Character(30) VARCHAR2(30) NOT NULL Nickname of a Contact Method
10 CM_PURPOSE_TYPE_ID Number(6,0) INTEGER NOT NULL Relationship Contact Method Purpose ID

Prompt Table: CM_PURP_TYPE

11 PHYSICAL_LOCATION Character(30) VARCHAR2(30) NOT NULL Physical Location (Free-Form)
12 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.
13 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
14 EXTENSION Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.