EOTP_PCNTCT_VW

(SQL View)
 Index Back

Partner Contacts

Partner Contacts

SELECT EOTP_PARTNERID , EOTP_SEQNUM , EOTP_SALUTATION , EOTP_FIRSTNAME , EOTP_LASTNAME , EOTP_TITLE , EOTP_ROLEDESCR , EOTP_EMAILADDR , EOTP_PHONENUM , EOTP_PHONEEXT , EOTP_FAXNUM , EOTP_PRIMCNTCT , OPRID FROM PS_EOTP_PRTNRCNTCT WHERE EOTP_PRIMCNTCT='Y'

  • Audit Record: AUDIT_EOTP_CNTC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOTP_PARTNERID Number(15,0) DECIMAL(15) NOT NULL Partner ID

    Prompt Table: EOTP_PARTNER

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

    Y/N Table Edit

    Default Value: Y

    13 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: PSOPRDEFN