RC_PHONE_VW6(SQL View) |
Index Back |
---|---|
View for PhoneCall Center application view for Phone. |
SELECT C.BO_ID , C.ROLE_TYPE_ID , C.PHONE , D.DESCR FROM PS_BO_SRCH_PHN C , PS_CM_PURP_TYPE D WHERE C.BO_CM_USE_TYPE = 'R' AND C.CM_PURPOSE_TYPE_ID = D.CM_PURPOSE_TYPE_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. | |
2 | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer | |
3 | Character(24) | VARCHAR2(24) NOT NULL | This field stores the Telephone number. | |
4 | RC_PURP_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Short Description |