PSTREEDEFN

Return to Index

  • Related language record: PSTREEDEFNLANG
  • Parent record of PSTREEBRADEL PSTREEBRANCH PSTREELEAF PSTREELEVEL PSTREELEVELSVW PSTREENODE SDK_PSTREENODE
  • PeopleSoft Field NameField TypeDescription
    SETIDVARCHAR2(5) NOT NULLSetID

    Prompt Table: SETID_NOMETA_VW

    SETCNTRLVALUEVARCHAR2(20) NOT NULLTree Definition User Key Value
    TREE_NAMEVARCHAR2(18) NOT NULLTree Name
    EFFDTDATE NOT NULLEffective Date
    EFF_STATUSVARCHAR2(1) NOT NULLEffective Status
    A=Active
    I=Inactive
    VERSIONDECIMAL(10) NOT NULLVersion
    TREE_STRCT_IDVARCHAR2(18) NOT NULLTree Structure Name

    Prompt Table: PSTREESTRCT

    DESCRVARCHAR2(30) NOT NULLDescription
    ALL_VALUESVARCHAR2(1) NOT NULLTree Level All Values flag
    USE_LEVELSVARCHAR2(1) NOT NULLTree Definition Level Use Type
    L=Loosely Enforced
    N=Level Not Used
    S=Strictly Enforced
    VALID_TREEVARCHAR2(1) NOT NULLValid Tree
    N=Saved As Draft
    Y=Saved As Valid Tree
    LEVEL_COUNTSMALLINT NOT NULLLevel Count
    NODE_COUNTDECIMAL(10) NOT NULLTree Definition Node Count
    LEAF_COUNTDECIMAL(10) NOT NULLLeaf Count
    TREE_HAS_RANGESVARCHAR2(1) NOT NULLTree Has Ranges
    DUPLICATE_LEAFVARCHAR2(1) NOT NULLTree Definition allow duplicate leaf flag
    TREE_CATEGORYVARCHAR2(18) NOT NULLCategory name for the Tree

    Default: DEFAULT

    TREE_ACC_METHODVARCHAR2(1) NOT NULLTree Access Method for nVision: S=Sub-select, J=Join to Selector, L=Use Literal Values (Suppress Joins)
    D=Use Application Defaults
    J=Join to Tree Selector
    L=Use Literal Values
    S=Sub-SELECT Tree Selector

    Default: S

    TREE_ACC_SELECTORVARCHAR2(1) NOT NULLTree Access Selector for nVision: D=Dynamic Selectors, S=Static Selectors
    D=Dynamic Selectors
    S=Static Selector

    Default: S

    TREE_ACC_SEL_OPTVARCHAR2(1) NOT NULLTree Defintion Tree Access Selector Option for nVision
    B=Range of Values (BETWEEN)
    R=Range of Values (>=...<=)
    S=Single Values

    Default: R

    LASTUPDDTTMDATESpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    LASTUPDOPRIDVARCHAR2(30) NOT NULLSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    TREE_IMAGEVARCHAR2(30) NOT NULLField for the image to be used for tree
    BRANCH_IMAGEVARCHAR2(30) NOT NULLBranched Tree Image Name
    NODECOL_IMAGEVARCHAR2(30) NOT NULLCollapsed Node Image Field
    NODEEXP_IMAGEVARCHAR2(30) NOT NULLExpanded Node Image Field
    LEAF_IMAGEVARCHAR2(30) NOT NULLName of image that is used for leaf , i.e. detail values in tree

    Author: PeopleTools 8.52

    Return to Index

    © David Kurtz  Last updated 01 August 2015