Employee Skills Import Fields

You can import employee skills data into the Deltek database.

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.

If this field is blank or the employee number does not exist, the record is not imported and an error message displays.

Skill

Size: 10 characters

Type: Varchar

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

Skill Level

Size: See notes.

Type: Smallint

Skill level code. If the skill level code does not match an existing skill level code in Deltek, the record is imported without the skill level code, and a warning displays. Valid values: 0 - 32767.

Skill Usage

Size: See notes.

Type: Smallint

Skill usage code. If the skill usage code does not match an existing skill usage code in Deltek, the record is imported without the skill usage code, and a warning displays. Valid values: 0 - 32767.