PSTREEDEFN

(SQL Table)
 Index Back

Tree Definition

  • Related Language Record: PSTREEDEFNLANG

  • Parent Record Of DEPT_TBRANCH_VW DEPT_TNODE_VW PSTREEBRADEL PSTREEBRANCH PSTREELEAF PSTREELEVEL PSTREELEVELSVW PSTREENODE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_NOMETA_VW

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

    Prompt Table: PSTREESTRCT

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

    Default Value: DEFAULT

    18 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 Value: S

    19 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 Value: S

    20 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 Value: R

    21 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.
    22 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.
    23 TREE_IMAGE Character(30) VARCHAR2(30) NOT NULL Field for the image to be used for tree
    24 BRANCH_IMAGE Character(30) VARCHAR2(30) NOT NULL Branched Tree Image Name
    25 NODECOL_IMAGE Character(30) VARCHAR2(30) NOT NULL Collapsed Node Image Field
    26 NODEEXP_IMAGE Character(30) VARCHAR2(30) NOT NULL Expanded Node Image Field
    27 LEAF_IMAGE Character(30) VARCHAR2(30) NOT NULL Name of image that is used for leaf , i.e. detail values in tree