Administering Oracle CRM On Demand > Data Management Tools > Import and Export Tools > Preparing for Data Importing > Messaging Plan Fields: Import Preparation
Messaging Plan Fields: Import Preparation
The following table contains specific information about setting up your CSV file before importing messaging plans into Oracle CRM On Demand. This information supplements the guidelines given in the topic Field Type Guidelines for Importing Data. First, you must review the following import information before performing an import.
NOTE: The Default Field column in this table contains only the initial (default) name for each field. It does not contain any names that have been changed for your company in Oracle CRM On Demand. Therefore, if you do not see a specific field when you try to import your data, check with your administrator to determine the new name for the field.
Default Messaging Plan Field Name
|
Data Type
|
Maximum Length
|
Comments
|
Audience
|
Text
|
1000
|
This field describes the targeted audience for this message plan, for example, cardiac surgeons.
|
Code
|
Text
|
50
|
This field tracks messaging plans in different Row IDs. For example, if you revise a messaging plan, this field creates a copy of the messaging plan with an incremented version number.
|
Disclosure Mandatory
|
Boolean
|
1
|
When this field is selected, a disclosure message is displayed.
|
Division
|
Text
|
50
|
None
|
Enable Followup
|
Boolean
|
1
|
None
|
Expiration Date
|
DateTime
|
7
|
The date on which the messaging plan ends.
|
External Unique ID
|
Text
|
50
|
None
|
Lock Sequence
|
Boolean
|
1
|
This field locks the messaging plan, which prevents users from changing the sequence, or removing messages from a messaging plan.
|
Name
|
Text
|
200
|
The name of the messaging plan or the personalized messaging plan.
|
Picklist Value Group
|
Text
|
50
|
None
|
Priority
|
Number
|
22
|
None
|
Release Date
|
DateTime
|
7
|
The release date of the messaging plan.
|
Segment
|
Text
|
50
|
This field describes the market segment; that is, the group of accounts, to which the message plan is targeted, for example, tertiary care hospitals. It shows the recommended messaging plans to sales representatives when they are planning calls.
|
Skin
|
Text
|
30
|
When the messaging planner is opened for editing or previewing, the layout of the messaging plan is also displayed.
|
Start Date
|
DateTime
|
7
|
None
|
Status
|
Picklist
|
30
|
The default, valid values for this field are: Approved, In Progress, Rejected, Released, Submitted.
|
Type
|
Text
|
30
|
The default, valid values for this field are: Product Launch and Targeted Messaging.
|
Related Topics
See the following topics for related information:
|