PT_TREEDEFN_VW

index back

Tree Definition & Attributes


SELECT %Substring(setid,1,5) , tree_name , effdt , eff_status , tree_strct_id , descr , all_values , use_levels , valid_tree FROM pstreedefn

  • Related language record: PT_TREEDFV_LANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    TREE_NAME_SETIDCharacter(5)VARCHAR2(5) NOT NULLTableSet
    TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Name
    EFFDTDate(10)DATEEffective Date

    Default: %date

    EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
    A=Active
    I=Inactive
    TREE_STRCT_IDCharacter(18)VARCHAR2(18) NOT NULLTree Structure Name (see PSTREESTRCT).
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    ALL_VALUESCharacter(1)VARCHAR2(1) NOT NULLTree Level All Values flag

    Y/N Table Edit

    Default: Y

    USE_LEVELSCharacter(1)VARCHAR2(1) NOT NULLTree Definition Level Use Type
    L=Loosely Enforced
    N=Level Not Used
    S=Strictly Enforced

    Default: S

    VALID_TREECharacter(1)VARCHAR2(1) NOT NULLValid Tree
    N=Draft Tree
    Y=Valid Tree

    Y/N Table Edit

    Default: N

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19