Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide > Data Mappings to Siebel EIM Tables >
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. Table 15 shows the mapping of loan product rate data from the Oracle FLEXCUBE Universal Banking CLTM_LOAN_RATE_HDF staging table to Siebel CRM.
Table 15. Mapping of Loan Product Rate Data to Siebel CRM
Oracle FLEXCUBE Attribute |
Siebel Business Compon-ent |
|
|
|
|
|
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 |
Table 16 shows the mapping of corporate deposit product rate data from the Oracle FLEXCUBE Universal Banking LDTM_CDRATE_HANDOFF staging table to Siebel CRM.
Table 16. Mapping of Corporate Deposit Product Rate Data to Siebel CRM
Oracle FLEXCUBE Attribute |
Siebel Business Compon-ent |
|
|
|
|
|
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 |
Table 17 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.
Table 17. Mapping of CASA and Retail Deposit Product Rate Data to Siebel CRM
Oracle FLEXCUBE Attribute |
Siebel Business Compon-ent |
|
|
|
|
|
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 |
|