PSARCHAUDIT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	PSARCH_EVENT	Character(2)	VARCHAR2(2) NOT NULL	Archiving Event
3	PSARCH_EVENTDTTM	DateTime(26)	TIMESTAMP	Event Date/Time
4	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
5	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
6	PSARCH_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	Archive Process D=Archive Delete H=Remove from History I=Import Process P=Run Reports R=Archive Rollback S=Archive Selection
7	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
8	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
9	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
10	PSARCH_NUMOFROWS	Signed Number(19,0)	DECIMAL(18) NOT NULL	Number of Rows
11	PSARCH_SQL	Long Character	CLOB	SQL Statement