AUC_FORUMMSG_VW(SQL View) |
Index Back |
|---|
| SELECT A.SETID ,A.TREE_ID ,A.TREE_NODE_ID ,B.AUC_FORUM_NAME FROM PS_AUC_MESSAGES A , PS_AUC_FORUM_TREE B WHERE A.SETID = B.SETID (+) AND A.TREE_ID = B.TREE_ID (+) |
| # | 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 | AUC_FORUM_NAME | Character(50) | VARCHAR2(50) NOT NULL | Forum Name |