RS_ORGTREE_VW

(SQL View)
 Index Back

Tree names


SELECT %Substring(B.SETCNTRLVALUE, 1, 5) , A.TREE_NAME , F.DESCR , A.EFFDT FROM PSTREEDEFN A , %Table(SET_CNTRL_TREE) B , PSTREESTRCT C , %Table(INSTALLATION_RS) D , %Table(SETID_TBL) 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: RS_ORGTREE_VWL

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date