EB_AUD_PH_ARC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
5	PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Phone Type BUSN=Business Phone CAMP=Campus Phone CELL=Cellular Phone DORM=Dormitory Phone FAX=FAX HOME=Home Phone MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex
6	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
7	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
8	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
9	PRIMARY_PHONE	Character(1)	VARCHAR2(1) NOT NULL	Primary Phone
10	FS_EVENT_CODE	Character(15)	VARCHAR2(15) NOT NULL	Event code
11	AUDLOG_DTTM	DateTime(26)	TIMESTAMP	Date and time that the event occurred.
12	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
13	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
14	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
15	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
16	MESSAGE_TEXT_254	Character(254)	VARCHAR2(254) NOT NULL	Message Text
17	MESSAGE_PARM	Character(254)	VARCHAR2(254) NOT NULL	Message Parameter Text
18	BATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Batch Action
19	PURGE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Purge History without Archive