AUC_MESSAGES (SQL Table)	Index Back
Event Messages Event Messages

AUC_MESSAGES

(SQL Table)

Event Messages

# 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_AUTHOR_ID Character(30) VARCHAR2(30) NOT NULL Author ID

5 AUC_REPLYTO_ID Character(30) VARCHAR2(30) NOT NULL Reply to Name

6 AUC_AUTHOR_EMAIL Character(70) VARCHAR2(70) NOT NULL Author Email

7 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created

8 AUC_MSG_SUBJECT Character(100) VARCHAR2(100) NOT NULL Subject

9 AUC_MSG_BODY Long Character(32700) CLOB Sourcing Message Body

10 AUC_READ_ONLY Character(1) VARCHAR2(1) NOT NULL Read Only Permission

11 AUC_PRIVATE_FLG Character(1) VARCHAR2(1) NOT NULL Private Message

12 AUC_DISP_NAME_TYPE Character(1) VARCHAR2(1) NOT NULL Display Name
P=Pseudoname
U=Userid

13 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.

14 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.

#	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_AUTHOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Author ID
5	AUC_REPLYTO_ID	Character(30)	VARCHAR2(30) NOT NULL	Reply to Name
6	AUC_AUTHOR_EMAIL	Character(70)	VARCHAR2(70) NOT NULL	Author Email
7	DTTM_CREATED	DateTime(26)	TIMESTAMP	Datetime Created
8	AUC_MSG_SUBJECT	Character(100)	VARCHAR2(100) NOT NULL	Subject
9	AUC_MSG_BODY	Long Character(32700)	CLOB	Sourcing Message Body
10	AUC_READ_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Read Only Permission
11	AUC_PRIVATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Private Message
12	AUC_DISP_NAME_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Display Name P=Pseudoname U=Userid
13	SCM_ATTACH_ID	Character(64)	VARCHAR2(64) NOT NULL	The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
14	ATT_VERSION	Number(3,0)	SMALLINT NOT NULL	The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.