CONTACT_IDWORK_PHONEN=No
Y=Yes
RSF_PER_W_PH_VW(SQL View) |
Index Back |
|---|---|
Contact Work Phone VwA view of all Sales Person Work Phone numbers |
| SELECT DISTINCT D.PERSON_ID , A.PHONE , D.BO_ID , A.COUNTRY_CODE , A.EXTENSION , A.PROFILE_CM_SEQ , A.PRIMARY_IND FROM PS_BO_SRCH_PHN A , PS_RD_PERSON D WHERE A.BO_CM_USE_TYPE = 'R' AND A.BO_ID = D.BO_ID AND A.CM_PURPOSE_TYPE_ID = 11 AND A.ROLE_TYPE_ID IN (8, 9) AND A.BO_CM_START_DT = ( SELECT MAX (BO_CM_START_DT) FROM PS_BO_SRCH_PHN WHERE BO_ID = A.BO_ID AND PROFILE_CM_SEQ = A.PROFILE_CM_SEQ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTACT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 2 | WORK_PHONE |
Character(24) | VARCHAR2(24) NOT NULL | Work Phone |
| 3 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 4 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Country Code values. |
| 5 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | This field stores the Phone extension. |
| 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 | PRIMARY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether or not it is Primary
N=No Y=Yes |