CONTACT(SQL Table) |
Index Back |
---|---|
Customer Contact DetailCustomer Contact Detail Date Init. Issue # Description 012304 JJM 685277000 Created Rel Lang Record 03/08/12 EGS: Added ECHECK_USER_PIN |
# | 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 |