CONTACT (SQL View)	Index Back
Customer Contact Detail Customer Contact Details view. This is used in RB_EIP for CRM/SCM Contact Integration.

CONTACT

(SQL View)

Customer Contact Detail

Customer Contact Details view. This is used in RB_EIP for CRM/SCM Contact Integration.

SELECT B.SETID , B.CONTACT_ID , 'A' , A.CONTACT_FLAG , B.NAME1 , A.TITLE , A.RB_LANGUAGE_CD , E.EMAIL_ADDR , A.COMM_METHOD , A.SALUTATION_CD , B.SALUTATION , 'N' , A.ROW_LASTMANT_OPRID , %DatePart(A.ROW_LASTMANT_DTTM) , A.AUTHORIZATION_ID , A.PERSON_ID , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_RD_PERSON A , PS_RB_INT_CONTACT B , PS_RB_INT_CNT_EMVW E WHERE A.BO_ID = E.BO_ID (+) AND A.BO_ID = B.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 CONTACT_FLAG Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person. It is also used to indicate whether a person has a Contact role.
E=External Contact
I=Internal Corporate Contact
Default Value: E

5 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.

6 TITLE Character(35) VARCHAR2(35) NOT NULL Title

7 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

8 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

9 COMM_METHOD Character(1) VARCHAR2(1) NOT NULL The person's preferred method of communication.
C=Call
E=Email Only
F=Fax
I=XML only
M=Standard Mail
P=Email & Print
R=XML & Print
S=SMS
Default Value: C

10 SALUTATION_CD Character(6) VARCHAR2(6) NOT NULL Salutation Code.

11 SALUTATION Character(30) VARCHAR2(30) NOT NULL Salutation. E.g., Mr., Mrs., Ms., Dr.

12 CREATE_CUSTOMER Character(1) VARCHAR2(1) NOT NULL Create New Customer
Y/N Table Edit
Default Value: N

13 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL This field determines the last user or operator that last changed this item.

14 DATE_LAST_MAINT Date(10) DATE This field determines the date of last maintenance.

15 AUTHORIZATION_ID Character(10) VARCHAR2(10) NOT NULL Identification used for authorization purposes.

16 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

17 AUTO_PLAN_DAYS Number(3,0) SMALLINT NOT NULL Recurring Event Days

18 AUTO_PLAN_HOLD Character(1) VARCHAR2(1) NOT NULL Order Events Hold

19 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

20 BIRTHDAY Character(5) VARCHAR2(5) NOT NULL MonthDay

21 ORDER_EVENT_GROUP Character(10) VARCHAR2(10) NOT NULL Order Event Group

22 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL PREF_FIRST_NAME field is used to identify the employees preferred first name

23 AUTO_PLAN_OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. 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	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	CONTACT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	An attribute that describes the specific purpose of a given bank/counterparty contact person. It is also used to indicate whether a person has a Contact role. E=External Contact I=Internal Corporate Contact Default Value: E
5	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
6	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
7	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
8	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
9	COMM_METHOD	Character(1)	VARCHAR2(1) NOT NULL	The person's preferred method of communication. C=Call E=Email Only F=Fax I=XML only M=Standard Mail P=Email & Print R=XML & Print S=SMS Default Value: C
10	SALUTATION_CD	Character(6)	VARCHAR2(6) NOT NULL	Salutation Code.
11	SALUTATION	Character(30)	VARCHAR2(30) NOT NULL	Salutation. E.g., Mr., Mrs., Ms., Dr.
12	CREATE_CUSTOMER	Character(1)	VARCHAR2(1) NOT NULL	Create New Customer Y/N Table Edit Default Value: N
13	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	This field determines the last user or operator that last changed this item.
14	DATE_LAST_MAINT	Date(10)	DATE	This field determines the date of last maintenance.
15	AUTHORIZATION_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification used for authorization purposes.
16	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
17	AUTO_PLAN_DAYS	Number(3,0)	SMALLINT NOT NULL	Recurring Event Days
18	AUTO_PLAN_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Order Events Hold
19	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
20	BIRTHDAY	Character(5)	VARCHAR2(5) NOT NULL	MonthDay
21	ORDER_EVENT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Order Event Group
22	PREF_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	PREF_FIRST_NAME field is used to identify the employees preferred first name
23	AUTO_PLAN_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID