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