VC_TREE_PLANLNG

(SQL View)
 Index Back

Variable Comp Tree View

This view is used as a prompt for the Tree Name on the Variable Comp Plan table. It selects only valid trees with effective dates less than or equal to the VC Plan date.

SELECT A.TREE_NAME , A3.LANGUAGE_CD , A3.DESCR FROM PSTREEDEFN A , PSTREEDEFNLANG A3 WHERE A.SETID = ' ' AND A.SETCNTRLVALUE = ' ' AND A.EFF_STATUS = 'A' AND A.VALID_TREE = 'Y' AND A.TREE_STRCT_ID = 'VC_GROUP_STRUCT' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREEDEFN WHERE A.TREE_NAME = TREE_NAME AND A.SETID = SETID AND A.SETCNTRLVALUE = SETCNTRLVALUE) AND A.SETID = A3.SETID AND A.SETCNTRLVALUE = A3.SETCNTRLVALUE AND A.TREE_NAME = A3.TREE_NAME AND A.EFFDT = A3.EFFDT

  • Related Language Record for VC_TREE_PLAN_VW

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