Siebel CRM Integration to Oracle FLEXCUBE Universal Banking Implementation Guide > Data Mappings to Siebel EIM Tables >
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 14 shows the mapping of product data from the Oracle FLEXCUBE Universal Banking CSTM_PRD_HANDOFF table to Siebel CRM.
Table 14. Mapping of Product Data to Siebel CRM
Oracle FLEXCUBE Attribute |
Siebel Business Compon-ent |
|
|
|
|
|
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 15 shows the mapping of account class data from the Oracle FLEXCUBE Universal Banking STTM_ACLASS_HANDOFF staging table to Siebel CRM.
Table 15. Mapping of Account Class Data
Oracle FLEXCUBE Attribute |
Siebel Business Compon-ent |
|
|
|
|
|
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 |
PROD_ID |
EIM_PROD_ INT1 |
PROD_BU PROD_NAME |
|