Associating Codesets With Reference Tables

You can associate codesets with columns of a reference table. Codesets can be used as configurable pick lists so that data can be selected from the drop-down.

To associate codesets with columns of reference tables, follow these steps:

  1. Go to Application Menu > Data Catalog > Reference Data Manager.
  2. Under the Workspace pane, expand the desired reference folder.
  3. Expand the Reference Tables node and right-click the reference table to be associated.
  4. Click Associate Codesets.

    5. The Associate Codeset page appears.

  5. Double-click the cell against the column to be associated and select the appropriate codeset.

    6. For more information on codesets, refer to the Maintaining Enterprise Codesets section.

  6. Click .

    7. The codeset is associated with the column of the reference table.

    The corresponding column in the reference table is now configured as a drop-down and populated with values from the selected codeset.

    Note: Ensure that you are in edit mode.