BO_ROLECM_PPHON

(SQL View)
 Index Back

Role Primary Phones

Show only the Primary Role Phones for a Business Object.

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 , D.CM_CONCAT , D.CM_CONCAT_UPPER , %subrec(CM_PHON_PGR_SBR, D) FROM PS_BO_ROLE A , PS_BO_CM_USE B , PS_BO_CM C , PS_CM D WHERE A.BO_ID = B.BO_ID AND A.ROLE_TYPE_ID = B.ROLE_TYPE_ID AND B.BO_CM_USE_TYPE = 'R' AND B.BO_ID = C.BO_ID AND B.PROFILE_CM_SEQ = C.PROFILE_CM_SEQ AND B.PRIMARY_IND = 'Y' AND C.CM_ID = D.CM_ID AND D.CM_TYPE_ID = 2 AND C.CM_TYPE_ID = 2

# 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
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)
16 CM_CONCAT Character(100) VARCHAR2(100) NOT NULL Concatenated Contact Method
17 CM_CONCAT_UPPER Character(100) VARCHAR2(100) NOT NULL Uppper Concatenated Contact Method
18 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.
19 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
20 EXTENSION Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.
21 PASSWORD Character(254) VARCHAR2(254) NOT NULL Password