Mapping of Product Rate Data to Siebel CRM

In Oracle FLEXCUBE Universal Banking, product rate data is stored in the following staging tables:

• Loan data is stored in the CLTM_LOAN_RATE_HDF staging table.

• Corporate deposit data is stored in the LDTM_CDRATE_HANDOFF staging table.

• Checking account, savings account (CASA) and retail deposit data is stored in the STTM_ACCLASS_UDE_VALHF staging table.

This topic shows how the data stored in these tables is mapped to Siebel CRM.

The following information shows the mapping of loan product rate data from the Oracle FLEXCUBE Universal Banking CLTM_LOAN_RATE_HDF staging table 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
CCY_CODE (Currency)	Internal Product	Currency Code	S_PROD_INT	CARY_COST_ CURCY_CD	EIM_FN_PRDINT1	PROD_CARYCOSTCURCY
PRODUCT_ CODE (Product)	FIN Product Rates	Product Id	S_PROD_RATE	PROD_ID	EIM_FN_PRDINT1	PROD_NAME PROD_BU
UDE_ID (Rate Component)	FIN Product Rates	Not Available	S_PROD_RATE	INDEX_CD	EIM_FN_PRDINT1	RT_INDEX_ CD
UDE_VALUE (Rate Code)	FIN Product Rates	Default Rate	S_PROD_RATE	INDEX_RATE	EIM_FN_PRDINT1	RT_INDEX_ RATE
UDE_CCY (Rate Currency)	FIN Product Rates	Not Available	S_PROD_RATE	PROD_CURCY_CD	EIM_FN_PRDINT1	RT_PROD_ CURCY_CD
RATE_TYPE (Rate Type)	FIN Product Rates	Rate Type	S_PROD_RATE	TYPE_CD	EIM_FN_PRDINT1	RT_TYPE_CD
MAXIMUM_ TENOR (Maximum Tenor)	FIN Product Rates	Max Term	S_PROD_RATE	MAX_TERM	EIM_FN_PRDINT1	RT_MAX_ TERM
MINIMUM_ TENOR (Minimum Tenor)	FIN Product Rates	Min Term	S_PROD_RATE	MIN_TERM	EIM_FN_PRDINT1	RT_MIN_ TERM
UNITS (Units)	FIN Product Rates	Max Term Duration	S_PROD_RATE	MAX_TERM_DUR_ CD	EIM_FN_PRDINT1	RT_MAX_TERM_DUR_CD
		Min Term Duration		MIN_TERM_DUR_ CD		MIN_TERM_DUR_CD
RULE_ DESCRIPTION (Rule Description)	FIN Prod Rate Condition	Rate Condition	S_CONDITION	DESC_TEXT	EIM_FN_CNDTN	CND_DESC_TEXT
		Condition Type	S_CONDITION	TYPE_CD		CND_TYPE_CD
			S_PRODRATE_ COND	COND_ID	EIM_FN_PRDINT1	COND_CND_DESC_TXT1 COND_CND_TYPE_CD1
				PRODRATE_ID		RT_DEDUCT_AMT PROD_BI PROD_NAME RT_TYPE_CD

The following information shows the mapping of corporate deposit product rate data from the Oracle FLEXCUBE Universal Banking LDTM_CDRATE_HANDOFF staging table 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
PRODUCT_ CODE	FIN Product Rates	Product Id	S_PROD_ RATE	PROD_ID	EIM_FN_ PRDINT1	PROD_NAME PROD_BU
COMPONENT_NAME	FIN Product Rates	Not available	S_PROD_ RATE	INDEX_CD	EIM_FN_ PRDINT1	RT_INDEX_ CD
RATE_TYPE	FIN Product Rates	Rate Type	S_PROD_ RATE	TYPE_CD	EIM_FN_ PRDINT1	RT_TYPE_CD
CURRENCY	Internal Product	Currency Code	S_PROD_INT	CARY_COST_CURCY_CD	EIM_FN_ PRDINT1	PROD_CARYCOSTCURCY
DEFAULT_ RATE	FIN Product Rates	Default Rate	S_PROD_ RATE	INDEX_RATE	EIM_FN_ PRDINT1	RT_INDEX_ RATE
MAXIMUM_ RATE	FIN Product Rates	Max Rate	S_PROD_ RATE	MAX_RATE	EIM_FN_ PRDINT1	RT_MAX_ RATE
MINIMUM_ RATE	FIN Product Rates	Min Rate	S_PROD_ RATE	MIN_RATE	EIM_FN_ PRDINT1	RT_MIN_ RATE
DEFAULT_ SPREAD	FIN Product Rates	Margin Spread	S_PROD_ RATE	MARGIN_ SPREAD	EIM_FN_PRDINT1	RT_MARGIN_SPREAD
MAXIMUM_ TANOR	FIN Product Rates	Max Term	S_PROD_ RATE	MAX_TERM	EIM_FN_ PRDINT1	RT_MAX_ TERM
MINIMUM_ TANOR	FIN Product Rates	Min Term	S_PROD_ RATE	MIN_TERM	EIM_FN_ PRDINT1	RT_MIN_ TERM
UNITS	FIN Product Rates	Max Term Duration	S_PROD_ RATE	MAX_TERM_ DUR_CD	EIM_FN_ PRDINT1	RT_MAX_ TERM_DUR_CD
		Min Term Duration		MIN_TERM_ DUR_CD		RT_MIN_ TERM_DUR_CD

The following information shows the mapping of CASA and retail deposit product rate data from the Oracle FLEXCUBE Universal Banking STTM_ACCLASS_UDE_VALHF staging table 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 Product	Vendor Location	S_PROD_INT	OU_ID	EIM_PROD_ INT	VENDR_ ACCNT_BU
						VENDR_ ACCNT_LOC
						VENDR_ ACCNT_NAME
CURRENCY_ CODE	Internal Product	Currency	S_PROD_INT	CARY_COST_CURCY_CD	EIM_FN_ PRDINT1	PROD_CARYCOSTCURCY
ACCOUNT_ CLASS (Product)	FIN Product Rates	Product Id	S_PROD_ RATE	PROD_ID	EIM_FN_ PRDINT1	PROD_NAME
						PROD_BU
UDE_ID (Rate Component)	FIN Product Rates	Not Available	S_PROD_ RATE	INDEX_CD	EIM_FN_ PRDINT1	RT_INDEX_ CD
RATE	FIN Product Rates	Default Rate	S_PROD_ RATE	INDEX_RATE	EIM_FN_ PRDINT1	RT_INDEX_ RATE
CHARGE_ AMOUNT	FIN Product Rates	Min Amount	S_PROD_ RATE	MIN_AMT	EIM_FN_ PRDINT1	RT_MIN_AMT
CHARGE_ RATE	FIN Product Rates	Min Rate	S_PROD_ RATE	MIN_RATE	EIM_FN_ PRDINT1	RT_MIN_ RATE