RC_CASEINFO_VW7(SQL View) |
Index Back |
|---|---|
Call Center View for ReportsCall Center View used in Crystal Reports |
| SELECT A.BUSINESS_UNIT , A.CASE_ID , E.NAME , E.ASSIGNED_TO , E.RC_LAST_NAME , E.RC_FIRST_NAME , A.SETID_DEPT , A.DEPTID , F.RC_DEPT_DESCR , F.EFFDT FROM PS_RC_CASE_VW1 A , PS_RC_ASSIGN_VW E , PS_RC_DEPT_VW F WHERE A.ASSIGNED_TO = E.ASSIGNED_TO (+) AND A.DEPTID = F.DEPTID (+) AND A.SETID_DEPT = F.SETID (+) |
| # | 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 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |
| 5 | RC_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | RC_LAST_NAME |
| 6 | RC_FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 8 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL | Department |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | EFFDT | Date(10) | DATE | Effective Date |