Reference Data Guide > Reference Tables in the Analyst Tool > Reference Table Properties
  

Reference Table Properties

You can view and update reference table properties in the Analyst tool. A reference table displays general properties and column properties. The general properties include the reference table name, creation date, database connection name, and valid column name. The column properties include the column names, precision values, and scale values.
You can view the properties in read-only mode. To update the properties, edit or check out the reference table.

Reference Table General Properties

The general properties contain information about the reference table object.
The following table describes the general properties:
Property
Description
Name
The reference table name.
Description
Any description that a user entered for the reference table.
Location
The location of the reference table object in the Model repository.
Valid Column
The name of the valid column in the reference table.
Created On
The creation date and time for the reference table name.
Created By
The login name of the user who created the reference table.
Last Modified
The date and time of the most recent update to the reference table.
Last Modified By
The login name of the user who made the most recent update.
Connection Name
The connection name for the database that stores the reference data values.
Type
The reference table type. The reference table can be managed or unmanaged.

Reference Table Column Properties

The column properties contain information about the column metadata.
The following table describes the column properties:
Property
Description
Name
The column name.
Datatype
The data type for the data in each column. You can select one of the following data types:
  • - bigint
  • - date/time
  • - decimal
  • - double
  • - integer
  • - string
You cannot select a double data type when you create an empty reference table or create a reference table from a flat file.
Precision
The precision for each column. Precision is the maximum number of digits or the maximum number of characters that the column can accommodate.
The precision values you configure depend on the data type.
Scale
The scale for each column. Scale is the maximum number of digits that a column can accommodate to the right of the decimal point. Applies to decimal columns.
The scale values you configure depend on the data type.
Description
An optional description for each column.
Nullable
Indicates if the column can contain null values.
Key
Identifies a key column. The Analyst tool can identify a key column if you import the reference data from a table that specifies a key column.