AUDIT_EOTP_RECR

(SQL Table)
 Index Back

Audit Record for Recruitment

Audit Record for Recruitment

  • Audit Record Of EOTP_RECRT_LANG EOTP_RECRUIT

    • # 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: EOTP_BU

    6 EOTP_RECRUITID Number(15,0) DECIMAL(15) NOT NULL Recruit ID

    Prompt Table: EOTP_RECRUIT

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCRLONG Long Character CLOB Long Description
    9 EOTP_PUBLIC Character(1) VARCHAR2(1) NOT NULL Public Flag

    Y/N Table Edit

    Default Value: N