VC_TREE_DEF2_VW

(SQL View)
 Index Back

Group Tree View

Variable Comp: this view returns tree defined for variable comp.

SELECT A3.TREE_NAME, A3.DESCR FROM 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 A3.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREEDEFN WHERE A3.TREE_NAME = TREE_NAME AND A3.SETID = SETID AND A3.SETCNTRLVALUE = SETCNTRLVALUE AND EFFDT <= %CurrentDateIn)

  • Related Language Record: VC_TREE_DEF2LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description