ESIGN_HDR_AUDIT

(SQL Table)
 Index Back

Acknowledgement Header Audit

Audit Record for Acknowledgement Header

  • Audit Record Of ESIGN_HDR ESIGN_HDR_DVW

    • # 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_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_STAMP DateTime(26) TIMESTAMP NOT NULL Date and Time Stamp
    4 ESIGN_ID Character(5) VARCHAR2(5) NOT NULL Acknowledgement ID
    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    7 ESIGN_VERIFY_ID Character(1) VARCHAR2(1) NOT NULL Enable Verify Identity

    Default Value: N

    8 ESIGN_GB_HEADER Character(100) VARCHAR2(100) NOT NULL Audit section header