SDK_SETIDSDK_TREE_NAMESDK_EFFDTSDK_TREE_NODE_NUMSDK_TREE_NODESDK_PSTREENODE(SQL Table) |
Index Back |
|---|---|
SDK Tree NodeSDK Tree Node |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SDK_SETID |
Character(5) | VARCHAR2(5) NOT NULL | SDK Set ID |
| 2 | SDK_TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | SDK Tree Name |
| 3 | SDK_EFFDT |
Date(10) | DATE NOT NULL | SDK Effective Date |
| 4 | SDK_TREE_NODE_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | SDK Tree Node Number - Internal beginning node range number |
| 5 | SDK_TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL | SDK Tree Node Name |
| 6 | SDK_TREE_NODE_END | Number(10,0) | DECIMAL(10) NOT NULL | SDK Tree Node Number End - Internal ending node range number |