AUDIT_EOTP_CNTC

(SQL Table)
Index Back

Audit Partner Contacts

Audit Partner Contacts

  • Audit Record Of EOTP_PCNTCT_VW EOTP_PRTNRCNTCT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
    3 AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp
    4 EOTP_PARTNERID Number(15,0) DECIMAL(15) NOT NULL Partner ID

    Prompt Table: EOTP_PARTNER

    5 EOTP_SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    6 EOTP_SALUTATION Character(30) VARCHAR2(30) NOT NULL Salutation
    7 EOTP_FIRSTNAME Character(30) VARCHAR2(30) NOT NULL Partner Contact First Name
    8 EOTP_LASTNAME Character(30) VARCHAR2(30) NOT NULL Partner Contact Last Name
    9 EOTP_TITLE Character(35) VARCHAR2(35) NOT NULL Partner Title
    10 EOTP_ROLEDESCR Character(50) VARCHAR2(50) NOT NULL Role Description
    11 EOTP_EMAILADDR Character(70) VARCHAR2(70) NOT NULL Partner Contact Email Address
    12 EOTP_PHONENUM Character(24) VARCHAR2(24) NOT NULL Partner Contact Phone Number
    13 EOTP_PHONEEXT Character(5) VARCHAR2(5) NOT NULL Partner Contact Phone Extension
    14 EOTP_FAXNUM Character(24) VARCHAR2(24) NOT NULL Partner Contact Fax Number
    15 EOTP_PRIMCNTCT Character(1) VARCHAR2(1) NOT NULL Primary Contact Flag