RC_REL_LNG

(SQL View)
 Index Back

Relationship Labels

View to get all the relationship labels for non english languages, used in config search.

SELECT DISTINCT A.SETID , %Upper(A.PARENT_LBL) ,B.LANGUAGE_CD , B.PARENT_LBL FROM PS_RC_RELATION_TBL A , PS_RC_RELATION_LNG B WHERE A.SETID = B.SETID AND A.RELATIONSHIP_TYPE = B.RELATIONSHIP_TYPE AND A.PARENT_LBL <> ' ' UNION SELECT DISTINCT C.SETID , %Upper(C.child_LBL) ,D.LANGUAGE_CD ,D.child_LBL FROM PS_RC_RELATION_TBL C , PS_RC_RELATION_LNG D WHERE C.SETID = D.SETID AND C.RELATIONSHIP_TYPE = D.RELATIONSHIP_TYPE AND C.child_LBL <> ' ' UNION SELECT DISTINCT E.SETID , %Upper(E.equivalent_LBL) ,F.LANGUAGE_CD ,F.equivalent_LBL FROM PS_RC_RELATION_TBL E , PS_RC_RELATION_LNG F WHERE E.SETID = F.SETID AND E.RELATIONSHIP_TYPE = F.RELATIONSHIP_TYPE AND E.equivalent_LBL <> ' '

  • Related Language Record for RC_REL_LBL

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LABEL_NAME Character(30) VARCHAR2(30) NOT NULL Label Name