AUDIT_EOTP_PRTN

(SQL Table)
 Index Back

Audit Partner

Audit Partner

  • Audit Record Of EOTP_ACTPTNR_VW EOTP_PARTNER EOTP_PARTNER_L EOTP_PRT_VW

    • # 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_PARTNERSTAT Character(1) VARCHAR2(1) NOT NULL New for Trading Partner Management 8.8
    P=Pending
    R=Partner
    X=Ended Partnership
    6 EOTP_COMPNAME Character(30) VARCHAR2(30) NOT NULL Company Name
    7 DESCRLONG Long Character CLOB Long Description
    8 EOTP_COMPURL Character(254) VARCHAR2(254) NOT NULL Partner URL
    9 EOTP_INDUSTRY Character(20) VARCHAR2(20) NOT NULL Industry
    10 EOTP_STKSYMBOL Character(10) VARCHAR2(10) NOT NULL Stock Symbol
    11 EOTP_REVENUE Character(1) VARCHAR2(1) NOT NULL Partner Revenue
    A=$1 Billion and Above
    B=$300 Million - $1 Billion
    C=$100 Million - $300 Million
    D=Less than $100 Million
    N=Not Applicable
    12 EOTP_EMPLCOUNT Number(15,0) DECIMAL(15) NOT NULL Employee Count
    13 EOTP_MINOWNED Character(1) VARCHAR2(1) NOT NULL Minority Owned
    14 EOTP_FEMOWNED Character(1) VARCHAR2(1) NOT NULL Woman Owned
    15 EOTP_EEODATE Date(10) DATE EEO Certification Date
    16 EOTP_HUBZONE Character(1) VARCHAR2(1) NOT NULL HUB Zone