Lists Import Fields

You can import lists of standard values for fields that have drop-down lists for selecting entries.

Generally, these lists contain attributes that you want to assign to employees, projects, opportunities, and so on. For example, you can create a standard list of employee skills that you want to track for resource planning purposes. You can then associate specific skills from that list with the employees who possess those skills, and search for and select employees to work on projects based on their skills.

Contents

Field	Description/Notes
Code Table Type Size: See notes Type: varchar	(Required) The code for the type of the list to which you want to add the list value. For example, to import a new item for the employee education list, set this field value to EMDegree. Valid entries are the following: Citizenship: List of descriptions of employee citizenship status. Citizenship: List of descriptions of employee citizenship status. EMDegree: List of levels and types of employee education. EMRegistration: List of licenses, accreditations, and other professional credentials for employees. EMRegistrationType: List of types of credentials. The types are used to categorize credentials on employee cards. LaborCategory: List general labor classifications for employees (for example, Principal or Project Manager). EMLocation: List of employee locations. EMSkill: List of employee skills, knowledge, or expertise. EMSkillLevel: List of employee skill levels. EMSkillUsage: List of skill usage values (how long an employee has been employing the skill). CFGProjectType: List of project types (for example, Engineering, Architecture, Construction) Suffix: List suffixes that are added at the end of employee names (for example, Jr. or Sr.). State: List of states and provinces. Deltek comes with the states in the United States already in the database.
Code Size: See notes Type: See notes	(Required) The identifier for the list item. This value must be unique within the list to which it belongs. In most cases, the associated description, not this code, is what displays in the Deltek user interface. Use this field to specify the following: Citizenship codes (12 characters) Country codes (8 characters). Deltek comes with a default list of countries. The country codes used in the default list are the ISO Alpha-2 codes. Degree codes (20 characters) Credential codes (20 characters) Credential type codes (10 characters) Labor category codes (10 characters) Location codes (10 characters) Project type codes (10 characters) Skill codes (10 characters) Skill level codes (Smallint: 0 - 32767) Skill usage codes (Smallint: 0 - 32767) Suffix codes (20 Characters) State/province codes (20 characters). Deltek comes with the U.S. states in the default list. The state codes in the default list are the standard 2-character postal codes.
Description Size: 50 characters Type: varchar	(Required) The description or name for the list item that you want to appear when the list item displays in the Deltek user interface.
Country Code Size: 2 characters Type: Varchar	When you import values for the state/province list (Code Table Type: State), you must map a country code field in the .CSV file to this field to identify the country in which the state or province is located. Those country codes must already exist in Deltek. The country codes used in the default list are the ISO Alpha-2 codes.