Adding a Reference Code Table

Codes and predefined information used in AASHTOWare Project can be stored in database code tables. Information stored in code tables is used to create entity records such as projects and proposals (for example, the values used for units of measure such as kilometer or pound). Entity record values can be changed, but the reference code table values are usually maintained by the agency and rarely deleted.

To create a code table, select Add from the Actions menu on the Code Tables component header. Enter information in these fields:

A blank row for adding a value to the new code table is already displayed. Press the Tab key to advance through the fields, adding information and new rows as needed (or click the New button). For more information, see Adding Code Table Values.

For information on how to associate fields to the newly added code table, see Customizing Validation Rules.

Note: For compatibility with BAMS/DSS, the first seven characters of a code table name must be unique, and the seventh character cannot be a number.

Caution: If you create a custom code table called COUNTY (with any casing, for example, County, COUNTY, or CoUnTy), the values in that table will not be included in exports of reference data to SAPW, CAS, Cost Estimation, and SiteManager.

When you have finished adding information, save the new reference code table to the system by clicking the Save button. The system displays a message to confirm that your changes were saved in the database.