AUDIT_EOTP_GRP (SQL Table)	Index Back
Audit Service Group Audit Service Group

AUDIT_EOTP_GRP

(SQL Table)

Audit Service Group

Audit Record Of EOTP_GROUP EOTP_GROUP_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AUDIT_RECNAME Character(15) VARCHAR2(15) NOT NULL Name of the record definition audited. AUDIT_RECNAME is used in User-Defined Audit Record Definitions.

2 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

3 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.

4 AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp

5 EOTP_GROUPID Number(15,0) DECIMAL(15) NOT NULL Service Group ID
Prompt Table: EOTP_GROUP

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

7 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AUDIT_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Name of the record definition audited. AUDIT_RECNAME is used in User-Defined Audit Record Definitions.
2	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
3	AUDIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The OPRID of the user who made the changes audited on an audit record.
4	AUDIT_STAMP	DateTime(26)	TIMESTAMP	Date and Time Stamp
5	EOTP_GROUPID	Number(15,0)	DECIMAL(15) NOT NULL	Service Group ID Prompt Table: EOTP_GROUP
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	DESCRLONG	Long Character	CLOB	Long Description