FT_TSEL_STR_AET

(SQL Table)
 Index Back

Tree definition state record

This state record contains the tree definitionand tree structure fields. This state record is used in tree selector library (FT_TREESEL) and budget processor translate chartfields (FS_BP_XCFS). **** Do not delete fields from this state record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 TREE_STRCT_ID Character(18) VARCHAR2(18) NOT NULL Tree Structure Name (see PSTREESTRCT).
3 DTL_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Detail Record name
4 DTL_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Detail Record name
5 LEVEL_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Level Record name
6 NODE_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Node Record name
7 NODE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Node Field name
8 EFFDT Date(10) DATE Effective Date

Default Value: %date

9 USE_LEVELS Character(1) VARCHAR2(1) NOT NULL Tree Definition Level Use Type
L=Loosely Enforced
N=Level Not Used
S=Strictly Enforced
10 DUPLICATE_LEAF Character(1) VARCHAR2(1) NOT NULL Tree Definition allow duplicate leaf flag
11 TREE_HAS_RANGES Character(1) VARCHAR2(1) NOT NULL Tree Has Ranges
12 LEAF_COUNT Number(10,0) DECIMAL(10) NOT NULL Leaf Count
13 VERSION_TREE Number(10,0) DECIMAL(10) NOT NULL Tree Version
14 VALID_TREE Character(1) VARCHAR2(1) NOT NULL Valid Tree
N=Draft Tree
Y=Valid Tree
15 ALL_VALUES Character(1) VARCHAR2(1) NOT NULL Tree Level All Values flag
N=No
Y=Yes