Reference Data Guide > Reference Tables in the Analyst Tool > Creating a Reference Table in the Reference Table Editor
  

Creating a Reference Table in the Reference Table Editor

Define the table structure and add data to a reference table in the reference table editor.
    1. Click New > Reference Table.
    The New Reference Table wizard opens.
    2. Select the option to Use the reference table editor, and click Next.
    3. Use the Add New Column option to add columns to the table.
    4. Configure the properties for each column.
    The properties include the column name, data type, precision, and scale.
    If the column contains data that a transformation can return in a reference data search, select the Valid option.
    5. Optionally, add a column to include low-level descriptions as metadata in the reference table.
    6. Optionally, enter an audit note for the table.
    The audit note appears in the audit trail log.
    7. Click Next.
    8. Enter a name for the reference table, and select a location for the reference table object in the Model repository.
    9. Click Finish.