RC_REL_LBL

(SQL View)
 Index Back

Relationship Labels

View to get all the relationship labels, used in config search.

SELECT DISTINCT SETID , %Upper(PARENT_LBL) , PARENT_LBL FROM PS_RC_RELATION_TBL WHERE PARENT_LBL <> ' ' UNION SELECT DISTINCT SETID , %Upper(child_LBL) ,child_LBL FROM PS_RC_RELATION_TBL WHERE child_LBL <> ' ' UNION SELECT DISTINCT SETID , %Upper(equivalent_LBL) ,equivalent_LBL FROM PS_RC_RELATION_TBL WHERE equivalent_LBL <> ' '

  • Related Language Record: RC_REL_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.
    2 LABELFIELDNAME Character(18) VARCHAR2(18) NOT NULL Dynamic Label Fieldname
    3 LABEL_NAME Character(30) VARCHAR2(30) NOT NULL Label Name