PTAUDIT_AUTHITM

index back

Authorized Menu Item


PeopleSoft Field Name Field Type Column Type Description
AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
AUDIT_STAMP DateTime(26) TIMESTAMP NOT NULL Date and Time Stamp
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
CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

Prompt Table: PSMENUDEFN

BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
PNLITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name
DISPLAYONLY Number(1,0) SMALLINT NOT NULL Display Only
AUTHORIZEDACTIONS Number(10,0) DECIMAL(10) NOT NULL Authorized Actions for Panels
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20