Creating code tables using the model editor

To create code tables using the model editor, take the following steps:

Procedure

  1. Right-click the folder where you want to define the code table, and select New > Code table
  2. Edit the properties of the code table:
    • Name: The name of the code table.
    • Documentation: An optional description of the code table.
    • Documentation URL: An optional URL that links to documentation for the code table.
    • Database table name: This defaults to a name derived from the code table name. For example, if the code table name was MaritalStatus, the default database table name would be CDMARITALSTATUSTP.

    By default, code tables have a primary key attribute named tp_cd and a name attribute.

  3. Expand the Code Table node in the editor and click these attributes to modify the field and database column names.