|
Administering Oracle CRM On Demand > Data Management Tools > Import and Export Tools > Preparing for Data Importing > Claim Fields: Import Preparation
Claim Fields: Import Preparation
The following table contains specific information about setting up your CSV file before importing claims data in to 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. This topic is specific to Oracle CRM On Demand Financial Services Edition.
The information in the following table is valid for claims data only.
Claim Field Name
|
Data Type
|
Maximum Length
|
Comments
|
Ability to Work
|
Picklist
|
30
|
None
|
Address
|
Text
|
200
|
None
|
Address Line 1
|
Text
|
100
|
None
|
Address Line 2
|
Text
|
100
|
None
|
Amount of Liability
|
Currency
|
22
|
None
|
Amount of Loss
|
Currency
|
22
|
None
|
At Fault
|
Picklist
|
30
|
None
|
Business Account
|
Text
|
15
|
The held away institution (business account) linked to this record.
|
Business Account: External System ID
|
Text
|
30
|
None
|
Category of Loss
|
Picklist
|
30
|
None
|
City
|
Text
|
50
|
None
|
Claim Number
|
Text
|
50
|
The predefined field for the matching record.
|
Class of Employee
|
Picklist
|
30
|
None
|
Closed Date
|
Date
|
Not applicable
|
None
|
Comments
|
Text
|
250
|
None
|
Company: External System ID
|
Text
|
30
|
Also known as the external unique ID.
|
Conditions
|
Text
|
50
|
None
|
Contact
|
Text
|
15
|
None
|
Contact: External System ID
|
Text
|
30
|
None
|
Country
|
Text
|
30
|
None
|
County
|
Text
|
50
|
None
|
Currency Code
|
Picklist
|
20
|
None
|
Date of Employer Aware of Claim
|
Date
|
Not applicable
|
None
|
Date of Employer Aware of Injury
|
Date
|
Not applicable
|
None
|
Division
|
Text
|
50
|
None
|
Employee Injured Number
|
Number
|
22
|
None
|
Event Number
|
Text
|
50
|
None
|
Exchange Date
|
Date
|
Not applicable
|
None
|
External System ID
|
Text
|
50
|
None
|
External Last Updated
|
Date/Time
|
Not applicable
|
None
|
External Source
|
Text
|
50
|
None
|
Hospital Name
|
Text
|
50
|
None
|
Household
|
Text
|
15
|
None
|
Household: External System ID
|
Text
|
30
|
None
|
Injured During Working Hours
|
Picklist
|
30
|
None
|
Kind of Loss
|
Picklist
|
30
|
None
|
Liability Source
|
Picklist
|
30
|
None
|
Line of Business
|
Picklist
|
30
|
None
|
Location of Loss
|
Picklist
|
30
|
None
|
Loss Code
|
Picklist
|
30
|
None
|
Loss Date and Time
|
Date/Time
|
Not applicable
|
None
|
Loss Description
|
Text
|
16,350
|
If a description field in the import file exceeds 16,350 characters, it is truncated to 16,252 characters.
|
Loss Type
|
Picklist
|
30
|
None
|
Medical Injury Code
|
Picklist
|
30
|
None
|
Owner
|
Text
|
15
|
None
|
Owner: External System ID
|
Text
|
30
|
None
|
Part of Body Injured
|
Picklist
|
30
|
None
|
People Injured Number
|
Number
|
22
|
None
|
Picklist Value Group
|
Text
|
50
|
None
|
Place of Injury
|
Picklist
|
30
|
None
|
Police Department
|
Text
|
50
|
None
|
Police Report Number
|
Text
|
50
|
None
|
Policy
|
Text
|
50
|
The predefined field for the matching record.
|
Policy: External System ID
|
Text
|
50
|
The external unique ID of the policy linked to this record.
|
Postal Code
|
Text
|
30
|
None
|
Province
|
Text
|
50
|
None
|
Relationship to Insured
|
Picklist
|
30
|
None
|
Report Date
|
Date
|
Not applicable
|
None
|
Report Number
|
Text
|
50
|
None
|
Reported by
|
Picklist
|
30
|
None
|
Reporter Contact Info
|
Text
|
50
|
None
|
State
|
Text
|
10
|
None
|
Status
|
Picklist
|
30
|
None
|
Time of Death
|
Date/Time
|
Not applicable
|
None
|
Type of Injury
|
Picklist
|
30
|
None
|
Related Topics
See the following topics for related information:
| 
