Employee Education Import Fields

You can import employee education data into the Deltek CRM database.

If you need to import updated employee education information, Deltek recommends that you use the Delete existing records and import option, not the Update duplicate records option.

Contents

Field Description/Notes

Employee Number

Size: 20 characters

Type: Varchar

(Required)

An employee with a matching employee number must already exist in Deltek CRM.

Degree

Size: 10 characters

Type: Varchar

Degree code. If the degree code does not match an existing degree code in Deltek CRM, the record is imported without the degree code, and a warning displays.

Institution

Size: 60 characters

Type: Varchar

College, university, or other institution name.

Specialty

Size: 60 characters

Type: Varchar

Major or other specific area of study.

Year Earned

Type: Smallint

Graduation year.

RecordID

Size: 32 characters

Type: Varchar

This field only applies if you use the API to import data.

Sequence

Size: See notes.

Type: Smallint

This field only applies if you use the API to import data. Valid values: 0 - 32767.