Bookshelf v8.2: Mapping of Branch Data to Siebel CRM

In Oracle FLEXCUBE Universal Banking, branch data is stored in the STTM_BRANCH_HANDOFF staging table. Table 14 shows how the branch data stored in this table is mapped to Siebel CRM.

Table 14. Branch Data Mapping to Siebel CRM
Oracle FLEXCUBE Attribute	Siebel Business Compon-ent	Siebel Field	Siebel Base Table	Siebel Base Column	Siebel EIM Table	Siebel EIM Table Column
Branch_Code	Internal Division	Location	S_ORG_EXT	LOC	EIM_FN_ ACCNT1	ACC_LOC Part of User Key
Branch_Code	Internal Division	Party UId	S_ORG_EXT	PARTY_UID	EIM_FN_ ACCNT1	PARTY_UID
Branch_Name	Internal Division	Name	S_ORG_EXT	NAME	EIM_FN_ ACCNT1	ACC_NAME Part of User Key
Routing_ Number	Internal Division	ABA Number	S_ORG_EXT	ABA_NUMBER	EIM_FN_ ACCNT1	ACC_ABA_ NUMBER
Parent_ Branch_Code	Internal Division	Parent Division Id	S_ORG_EXT	PAR_DIVN_ID	EIM_FN_ ACCNT1	PARDIV_ ACCNT_BU PARDIV_ ACCNT_LOC PARDIV_ACCNT_NAME
Local Currency	Internal Division	Currency Code	S_ORG_EXT	BASE_CURCY_CD	EIM_FN_ ACCNT1	ACC_BASE_ CURCY_CD
Address 1	Internal Division	Street Address	S_CON_ADDR This is a new record in the S_CON_ADDR table.	ADDR_PER_ID	EIM_FN_ ACCNT1	ADDR_ NAME
Address 2				ACCNT_ID		ACCNT_BU
Address 3				ACCNT_ID		ACCNT_LOC ACCNT_ NAME
Address1	CUT Address	Street Address	S_ADDR_PER	ADDR	EIM_ADDR_ PER	AP_ADDR
Address2	CUT Address	Branch Address 2	S_ADDR_PER	ADDR_LINE_2	EIM_ADDR_ PER	AP_ADDR_ LINE_2
Address3	CUT Address	Apartment Number	S_ADDR_PER	ADDR_LINE_3	EIM_ADDR_ PER	AP_ADDR_ LINE_3
Country Code	CUT Address	Country	S_ADDR_PER	COUNTRY	EIM_FN_ ACCNT1	AP_ COUNTRY

Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide		Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.