Mapping of Branch Data to Siebel CRM

In Oracle FLEXCUBE Universal Banking, branch data is stored in the STTM_BRANCH_HANDOFF staging table. The following information shows how the branch data stored in this table is mapped 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_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