SETIDBUSINESS_UNIT_RCCASE_IDC=Closed
D=Canceled
H=Case is on hold
O=Case is Open
RF_CASE_VW(SQL View) |
Index Back |
|---|---|
Persons Related to Case Cust'sPeople related to a case through Customer. |
| SELECT F.SETID , A.BUSINESS_UNIT , A.CASE_ID , A.BO_ID_CUST , E.SETID , E.CUST_ID , C.BO_NAME_DISPLAY , C.BO_NAME_AC , B.STATUS_CATEGORY FROM PS_RC_CASE A , PS_RC_STATUS_TBL B , PS_BO_NAME C , PS_BC E , PS_SET_CNTRL_TBL F WHERE A.BO_ID_CUST = E.BO_ID(+) AND F.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.BO_ID = A.BO_ID_CUST AND B.RC_STATUS = A.RC_STATUS AND B.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'RC_STATUS_TBL') AND A.RC_VERTICAL = 'SW' AND C.PRIMARY_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | BUSINESS_UNIT_RC |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit field for Case identified in Quality |
| 3 | 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. |
| 4 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 5 | CUST_SETID | Character(5) | VARCHAR2(5) NOT NULL | Customer Setid |
| 6 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 7 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 8 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 9 | STATUS_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Categories for Case Status.
These drive processing.
C=Closed D=Canceled H=Case is on hold O=Case is Open |