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 |