SDB_CASE_MVW

(SQL View)
Index Back

Case view for Dashboard

Case view for Customer Data Hub Integration impact on Dashboard

SELECT CASE_ID , BO_ID_CUST , BO_ID_CONTACT FROM PS_RC_CASE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
2 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
3 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.