RS_ORGTREE_VWL

(SQL View)
 Index Back

Tree names - Related Language


SELECT %Substring(B.SETCNTRLVALUE, 1, 5) , A.TREE_NAME , F.LANGUAGE_CD , F.DESCR FROM PSTREEDEFN A , %Table(SET_CNTRL_TREE) B , PSTREESTRCT C , %Table(INSTALLATION_RS) D , %Table(SETID_LANG) F WHERE A.SETID = B.SETID AND A.TREE_NAME = B.TREE_NAME AND A.TREE_STRCT_ID = C.TREE_STRCT_ID AND (C.NODE_RECNAME = D.ORG_RECNAME OR C.DTL_RECNAME = D.ORG_RECNAME) AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREEDEFN E WHERE E.SETID = A.SETID AND E.TREE_NAME = A.TREE_NAME AND E.SETCNTRLVALUE = A.SETCNTRLVALUE AND E.EFFDT <= %CurrentDateIn AND E.EFF_STATUS = 'A') AND A.SETID = F.SETID

  • Related Language Record for RS_ORGTREE_STF RS_ORGTREE_VW RS_ORGTREE_WM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description