RD_DQ_C_PHN_VW1

(SQL View)
Index Back

Company Phone for srch results

This view is used in Company search result grid. It picks the first phone in the first address book entry.

SELECT A.BO_ID , A.PROFILE_CM_SEQ , A.CM_ID , A.PHONE FROM PS_RD_DQ_C_PHN_VW A , PS_BO_ABE_DTL B WHERE A.BO_ID = B.BO_ID AND A.PROFILE_CM_SEQ = B.PROFILE_CM_SEQ AND B.ABE_SEQ = 1

# 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 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_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID
4 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.