PSTREEDEFN

index back

Tree Definition


  • Related language record: PSTREEDEFNLANG
  • Parent record of DEPT_TLEAF_VW DEPT_TLEVEL_VW PSTREEBRADEL PSTREEBRANCH PSTREELEAF PSTREELEVEL PSTREELEVELSVW PSTREENODE SDK_PSTREENODE
  • PeopleSoft Field Name Field Type Column Type Description
    SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_NOMETA_VW

    SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
    TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    EFFDT Date(10) DATE NOT NULL Effective Date
    EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    TREE_STRCT_ID Character(18) VARCHAR2(18) NOT NULL Tree Structure Name (see PSTREESTRCT).

    Prompt Table: PSTREESTRCT

    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    ALL_VALUES Character(1) VARCHAR2(1) NOT NULL Tree Level All Values flag
    USE_LEVELS Character(1) VARCHAR2(1) NOT NULL Tree Definition Level Use Type
    L=Loosely Enforced
    N=Level Not Used
    S=Strictly Enforced
    VALID_TREE Character(1) VARCHAR2(1) NOT NULL Valid Tree
    N=Draft Tree
    Y=Valid Tree
    LEVEL_COUNT Number(3,0) SMALLINT NOT NULL Level Count
    NODE_COUNT Number(10,0) DECIMAL(10) NOT NULL Tree Definition Node Count
    LEAF_COUNT Number(10,0) DECIMAL(10) NOT NULL Leaf Count
    TREE_HAS_RANGES Character(1) VARCHAR2(1) NOT NULL Tree Has Ranges
    DUPLICATE_LEAF Character(1) VARCHAR2(1) NOT NULL Tree Definition allow duplicate leaf flag
    TREE_CATEGORY Character(18) VARCHAR2(18) NOT NULL Category name for the Tree

    Default: DEFAULT

    TREE_ACC_METHOD Character(1) VARCHAR2(1) NOT NULL Tree 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_SELECTOR Character(1) VARCHAR2(1) NOT NULL Tree Access Selector for nVision: D=Dynamic Selectors, S=Static Selectors
    D=Dynamic Selectors
    S=Static Selector

    Default: S

    TREE_ACC_SEL_OPT Character(1) VARCHAR2(1) NOT NULL Tree Defintion Tree Access Selector Option for nVision
    B=Range of Values (BETWEEN)
    R=Range of Values (>=...<=)
    S=Single Values

    Default: R

    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies 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_IMAGE Character(30) VARCHAR2(30) NOT NULL Field for the image to be used for tree
    BRANCH_IMAGE Character(30) VARCHAR2(30) NOT NULL Branched Tree Image Name
    NODECOL_IMAGE Character(30) VARCHAR2(30) NOT NULL Collapsed Node Image Field
    NODEEXP_IMAGE Character(30) VARCHAR2(30) NOT NULL Expanded Node Image Field
    LEAF_IMAGE Character(30) VARCHAR2(30) NOT NULL Name of image that is used for leaf , i.e. detail values in tree
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19