PTAUDIT_ROLEUSR

(SQL Table)
Index Back

Role User

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
2 AUDIT_STAMP DateTime(26) TIMESTAMP NOT NULL Date and Time Stamp
3 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
4 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
5 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
6 DYNAMIC_SW Character(1) VARCHAR2(1) NOT NULL Dynamic

Default Value: N