CASE_IDRC_CASE_VW3(SQL View) |
Index Back |
|---|---|
Case View for ReportsCase View for Reports. Used in Crsytal Reports. |
| SELECT A.CASE_ID , A.BUSINESS_UNIT , A.BO_ID_CUST , A.CASE_CONTACT , A.ASSIGNED_TO , A.CREATION_DATE , B.SETID , A.DEPTID , C.SETID , A.LOCATION , PROFILE_CM_SEQ_PHN , PROFILE_CM_SEQ_EML , PROFILE_CM_SEQ_ADD FROM PS_RC_CASE A , PS_SET_CNTRL_REC B , PS_SET_CNTRL_REC C WHERE B.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.RECNAME = 'DEPT_TBL' AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'LOCATION_TBL' AND A.RC_VERTICAL = 'HD' |
| # | 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 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 4 | CASE_CONTACT | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 5 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |
| 6 | CREATION_DATE | Date(10) | DATE | Creation date of the case. |
| 7 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 8 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL | Department |
| 9 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
| 10 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Location Code. |
| 11 | PROFILE_CM_SEQ_PHN | Number(31,0) | DECIMAL(31) NOT NULL | Used to store the contact method sequence number for a phone number. |
| 12 | PROFILE_CM_SEQ_EML | Number(31,0) | DECIMAL(31) NOT NULL | Used to store the contact method sequence number for a email address. |
| 13 | 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. |