RC_SS_SW_HDR_VW(SQL View) |
Index Back |
---|---|
Self Service Support CasesThis view is used to pull all the Cases that are currently open for a customer by using the CUST_ID. |
SELECT O.OPRID , C.BUSINESS_UNIT , C.BO_ID_CUST FROM PS_RC_CASE C , PS_OPR_DEF_TBL_RB O WHERE C.BUSINESS_UNIT = O.BUSINESS_UNIT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
3 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |