BO_REP_PPHON_VW

(SQL View)
 Index Back

Representative Phone

This is the Representative Phone view.

SELECT A.BO_ID , A.ROLE_TYPE_ID , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.CM_USE_START_DT , A.PROFILE_CM_SEQ , A.CM_USE_END_DT , A.CM_TYPE_ID , A.CM_ID , A.PRIMARY_IND , A.CM_NICKNAME , A.CM_PURPOSE_TYPE_ID , A.PHYSICAL_LOCATION , %subrec(CM_PHON_PGR_SBR, B) FROM PS_BO_CNTCT_CM_VW A , PS_CM B WHERE A.CM_ID = B.CM_ID AND B.CM_TYPE_ID = 2 AND A.PRIMARY_IND = 'Y'

# 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 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
4 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
5 CM_USE_START_DT Date(10) DATE Contact Method Use Start Date
6 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.
7 CM_USE_END_DT Date(10) DATE End date of a Contact Method Use
8 CM_TYPE_ID Number(6,0) INTEGER NOT NULL Contact Method Type ID
9 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID
10 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
N=No
Y=Yes
11 CM_NICKNAME Character(30) VARCHAR2(30) NOT NULL Nickname of a Contact Method
12 CM_PURPOSE_TYPE_ID Number(6,0) INTEGER NOT NULL Relationship Contact Method Purpose ID

Prompt Table: CM_PURP_TYPE

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