TFLT_UTIL_AET

(SQL Table)
Index Back

Tree Flattener Utilitiy AET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AS_OF_DATE Date(10) DATE As of Date
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
5 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
6 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

Prompt Table: %EDITTABLE

7 TREE_EFFDT Date(10) DATE Effective date of the Tree

Prompt Table: %EDITTABLE2

8 OTBI_SRC_INSTANCE Number(15,4) DECIMAL(14,4) NOT NULL OTBI Process Instance
9 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
10 ROWCOUNT1 Number(12,0) DECIMAL(12) NOT NULL Row Count
11 ROWCOUNT2 Number(12,0) DECIMAL(12) NOT NULL Row Count
12 VERSION_TREE Number(10,0) DECIMAL(10) NOT NULL Tree Version