RC_RELATION_VW

(SQL View)
 Index Back

Case Relationship View

Relationship view used in Case Relationship existing relationship grid. This view controls the list of cases that you see.

SELECT A.BUSINESS_UNIT , A.CASE_ID , C.RELATIONSHIP_TYPE , C.BUSINESS_UNIT , C.CASE_ID , C.RELATED_BU , C.RELATED_CASE_ID , C.ROW_ADDED_DTTM FROM PS_RC_CASE A , PS_RC_RELATIONSHIP C WHERE ((A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.CASE_ID = C.CASE_ID) OR (A.BUSINESS_UNIT = C.RELATED_BU AND A.CASE_ID = C.RELATED_CASE_ID))

# 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 RELATIONSHIP_TYPE Character(5) VARCHAR2(5) NOT NULL Case Relationship Type

Prompt Table: RC_RELATION_TBL
Set Control Field: BUSINESS_UNIT

4 RELATED_BU_PARENT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 REL_CASE_PARENT Number(15,0) DECIMAL(15) NOT NULL Case Number
6 RELATED_BU Character(5) VARCHAR2(5) NOT NULL Business Unit
7 RELATED_CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case Number
8 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.