WINTREE_CF_VW

(SQL View)
 Index Back

Tree by CF no SetID Control


SELECT DISTINCT B.NODE_FIELDNAME ,A.TREE_NAME ,a.effdt ,A.DESCR FROM PSTREEDEFN A ,PSTREESTRCT B WHERE A.TREE_STRCT_ID = B.TREE_STRCT_ID AND SETCNTRL_IND='S' AND A.EFF_STATUS='A' AND A.EFFDT= ( SELECT MAX(EFFDT) FROM PSTREEDEFN WHERE SETID=A.SETID AND TREE_NAME=A.TREE_NAME AND EFFDT < %CurrentDateIn)

  • Related Language Record: TREE_CFNS_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
    2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description