RC_REL_HIER_VW

(SQL View)
 Index Back

Hierarchical Relationship Type

Prompt that shows only hierarchical relationship types.

SELECT setid , relationship_type , parent_lbl , child_lbl , equivalent_lbl , hierarchical_ind , rc_short_descr , long_desc FROM PS_RC_RELATION_TBL WHERE hierarchical_ind = 'Y'

  • Related Language Record: RC_RELATION_LNG

    • # 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.