RF_CASESETID_VW(SQL View) |
Index Back |
---|---|
Service Order Case ViewThis is the service order case prompt view based on the service order customer. |
SELECT DISTINCT A.BO_ID_CUST , A.CASE_ID , A.BUSINESS_UNIT , C.CUST_ID , D.BO_NAME_DISPLAY , D.BO_NAME_AC , E.STATUS_CATEGORY FROM PS_RC_CASE A , PS_SET_CNTRL_REC B , PS_BC C , PS_BO_NAME D , PS_RC_STATUS_TBL E WHERE B.RECNAME = 'BC' AND A.BO_ID_CUST = C.BO_ID(+) AND D.BO_ID = A.BO_ID_CUST AND E.RC_STATUS = A.RC_STATUS AND A.RC_VERTICAL= 'SW' AND D.PRIMARY_IND = 'Y' AND E.SETID = ( SELECT F.SETID FROM PS_SET_CNTRL_REC F WHERE F.SETCNTRLVALUE = A.BUSINESS_UNIT AND F.RECNAME = 'RC_STATUS_TBL') |
# | 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(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. | |
3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
4 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
5 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
6 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
7 | 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 |