SETIDAUC_FORUM_NAMETREE_IDTREE_NODE_IDP=Pseudoname
U=Userid
AUC_MESSAGE_VW(SQL View) |
Index Back |
|---|
| SELECT A.SETID , B.AUC_FORUM_NAME , B.TREE_ID , C.TREE_NODE_ID , B.BUSINESS_UNIT , B.AUC_ID , B.AUC_ROUND , B.AUC_VERSION , C.AUC_AUTHOR_ID , C.DTTM_CREATED , C.AUC_MSG_SUBJECT , C.AUC_DISP_NAME_TYPE FROM PS_AUC_TREE A , PS_AUC_FORUM_TREE B , PS_AUC_MESSAGES C , PS_AUC_HDR D WHERE A.SETID = B.SETID AND A.TREE_ID = B.TREE_ID AND A.SETID = C.SETID AND A.TREE_ID = C.TREE_ID AND %NumToChar(C.TREE_NODE_ID) = A.ROOT_NODE_ID AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.AUC_ID = D.AUC_ID AND B.AUC_ROUND = D.AUC_ROUND AND B.AUC_VERSION = D.AUC_VERSION AND D.AUC_STATUS NOT IN ('C', 'O', 'X', 'S') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | AUC_FORUM_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Forum Name |
| 3 | TREE_ID |
Character(36) | VARCHAR2(36) NOT NULL | Tree ID |
| 4 | TREE_NODE_ID |
Number(6,0) | INTEGER NOT NULL | Node ID |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | AUC_ID | Character(10) | VARCHAR2(10) NOT NULL | Event ID |
| 7 | AUC_ROUND | Number(5,0) | INTEGER NOT NULL | Event Round |
| 8 | AUC_VERSION | Number(5,0) | INTEGER NOT NULL | Event Version |
| 9 | AUC_AUTHOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Author ID |
| 10 | DTTM_CREATED | DateTime(26) | TIMESTAMP | Datetime Created |
| 11 | AUC_MSG_SUBJECT | Character(100) | VARCHAR2(100) NOT NULL | Subject |
| 12 | AUC_DISP_NAME_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Display Name
P=Pseudoname U=Userid |