PSTREEDEFQRYPVW

Return to Index

Used in the Query Manager

PlatformView Text
DefaultSELECT A.SETID ,A.SETCNTRLVALUE ,A.TREE_NAME ,A.EFFDT ,A.TREE_STRCT_ID ,A.VALID_TREE ,A.DESCR FROM PSTREEDEFN A WHERE A.TREE_STRCT_ID <> 'ACCESS_GROUP'

  • Related language record: PSTREEDEFNLANG
  • PeopleSoft Field NameDescription
    SETIDSetID

    Prompt Table: SETID_NOMETA_VW

    SETCNTRLVALUETree Definition User Key Value
    TREE_NAMETree Name
    EFFDTEffective Date

    Default: %date

    TREE_STRCT_IDTree Structure Name

    Prompt Table: PSTREESTRCT

    VALID_TREEValid Tree
    N=Saved As Draft
    Y=Saved As Valid Tree
    DESCRDescription

    Author: PeopleTools

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 24 July 2010