REL_BU_SHOWNREL_CASE_SHOWNPrompt Table:
RC_STATUS_TBL
Set Control Field: BUSINESS_UNIT
RC_REL_DETL_VW(SQL View) |
Index Back |
|---|---|
Case Relationship DetailThis view is used to show the case details on the case relationships page |
| SELECT A.BUSINESS_UNIT , A.CASE_ID , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.RC_STATUS , A.RB_ANONYMOUS_FLAG FROM PS_RC_CASE A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REL_BU_SHOWN |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REL_CASE_SHOWN |
Number(15,0) | DECIMAL(15) NOT NULL | Related case shown on case relationship page |
| 3 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 4 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 5 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 6 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 7 | RC_STATUS | Character(5) | VARCHAR2(5) NOT NULL |
Case Status
Prompt Table:
RC_STATUS_TBL
|
| 8 | RB_ANONYMOUS_FLAG | Character(1) | VARCHAR2(1) NOT NULL | RB_ANONYMOUS_FLAG |