Siebel Innovation Pack 2015: Mapping of Product Data to Siebel CRM

In Oracle FLEXCUBE Universal Banking, product data is stored in the CSTM_PRD_HANDOFF staging table, and account class data is stored in the STTM_ACLASS_HANDOFF staging table. This topic shows how data stored in these tables is mapped to Siebel CRM.

Table 15 shows the mapping of product data from the Oracle FLEXCUBE Universal Banking CSTM_PRD_HANDOFF table to Siebel CRM.

Table 15. Mapping of Product Data 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
PRD_CODE	Internal Product	Name	S_PROD_INT	NAME	EIM_PROD_INT	NAME
PRD_ DESCRIPTION	Internal Product	Description	S_PROD_INT	DESC_TEXT	EIM_PROD_INT	DESC_TEXT
PRD_TYPE	Internal Product	Product Type	S_PROD_INT	DETAIL_TYPE_CD	EIM_PROD_INT	DETAIL_TYPE_CD
PRD_SLOGAN	Not displayed on business component	No field	S_PROD_INT	STRATEGY	EIM_PROD_INT	STRATEGY
PRD_START_DATE	Internal Product	Start Date	S_PROD_INT	EFF_START_ DT	EIM_PROD_INT	EFF_START_DT
PRD_END_ DATE	Internal Product	End Date	S_PROD_INT	EFF_END_DT	EIM_PROD_INT	EFF_END_DT
PRD_ REMARKS	Internal Product	Comments	S_PROD_INT	COMMENTS	EIM_PROD_INT	PROD_ COMMENTS
REVOLVING	Internal Product	Featured	S_PROD_INT	FEATURED_ FLG	EIM_PROD_INT	FEATURED_ FLG
RECORD STATUS	Internal Product	Version Status	S_PROD_INT	STATUS_CD	EIM_PROD_INT	STATUS_CD
PRD_GROUP	Product Line	Name	S_PROD_LN	NAME	EIM_PROD_LN	PRDLN_NAME
			S_PROD_ LN_PROD	PROD_LN_ID	EIM_PROD_LN	PRDLN_NAME There is a many-to-many relationship between Product and Product Line.
			S_PROD_ LN_ROD	PROD_ID	EIM_PROD_LN	PROD_PROD_BU PROD_PROD_NAME

Table 16 shows the mapping of account class data from the Oracle FLEXCUBE Universal Banking STTM_ACLASS_HANDOFF staging table to Siebel CRM.

Table 16. Mapping of Account Class Data
Oracle FLEXCUBE Attribute	Siebel Business Compon-ent	Siebel Field	Siebel Base Table	Siebel Base Column	Siebel EIM Table	Siebel EIM Table Column
ACCOUNT_ CLASS	Internal Product	Name	S_PROD_INT	NAME	EIM_PROD_INT	NAME
DESCRIPTION	Internal Product	Description	S_PROD_INT	DESC_TEXT	EIM_PROD_INT	DESC_TEXT
AC_CLASS_ TYPE	Internal Product	Product Type	S_PROD_INT	DETAIL_TYPE_CD	EIM_PROD_INT	DETAIL_TYPE_CD
START_DATE	Internal Product	Start Date	S_PROD_INT	EFF_START_ DT	EIM_PROD_INT	EFF_START_DT
END_DATE	Internal Product	End Date	S_PROD_INT	EFF_END_DT	EIM_PROD_INT	EFF_END_DT
RECORD STATUS	Internal Product	Version Status	S_PROD_INT	STATUS_CD	EIM_PROD_INT	STATUS_CD
ACCOUNT_ CODE	Product Line	Name	S_PROD_LN	NAME	EIM_PROD_LN	PRDLN_ NAME
			S_PROD_LN_PROD	PROD_LN_ID	EIM_PROD_LN	PRDLN_ NAME
			S_PROD_LN_PROD	PROD_ID	EIM_PROD_LN	PROD_PROD_BU PROD_PROD_NAME
CHEQUE_ BOOK_ FACILITY OVERDRAFT_ FACILITY PASSBOOK_ FACILITY ATM_FACILITY ILM_ APPLICABLE BRANCH_LIST	Key Feature A one-to-many mapping exists between Oracle FLEXCUBE products and features.	Feature	S_PROD_ SPEC	DESC_TEXT	EIM_PROD_ INT1	SPEC_DESC_TEXT
		Value	S_PROD_ SPEC	VAL	EIM_PROD_ INT1	SPEC_VAL
		Value	S_PROD_ SPEC	PROD_ID	EIM_PROD_ INT1	PROD_BU PROD_NAME

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