You use Code Tables to populate drop-down lists with standard values for certain Info Center fields. These lists of values save time during routine data entry and enforce uniformity in data fields. You can add new, edit, and delete entries at any time. You can add an unlimited number of entries to any code table.
For example, for the
Employee Role field on the
Projects tab of Employee Info Center, you can use this table to define the roles that your employees may have on
projects, such as Architect,
Project Manager, and
Supervisor.
The
Client Role, Contact Role, and Employee Role code tables have pre-populated or system entries and their entries cannot be deleted.
Recommendations
Deltek recommends that you set standards for each of the code tables and populate the tables before you enter data in the Info Centers. For example, if you decide that your educational degrees will use the format B.A. and M.A. (as opposed to BA or Bachelor of Arts), populate the Degree code tables with all possible degrees in the appropriate format.
Types of Code Tables
There are three types of code tables in
Vision:
- One type of code table dynamically updates all existing records that are associated with that respective code to reflect the new description.
- The second type is a table with a list of only Descriptions, such as
Client Relationship, Employee Title, and Suffix Tables. If you change a code, only the values for future lookups are affected; no changes are made to existing records.
- The last type of code table allows you to remove the selection of the
Active check box so that the code is not a choice for future selections. Existing records in your database associated with a code that is not active remain unchanged. New records cannot be associated with this code, since it is not active. This preserves older records' characteristics that you do not want to use in new records.
Code Tables and Multiple Languages
If you use multiple languages with
Vision, the standard code tables display in the selected language. If you insert your own codes, you must translate the code and manually enter it in the Code Table Maintenance form. If you do not translate the custom code,
Vision displays
Text Not Translated as the description for this code.