RC_RELASRCH_VW

(SQL View)
 Index Back

Case Relationship Type Def.

Case Relationship Type Definition Search View

SELECT SETID , RELATIONSHIP_TYPE , PARENT_LBL , CHILD_LBL , EQUIVALENT_LBL , HIERARCHICAL_IND , RC_SHORT_DESCR , LONG_DESC , GLOBAL_FLAG , CHILD_FLAG FROM PS_RC_RELATION_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

Default Value: OPR_DEF_TBL_RB.SETID

Prompt Table: SP_SETID_NONVW

2 RELATIONSHIP_TYPE Character(5) VARCHAR2(5) NOT NULL Case Relationship Type
3 PARENT_LBL Character(15) VARCHAR2(15) NOT NULL Label for the Parent in a Case Relationship
4 CHILD_LBL Character(15) VARCHAR2(15) NOT NULL Label for the Child in a Case Relationship
5 EQUIVALENT_LBL Character(15) VARCHAR2(15) NOT NULL Label for the Equivalent case in a Case Relationship
6 HIERARCHICAL_IND Character(1) VARCHAR2(1) NOT NULL Indicates if the relationsip is equivalent or hierarchial.
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

7 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables
8 LONG_DESC Character(50) VARCHAR2(50) NOT NULL Long Description field.
9 GLOBAL_FLAG Character(1) VARCHAR2(1) NOT NULL Global Case flag for relationship

Default Value: N

10 CHILD_FLAG Character(1) VARCHAR2(1) NOT NULL Enable Child Status flag for Case Rlationship

Y/N Table Edit

Default Value: N