Guidelines for mapping the CRM On Demand data model to the Oracle Policy Automation data model

 

Table of possible data type mapping:
CRM On Demand Field Type OPA Attribute type Remarks
Checkbox
  • Boolean
  • Text

As long as the value/format is appropriate for the CRM On Demand field (not entirely safe).

Currency Currency  
Date Date  
Date/Time DateTime  
Integer Number

Fractional value is truncated during save.

Multi-Select Picklist Text

Similar to Picklist (below) but may contain more than one value. Since we don't support arrays in the Oracle Policy Automation attribute, the Text type might be the only applicable type.

Number Number  
Percent Number  
Phone

Text

 
Picklist Text In CRM On Demand, this is a list of choices (lookup). If the field has a selected value, then it can be mapped as a text
Text(Long) Text  
Text(Short) Text  
Web Link N/A