Employee Citizenship Import Fields
You can import employee citizenship data into the Deltek database.
If you later need to import updated employee citizenship 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
- If either the Accounting module or the CRM+ module is activated, use the Data Import utility in the desktop application ().
- 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 ().
- 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 ().
Contents
| Field | Description/Notes |
|---|---|
|
Employee Number Size: 20 characters Type: Varchar |
(Required)
An employee with a matching employee number must already exist in Deltek. |
|
Citizenship Type Size: 10 characters Type: Varchar |
Citizenship code. If this citizenship code does not match an existing citizenship code in Deltek, the record is imported without the citizenship code, and a warning displays. |
|
Country Size: 2 characters Type: Varchar |
Country code. If the country code does not match an existing country code in Deltek, the record is imported without the country code, and a warning displays. |
|
Expiration Date Type: Datetime |
These dates must be in YYYY-MM-DD format or in the date format that is specified in the My Preferences dialog box in Deltek at the time you run the import process. |
|
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. |