Print      Open PDF Version of Online Help


Previous Topic

Next Topic

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 company 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

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

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:


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.