PSAUDIT

(SQL Table)
Index Back

Field Level Audits

  • Audit Record Of PERS_DNID_JPN PERS_NID_JPN PSCERTEXTFILE PSCERTXTFL_LG
  • # 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 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 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    6 OLDVALUE Character(65) VARCHAR2(65) NOT NULL Old Value
    7 NEWVALUE Character(65) VARCHAR2(65) NOT NULL New Value
    8 KEY1 Character(65) VARCHAR2(65) NOT NULL First Key
    9 KEY2 Character(65) VARCHAR2(65) NOT NULL Second Key
    10 KEY3 Character(65) VARCHAR2(65) NOT NULL Third Key
    11 KEY4 Character(65) VARCHAR2(65) NOT NULL Fourth Key
    12 KEY5 Character(65) VARCHAR2(65) NOT NULL Fifth Key
    13 KEY6 Character(65) VARCHAR2(65) NOT NULL Sixth Key
    14 KEY7 Character(65) VARCHAR2(65) NOT NULL Seventh Key
    15 KEY8 Character(65) VARCHAR2(65) NOT NULL Eighth Key
    16 KEY9 Character(65) VARCHAR2(65) NOT NULL Ninth Key
    17 KEY10 Character(65) VARCHAR2(65) NOT NULL Tenth Key
    18 KEY11 Character(65) VARCHAR2(65) NOT NULL Eleventh Key
    19 KEY12 Character(65) VARCHAR2(65) NOT NULL Twelfth Key
    20 KEY13 Character(65) VARCHAR2(65) NOT NULL Thirteenth Key
    21 KEY14 Character(65) VARCHAR2(65) NOT NULL Fourteenth Key
    22 KEY15 Character(65) VARCHAR2(65) NOT NULL Fifteenth Key