CASE_IDRELATED_CASE_IDN=No
Y=Yes
SDB_REL_CASE_VW(SQL View) |
Index Back |
|---|---|
Related Cases ViewUsed to load Related Cases Information to contact center dashboard. |
| SELECT A.CASE_ID , A.RELATED_CASE_ID , A.RELATIONSHIP_TYPE , A.BUSINESS_UNIT , B.RC_SHORT_DESCR , LONG_DESC , B.HIERARCHICAL_IND FROM PS_RC_RELATIONSHIP A , PS_RC_RELATION_TBL B WHERE B.SETID IN ( SELECT R.SETID FROM PS_SET_CNTRL_REC R WHERE R.SETCNTRLVALUE = A.BUSINESS_UNIT AND R.RECNAME = 'RC_RELATION_TBL') AND A.RELATIONSHIP_TYPE = B.RELATIONSHIP_TYPE |
| # | 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 | RELATED_CASE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Case Number |
| 3 | RELATIONSHIP_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Case Relationship Type |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | RC_SHORT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Short Description. Used on may CallCenter set-up tables |
| 6 | LONG_DESC | Character(50) | VARCHAR2(50) NOT NULL | Long Description field. |
| 7 | HIERARCHICAL_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if the relationsip is equivalent or hierarchial.
N=No Y=Yes |