Create a code table
|
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, click 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, click 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.
|
Click Save. You return to the Add attribute category screen. |