Updating Column Properties

Column properties are classified as technical and business properties. You can update these properties for a column and use user defined fields to enter additional properties of a column.

To update Column Properties, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager > Explore.
  2. On the Explore tab, click an environment tile to view its details and tables.
  3. In the Data Catalog pane, click a table to see its columns.
  4. In the Data Catalog pane, click a column.
    By default, the Properties tab opens and displays the column properties.

  5. Click Options.
    The available options appear.
  6. Click Edit Column.
    The Edit Column Form appears.
  7. Enter appropriate values in the fields. Fields marked with a red asterisk are mandatory. Refer to the following table for field descriptions.

    8. Field Name

    Sub-Field

    Description

    Technical Properties

    Name

    Specifies the physical name of the column.

    For example, Object_ID.

    Data Type

    Specifies the physical data type of the column.

    For example, varchar.

    Data Domain

    Specifies the data domain values for the column.

    For example, data domain of a Gender column is M and F.

    Storage Type

    Specifies the storage type of the column.

    For example, row store/column store in the case of SAP systems.

    Precision

    Specifies the precision of the column.

    For example: 5, the number 123.45 has a precision of 5 and a scale of 2.

    Length

    Specifies the physical length of the column.

    For example, if the column datatype is char(5), then its physical length is 5.

    DB Default Value

    Specifies the default value of the column in the database.

    For example, True.

    Scale

    Specifies the physical scale of the column.

    For example: The number 123.45 has a precision of 5 and a scale of 2.

    Percent Null Value

    Specifies the percentage of null values in the column.

    For example, 10%.

    Maximum Value

    Specifies the maximum value of the column.

    For example, maximum value of ID column can be 1503.

    Minimum Value

    Specifies the minimum value of the column.

    For example, minimum value of ID column can be 424.

    File Starting Position

    Specifies the starting position in the file.

    Attribute Type

    Specifies the attribute type of the column. It is autopopulated with ENTITY_ELEMENT.

    ETL Default Value

    Specifies the default ETL value of the column during the load process.

    Business Details

    Logical Name

    Specifies the logical name of the column.

    For example, if the physical name of the table is CUST_ID_NUM, then the logical name of the table is Customer Identification Number.

    Definition

    Specifies the definition of the column.

    For example: The column is a primary key that allows 5 alpha-numeric characters.

    Expanded Logical Name

    Specifies the expanded logical name of the column.

    For example, if the physical name of the column is Resource_ID, then the logical name of the .

    You can also configure expanded logical name of columns in bulk at system and environment level.

    Comments

    Specifies the comments about the column.

    For example: The column provides unique identification of employee in the employee table.

    JSON Physical Column Name

    Specifies the JSON physical name of the column if the column is in a JSON environment.

    For example, objectID.

    Class

    Specifies the column class property.

    Select a column class. For more information on configuring column class, refer to the Configuring Table and Column Class topic.

    Column Alias

    Specifies the alias name of the column.

    For example, Resource_ID.

    Keys & Flags

    Primary Key Flag

    Specifies whether the column is a primary key.

    Select the check box if the column is used as the primary key.

    Identity Flag

    Specifies whether the column is used as an identity flag.

    Select the check box if the column is used as an identity flag.

    Business Key Flag

    Specifies whether the column is a business key.

    Select the check box if the column is a business key.

    Foreign Key Flag

    Specifies whether the column is a foreign key.

    Select the check box if the column is a foreign key and appears next to this option.

    Click to add the following:

    • Foreign Key Table Name: Specifies the actual table name where the column is listed as a PK (in case of the current column being an FK).

    • Foreign Key Column Name: Specifies the actual column name where the column is listed as a PK (in case the current column being an FK).

    Natural Key Flag

    Specifies whether the column is a natural key. Select the check box if the column is a natural key.

    Nullable Flag

    Specifies whether the column allows null values.

    Select the check box if the column allows null values.

    Used in Gap Analysis

    Specifies whether the column is being used in a gap analysis for usage in mappings.

    Select the check box if the column is used in the gap analysis.

    For more information on performing column gap analysis, refer to the Performing Column Gap Analysis topic.

    Governance Responsibilities

    Data Steward

    Specifies the data steward responsible for the column.

    For example, Jane Doe.

    Users assigned with the Legacy Data Steward role appear as drop down options. You can assign this role to a user in the Resource Manager.

    To assign data steward, select a data steward from the drop down options. For more information on assigning roles and users, refer to the Updating Data Governance Assignments topic.

    Classification

    Sensitive Data Indicator (SDI) Classification

    Specifies the SDI classification of the column.

    For example, PHI.

    For more information on configuring SDI classifications, refer to the Configuring Sensitive Data Indicator Classifications topic.

    Sensitive Data Indicator (SDI) Description

    Specifies the description of the SDI classification.

    For example: Protected Health Information.

    The field autopopulates based on the SDI classification.

    Miscellaneous

    Tags

    Specifies tags of the column.

    For example, PII.

    Click Tags and select an existing tag or enter a tag name to create one on the fly.
  8. Click .

    9. The column properties are updated.

    You can use user defined fields with different UI labels. For more information on using UI labels for user defined fields, refer to the Configuring Language Settings topic.

    You can also hide user defined fields on the Column Properties tab. For more information on hiding user defined fields, refer to the Displaying User Defined Fields topic.