Employee Citizenship Import Fields

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

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.
Citizenship Type Size: 10 characters Type: Varchar	Citizenship code. If this citizenship code does not match an existing citizenship code in Deltek CRM, 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 CRM, 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 Settings dialog box in Deltek CRM 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.