RC_CASEINFO_VW8(SQL View) |
Index Back |
|---|---|
Call Center View for ReportsCall Center View used in Crystal Reports for HelpDesk Reports |
| SELECT A.BUSINESS_UNIT , A.CASE_ID , A.ASSIGNED_TO , A.CREATION_DATE , A.BO_ID_CUST , A.CASE_CONTACT , A.SETID_DEPT , A.DEPTID , E.EFFDT , E.RC_DEPT_DESCR , A.SETID_LOCATION , A.LOCATION , F.LOCATION_EFFDT , F.RC_LOC_DESCR , A.PROFILE_CM_SEQ_PHN , A.PROFILE_CM_SEQ_EML , A.PROFILE_CM_SEQ_ADD FROM PS_RC_CASE_VW3 A , PS_RC_DEPT_VW E , PS_RC_CASE_VW3 B , PS_RC_LOCATION_VW F WHERE A.CASE_ID = B.CASE_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.DEPTID = E.DEPTID(+) AND A.SETID_DEPT = E.SETID(+) AND B.LOCATION = F.LOCATION(+) AND B.SETID_LOCATION = F.SETID_LOCATION(+) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | 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. |
| 3 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |
| 4 | CREATION_DATE | Date(10) | DATE | Creation date of the case. |
| 5 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 6 | CASE_CONTACT | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 7 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 8 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL | Department |
| 9 | EFFDT_DEPT | Date(10) | DATE | Created for Call Center - Crystal Reports |
| 10 | RC_DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description to be displayed on HelpDesk page. |
| 11 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
| 12 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Location Code. |
| 13 | EFFDT_LOCATION | Date(10) | DATE | Created for Call Center - Crystal Reports |
| 14 | RC_LOC_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Descripton of the Location to be displayed in helpdesk page. |
| 15 | PROFILE_CM_SEQ_PHN | Number(31,0) | DECIMAL(31) NOT NULL | Used to store the contact method sequence number for a phone number. |
| 16 | PROFILE_CM_SEQ_EML | Number(31,0) | DECIMAL(31) NOT NULL | Used to store the contact method sequence number for a email address. |
| 17 | PROFILE_CM_SEQ_ADD | Number(31,0) | DECIMAL(31) NOT NULL | This field is used to store the profile contact method sequence number for an address. |