Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Exam Fields: Import Preparation

The following table contains specific information about setting up your CSV file before importing exam data 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 company administrator to determine the new name for the field.

Default Exam Field Name

Field Type

Maximum Length

Comments

Available From

Date

7

None.

Available To

Date

7

None.

Company

Text

100

None.

Contact

Picklist

15

Use this field if the exam contact is already present in Oracle CRM On Demand.

Description

Text

255

None.

Email

Text

100

The email address for the exam contact.

Exam Fee

Currency

22

None.

Exam ID

Text

100

It is recommended that the internal identifier for the course be unique.

First Name

Text

50

Use this field to enter the exam contact's first name only if the contact is not present in Oracle CRM On Demand.

Format

Picklist

30

The default valid values are as follows: Multiple Choice, Q&A, and Blended.

Grading Method

Picklist

30

The default valid values are as follows: Grades, Points, and Scores.

Last Name

Text

50

Use this field to enter the exam contact's last name only if the contact is not present in Oracle CRM On Demand.

Maximum Score

Number

22

None.

Medium

Picklist

30

The default valid values are as follows: Computer-Based, Paper-Based, and Blended.

Name

Text

100

It is recommended that the exam name be unique.

Number of Questions

Number

22

None.

Objective

Picklist

15

None.

Owner

Picklist

15

None.

Passing Score

Number

22

None.

Payment Options

Picklist

30

The default valid values are as follows: Cheque, Credit Card, Cash, and Earned Funds.

Phone

Phone

40

The phone number for the exam contact.

Primary Product

Picklist

15

None.

Primary Product Category

Picklist

15

None.

 

Status

Picklist

30

The default valid values are as follows: Draft, Planned, Available, Obsolete, and Inactive.

Time Allowed (Minutes)

Number

22

None.

Type

Picklist

30

The default valid values are as follows: Proctored and Online. An exam is considered to be proctored when the candidates are supervised during the exam.

Validity (Months)

Number

22

None.

Website

Text

100

The URL to a page that contains additional exam information.

Related Topics

See the following topics for related information:


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