SETIDSETCNTRLVALUETREE_NAMEEFFDTDefault Value: %date
TREE_NODE_NUMTREE_NODETREE_BRANCHN=No
Y=Yes
Default Value: N
Default Value: N
FT_DPTTREE_NODE(SQL Table) |
Index Back |
|---|---|
Dept Tree NodeDepartment Tree Node for Fusion Coex |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | TREE_NODE_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 6 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 7 | TREE_BRANCH |
Character(20) | VARCHAR2(20) NOT NULL | Tree Branch |
| 8 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 9 | PARENT_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Parent Node Number |
| 10 | PARENT_NODE_NAME | Character(20) | VARCHAR2(20) NOT NULL | Name of parent node |
| 11 | FT_TREE_STRUCT_CD | Character(30) | VARCHAR2(30) NOT NULL | Tree Structure Code |
| 12 | FT_TREE_CODE | Character(30) | VARCHAR2(30) NOT NULL | Tree Code |
| 13 | FT_SET_ID_GUID | Character(36) | VARCHAR2(36) NOT NULL | Set ID GUID |
| 14 | FT_TREE_VER_GUID | Character(36) | VARCHAR2(36) NOT NULL | Tree Version GUID |
| 15 | FT_TREE_VER_NAME | Character(80) | VARCHAR2(80) NOT NULL | Tree Version Name |
| 16 | FT_TREE_NODE_GUID | Character(36) | VARCHAR2(36) NOT NULL | Tree Node ID GUID |
| 17 | FT_PARENTNODE_GUID | Character(36) | VARCHAR2(36) NOT NULL | Parent Tree Node ID GUID |
| 18 | FT_DATA_SOURCE_ID | Character(32) | VARCHAR2(32) NOT NULL | Data Source ID |
| 19 | FT_PK1_START_VALUE | Character(100) | VARCHAR2(100) NOT NULL | PK1 Start Value |
| 20 | FT_PK2_START_VALUE | Character(100) | VARCHAR2(100) NOT NULL | PK2 Start Value |
| 21 | FT_PK3_START_VALUE | Character(100) | VARCHAR2(100) NOT NULL | PK3 Start Value |
| 22 | FT_PK4_START_VALUE | Character(100) | VARCHAR2(100) NOT NULL | PK4 Start Value |
| 23 | FT_PK5_START_VALUE | Character(100) | VARCHAR2(100) NOT NULL | PK5 Start Value |
| 24 | FT_PK1_END_VALUE | Character(100) | VARCHAR2(100) NOT NULL | PK1 End Value |
| 25 | FT_PK2_END_VALUE | Character(100) | VARCHAR2(100) NOT NULL | PK2 End Value |
| 26 | FT_PK3_END_VALUE | Character(100) | VARCHAR2(100) NOT NULL | PK3 End Value |
| 27 | FT_PK4_END_VALUE | Character(100) | VARCHAR2(100) NOT NULL | PK4 End Value |
| 28 | FT_PK5_END_VALUE | Character(100) | VARCHAR2(100) NOT NULL | PK5 End Value |
| 29 | FT_REF_TREE_CODE | Character(30) | VARCHAR2(30) NOT NULL | Reference Tree Code |
| 30 | FT_REF_TREE_VER_ID | Character(32) | VARCHAR2(32) NOT NULL | Reference Tree Version ID |
| 31 | FT_TREE_LABEL_ID | Character(32) | VARCHAR2(32) NOT NULL | Tree Label ID |
| 32 | FT_PARENT_SRC_ID | Character(32) | VARCHAR2(32) NOT NULL | Parent Data Source ID GUID |
| 33 | FT_PARENT_PK1_VAL | Character(100) | VARCHAR2(100) NOT NULL | Parent PK1 Value |
| 34 | FT_PARENT_PK2_VAL | Character(100) | VARCHAR2(100) NOT NULL | Parent PK2 Value |
| 35 | FT_PARENT_PK3_VAL | Character(100) | VARCHAR2(100) NOT NULL | Parent PK3 Value |
| 36 | FT_PARENT_PK4_VAL | Character(100) | VARCHAR2(100) NOT NULL | Parent PK4 Value |
| 37 | FT_PARENT_PK5_VAL | Character(100) | VARCHAR2(100) NOT NULL | Parent PK5 Value |
| 38 | FT_PARENT_LBL_ID | Character(32) | VARCHAR2(32) NOT NULL | Parent Tree Label ID |
| 39 | FT_SORT_ORDER | Number(18,0) | DECIMAL(18) NOT NULL | Sort Order |
| 40 | FT_DEPTH | Number(18,0) | DECIMAL(18) NOT NULL | Depth |
| 41 | FT_CHILD_COUNT | Number(18,0) | DECIMAL(18) NOT NULL | Child Count |
| 42 | FT_DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department Id for Fusion Coex |
| 43 | FT_DEPT_DESCR | Character(240) | VARCHAR2(240) NOT NULL | Department Description for Fusion Coex |
| 44 | FT_PARENT_DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Parent Department - Fusion Coex |
| 45 | FT_PAR_DEPT_DESCR | Character(240) | VARCHAR2(240) NOT NULL | Parent Department Description |
| 46 | FT_CREATED_BY | Character(64) | VARCHAR2(64) NOT NULL | Created By |
| 47 | FT_CREATION_DATE | Date(10) | DATE | Creation Date |
| 48 | FT_LAST_UPDATED_BY | Character(64) | VARCHAR2(64) NOT NULL | Last Updated By |
| 49 | FT_LAST_UPD_DATE | Date(10) | DATE | Last Updated Date |
| 50 | FT_LAST_UPD_LOGIN | Character(32) | VARCHAR2(32) NOT NULL | Last Updated Login |
| 51 | FT_LANGUAGE | Character(4) | VARCHAR2(4) NOT NULL | Language |
| 52 | FT_PROC_MARKER | Character(36) | VARCHAR2(36) NOT NULL | Process marker field |
| 53 | FT_ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Error Flag
N=No Y=Yes Default Value: N |
| 54 | FT_BYPASS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Bypass Flag
Default Value: N |
| 55 | FT_ALTERNATE_REC | Character(50) | VARCHAR2(50) NOT NULL | Source Record |
| 56 | FT_ALTERNATE_KEY | Character(254) | VARCHAR2(254) NOT NULL | Alternate Key |