CA_REVREC_DCLOG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	KEY1	Character(65)	VARCHAR2(65) NOT NULL	First Key
3	KEY2	Character(65)	VARCHAR2(65) NOT NULL	Second Key
4	KEY3	Character(65)	VARCHAR2(65) NOT NULL	Third Key
5	KEY4	Character(65)	VARCHAR2(65) NOT NULL	Fourth Key
6	KEY5	Character(65)	VARCHAR2(65) NOT NULL	Fifth Key
7	KEY6	Character(65)	VARCHAR2(65) NOT NULL	Sixth Key
8	FIELDNAME1	Character(18)	VARCHAR2(18) NOT NULL	Field Name 1
9	FIELDVALUE1	Character(30)	VARCHAR2(30) NOT NULL	Field Value
10	FIELDNAME2	Character(18)	VARCHAR2(18) NOT NULL	Fieldname 2
11	FIELDVALUE2	Character(30)	VARCHAR2(30) NOT NULL	Field Value
12	FIELDNAME3	Character(18)	VARCHAR2(18) NOT NULL	Field Name 3
13	FIELDVALUE3	Character(30)	VARCHAR2(30) NOT NULL	Field Value
14	FIELDNAME4	Character(18)	VARCHAR2(18) NOT NULL	Field Name 4
15	FIELDVALUE4	Character(30)	VARCHAR2(30) NOT NULL	Field Value
16	FIELDNAME5	Character(18)	VARCHAR2(18) NOT NULL	Field Name 5
17	FIELDVALUE5	Character(30)	VARCHAR2(30) NOT NULL	Field Value
18	FIELDNAME6	Character(18)	VARCHAR2(18) NOT NULL	Field Name
19	FIELDVALUE6	Character(30)	VARCHAR2(30) NOT NULL	Field Value
20	FIELDNAME7	Character(18)	VARCHAR2(18) NOT NULL	Field Name
21	FIELDVALUE7	Character(30)	VARCHAR2(30) NOT NULL	Field Value
22	FIELDNAME8	Character(18)	VARCHAR2(18) NOT NULL	Field Name
23	FIELDVALUE8	Character(30)	VARCHAR2(30) NOT NULL	Field Value
24	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
25	AUDIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The OPRID of the user who made the changes audited on an audit record.
26	AUDIT_STAMP	DateTime(26)	TIMESTAMP	Date and Time Stamp