FT_TSEL_FLT_AET

(SQL Table)
Index Back

Tree Selector - Flatten Tree

This state record stores the flatten tree data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
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 TREE_EFFDT Date(10) DATE Effective date of the Tree
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 SETID_TREE Character(5) VARCHAR2(5) NOT NULL SetID
7 USE_TSEL_FTREE Character(1) VARCHAR2(1) NOT NULL Use Tree Selector to Flatten Tree
8 USE_FLT_TREE Character(1) VARCHAR2(1) NOT NULL Use Flatten Tree Switch