Create Code Tables

When you create an attribute category and select “Code table” as the data type, you must select a code table to use as the source of the attribute. If a code table with the desired attributes does not exist in the program, you can create a code table from the Add attribute category screen.

  1. On the Add attribute category screen, select “Code table” in the Data type field. The program enables the Code table field.

  2. In the Code table field, select New. The Add a code table screen appears.

  3. In the Name field, enter a name for the code table in the program. This is the name that appears on the Code Tables page in Administration.

  4. In the DB table name field, enter a name for the code table in the database schema. This is the name you use to reference the code table in SQL.

    Note: The database table name can be up to 30 characters. It can start with a capital letter from “A” to “Z,” followed by one or more uppercase letters or numerals and ending with “CODE.” To designate the table as a code table, it must end with “CODE.” For example, the database table name for the Alias Type code table in the program is ALIASTYPECODE.

  5. In the Category field, select a category for the code table. The Code Tables page in Administration organizes code tables by category for easier viewing. If the category does not exist, select Add a code table category and you can create the new category.

  6. In the Sort type field, select how to organize the entries in the code table.

  7. In the Description field, enter a description of the code table.

  8. Select Save. You return to the Add attribute category screen.