RC_RELBU_VW

(SQL View)
 Index Back

Relationship Business Unit VW

This record joins the case relationship type with the call center business unit.

SELECT %Substring(A.SETCNTRLVALUE,1,5) , B.RELATIONSHIP_TYPE FROM PS_SET_CNTRL_REC A , PS_RC_RELATION_TBL B WHERE A. RECNAME = 'RC_RELATION_TBL' AND A.SETID=B.SETID AND B.GLOBAL_FLAG='Y' AND B.HIERARCHICAL_IND='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RELATIONSHIP_TYPE Character(5) VARCHAR2(5) NOT NULL Case Relationship Type