AUC_TREE_NODE
(SQL Table) |
Index Back |
|---|
Sourcing Tree Node table
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
TREE_ID |
Character(36) |
VARCHAR2(36) NOT NULL |
Tree ID
|
| 3 |
TREE_NODE_ID |
Number(6,0) |
INTEGER NOT NULL |
Node ID
|
| 4 |
PARENT_NODE_ID |
Character(36) |
VARCHAR2(36) NOT NULL |
Node ID
|
| 5 |
AUC_BRANCH_ID |
Character(36) |
VARCHAR2(36) NOT NULL |
Tree branch id
|
| 6 |
BRANCH_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Branch sequence number
|
| 7 |
LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Level
|
| 8 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 9 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 10 |
CLASSPATH1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Class
|