VC_TOP_GROUP_VW

(SQL View)
 Index Back

Group Tree View

Variable Comp: this view returns the root group of a given tree.

SELECT A.TREE_NAME , A.EFFDT , A3.DESCR , %Substring(A.TREE_NODE,1,15) FROM PSTREENODE A , PSTREEDEFN A3 WHERE A3.SETID = ' ' AND A3.SETCNTRLVALUE = ' ' AND A3.EFF_STATUS = 'A' AND A3.VALID_TREE = 'Y' AND A3.TREE_STRCT_ID = 'VC_GROUP_STRUCT' AND A.TREE_NAME = A3.TREE_NAME AND A.EFFDT = A3.EFFDT AND A.SETID = A3.SETID AND A.SETCNTRLVALUE = A3.SETCNTRLVALUE AND A.TREE_BRANCH = ' ' AND A.PARENT_NODE_NUM = 0

  • Related Language Record: VC_TOP_GROUPLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    2 TREE_EFFDT Date(10) DATE NOT NULL Effective date of the Tree
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.