CONTACT

(SQL Table)
Index Back

Customer Contact Detail

Customer Contact Detail Date Init. Issue # Description 012304 JJM 685277000 Created Rel Lang Record 03/08/12 EGS: Added ECHECK_USER_PIN

  • Related Language Record: CONTACT_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    2 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

    Default Value: NEXT

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    5 CONTACT_FLAG Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person.
    E=External Contact
    I=Internal Contact

    Default Value: E

    6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    7 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    8 LANGUAGE_PREF Character(3) VARCHAR2(3) NOT NULL Language Code
    CFR=Canadian French
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FRA=French
    GER=German
    GRK=Greek
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    MAY=Bahasa Malay
    POL=Polish
    POR=Portuguese
    SVE=Swedish
    THA=Thai
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    9 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    10 COMM_METHOD Character(1) VARCHAR2(1) NOT NULL Preferred Communication
    A=Email Invoice as Attachment
    C=Call
    E=Email only
    F=Fax
    I=XML only
    M=Standard Mail
    N=Email Notification
    P=Email & Print
    R=XML & Print

    Default Value: C

    11 SALUTATION_CD Character(6) VARCHAR2(6) NOT NULL Salutation Code

    Prompt Table: SALUTATION_TBL

    12 SALUTATION Character(30) VARCHAR2(30) NOT NULL Salutation
    13 CREATE_CUSTOMER Character(1) VARCHAR2(1) NOT NULL Create New Customer/Contact

    Y/N Table Edit

    Default Value: N

    14 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    15 DATE_LAST_MAINT Date(10) DATE Date Last Maintained
    16 AUTHORIZATION_ID Character(10) VARCHAR2(10) NOT NULL Authorization ID
    17 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    18 AUTO_PLAN_DAYS Number(3,0) SMALLINT NOT NULL Recurring Event Days
    19 AUTO_PLAN_HOLD Character(1) VARCHAR2(1) NOT NULL Order Events Hold

    Y/N Table Edit

    20 CALL_TIME Character(1) VARCHAR2(1) NOT NULL Best Time To Call
    1=Early Morning
    2=Mid Morning
    3=Noon / Lunch
    4=Afternoon
    5=Evening
    21 BIRTHDAY Character(5) VARCHAR2(5) NOT NULL MonthDay
    22 ORDER_EVENT_GROUP Character(10) VARCHAR2(10) NOT NULL Order Event Group

    Prompt Table: FO_ORDR_EVENT

    23 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
    24 AUTO_PLAN_OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID

    Prompt Table: OPRIDDESC_VW

    25 SOURCE_SYSTEM Character(3) VARCHAR2(3) NOT NULL Source System
    CCR=CCR
    EBL=eBill Contact Maintenance
    FED=FED
    PEN=Pension Customer
    26 ECHECK_USER_PIN Character(44) VARCHAR2(44) NOT NULL Personal Identification Number