SETIDAUC_FORUM_NAMETREE_IDTREE_NODE_IDP=Pseudoname
U=Userid
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
AUC_EVENTMSG_VW(SQL View) |
Index Back |
|---|
| SELECT A.SETID ,A.AUC_FORUM_NAME ,A.TREE_ID ,A.BUSINESS_UNIT ,A.AUC_ID ,A.AUC_ROUND ,A.AUC_VERSION ,A.TREE_NODE_ID ,A.AUC_AUTHOR_ID ,A.DTTM_CREATED ,A.AUC_MSG_SUBJECT ,A.AUC_DISP_NAME_TYPE ,B.BIDDER_SETID ,B.BIDDER_ID ,B.BIDDER_TYPE FROM PS_AUC_MESSAGE_VW A , PS_AUC_DISP_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION |
| # | 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | AUC_ID | Character(10) | VARCHAR2(10) NOT NULL | Event ID |
| 6 | AUC_ROUND | Number(5,0) | INTEGER NOT NULL | Event Round |
| 7 | AUC_VERSION | Number(5,0) | INTEGER NOT NULL | Event Version |
| 8 | TREE_NODE_ID |
Number(6,0) | INTEGER NOT NULL | Node ID |
| 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 |
| 13 | BIDDER_SETID | Character(5) | VARCHAR2(5) NOT NULL | Bidder Setid |
| 14 | BIDDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 15 | BIDDER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bidder Type
B=Bidder C=Customer P=Public U=Uploaded V=Supplier |