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 NameField TypeColumn TypeDescription
    SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID

    Prompt Table: SETID_NOMETA_VW

    SETCNTRLVALUECharacter(20)VARCHAR2(20) NOT NULLTree Definition User Key Value
    TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Name
    EFFDTDate(10)DATE NOT NULLEffective Date
    EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
    A=Active
    I=Inactive
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    TREE_STRCT_IDCharacter(18)VARCHAR2(18) NOT NULLTree Structure Name (see PSTREESTRCT).

    Prompt Table: PSTREESTRCT

    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    ALL_VALUESCharacter(1)VARCHAR2(1) NOT NULLTree Level All Values flag
    USE_LEVELSCharacter(1)VARCHAR2(1) NOT NULLTree Definition Level Use Type
    L=Loosely Enforced
    N=Level Not Used
    S=Strictly Enforced
    VALID_TREECharacter(1)VARCHAR2(1) NOT NULLValid Tree
    N=Draft Tree
    Y=Valid Tree
    LEVEL_COUNTNumber(3,0)SMALLINT NOT NULLLevel Count
    NODE_COUNTNumber(10,0)DECIMAL(10) NOT NULLTree Definition Node Count
    LEAF_COUNTNumber(10,0)DECIMAL(10) NOT NULLLeaf Count
    TREE_HAS_RANGESCharacter(1)VARCHAR2(1) NOT NULLTree Has Ranges
    DUPLICATE_LEAFCharacter(1)VARCHAR2(1) NOT NULLTree Definition allow duplicate leaf flag
    TREE_CATEGORYCharacter(18)VARCHAR2(18) NOT NULLCategory name for the Tree

    Default: DEFAULT

    TREE_ACC_METHODCharacter(1)VARCHAR2(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_SELECTORCharacter(1)VARCHAR2(1) NOT NULLTree Access Selector for nVision: D=Dynamic Selectors, S=Static Selectors
    D=Dynamic Selectors
    S=Static Selector

    Default: S

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

    Default: R

    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(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_IMAGECharacter(30)VARCHAR2(30) NOT NULLField for the image to be used for tree
    BRANCH_IMAGECharacter(30)VARCHAR2(30) NOT NULLBranched Tree Image Name
    NODECOL_IMAGECharacter(30)VARCHAR2(30) NOT NULLCollapsed Node Image Field
    NODEEXP_IMAGECharacter(30)VARCHAR2(30) NOT NULLExpanded Node Image Field
    LEAF_IMAGECharacter(30)VARCHAR2(30) NOT NULLName of image that is used for leaf , i.e. detail values in tree
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19