RY_CSE_DTL_VW(SQL View) |
Index Back |
|---|---|
Case DetailsThis view is used for Joining Support/Helpdesk Details |
| SELECT C.CASE_ID , C.BUSINESS_UNIT , C.DISP_TMPL_FAM_CD , C.BO_ID_CUST , O.BO_NAME , C.ROLE_TYPE_ID_CUST , C.BO_ID_CONTACT , I.NAME , ROLE_TYPE_ID_CNTCT , C.REGION_ID , C.LOCATION , C.DEPTID , RC_PRIORITY , ASSIGNED_TO , W.NAME FROM PS_RC_CASE C LEFT OUTER JOIN PS_RC_CNTCT_PHD_VW W ON (C.ASSIGNED_TO=W.CASE_CONTACT) ,PS_BO_BASIC_ORG O ,PS_BO_BASIC_IND I WHERE C.DISP_TMPL_FAM_CD IN ('RC_SUPPORT','RC_HELPDESK') AND C.ROLE_TYPE_ID_CUST IN(2,4,8,9) AND C.BO_ID_CUST=O.BO_ID AND C.BO_ID_CUST=I.BO_ID_COMPANY AND C.BO_ID_CONTACT=I.BO_ID |
| # | 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | DISP_TMPL_FAM_CD | Character(30) | VARCHAR2(30) NOT NULL | Display Template Family Code |
| 4 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 5 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 6 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 7 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 8 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 9 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 10 | REGION_ID | Character(15) | VARCHAR2(15) NOT NULL | This field stores the region id value. |
| 11 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Location Code. |
| 12 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL | Department |
| 13 | RC_PRIORITY | Character(5) | VARCHAR2(5) NOT NULL | Case Priority |
| 14 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |
| 15 | NAME_ASSIGNED_TO | Character(80) | VARCHAR2(80) NOT NULL | The name of the assigned agent. |