Employee Education Import Fields

You can import employee education data into the Deltek 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.

Location of the Employee Import Utilities

How you import employee data depends on the Deltek modules your company has activated:

• If either the Accounting module or the CRM+ module is activated, use the Data Import utility in the desktop application (Utilities > Utilities > Data Import).
• If the Resource Planning module is activated but neither the Accounting module nor the CRM+ module is activated, use the employee data import options on the Imports tab of the Integrations & Imports form in the browser application (Utilities > Integrations & Imports).
• If the CRM module is the only activated module, use the employee data import options on the Imports tab of the Integrations & Imports form in the browser application (Utilities > Integrations & Imports).

Contents

Field	Description/Notes
Employee Number Size: 20 characters Type: Varchar	(Required) An employee with a matching employee number must already exist in Deltek.
Degree Size: 10 characters Type: Varchar	Degree code. If the degree code does not match an existing degree code in Deltek, 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.