AUC_MESSAGE_VW1(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 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 |
# | 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 |