Action Buttons

Icon	Action	Description
	Add	Add will open an Add Column Dialog for creating a new Column and assign it to the current entity. When adding an Column via this button Connection and Object will be pre-filled on the created dialog box.
	Save	This will save the currently set of staged changes. The Save button is only enabled if the Column has changes staged and there are no major validation issues with the current Column properties.
	Archive	This will hard delete the selected Attribute. This will result in the physical removal of the selected record from the metadata database. The data will no longer be accessible by the BimlFlex Applicationand will require a Database Administrator to restore.	Archive Column
	Refresh	This will trigger a refresh of the metadata for the selected Columns.
	Integration Key	This will bring up the dialog to create an Integration Key.	Generate Derived Integration Key

Additional Dialogs

Add Column Dialog

Creates a Column and associates it with the current entity. Once entry is finished ensure that the Save button is clicked.

Archive Column Dialog

Confirmation box warning against the dangers of archiving. You are required to confirm by both the check box and the Ok button.

Warning

Archiving is a permanent removal of the selected entity from its associated table in the BimlFlex Database. The best practice is to first use the Deleted flag (soft delete) as an indication that the connection may need to be removed.

Generate Derived Integration Key Dialog

The Generate Derived Integration Key dialog will allow you to quickly generate an Integration Key. The selected Columns from the prior screen should already be selected and a Column Name is automatically populated based on the associated Objects Model Override Name or, if that is empty, the Object Name. The "_BK" suffix can be controlled with the Setting AppendIntegrationKey.

Generate Derived Integration Key Options

Option	Description
Add Record Source	This will prefix the @@rs to the Column Expression. @@rs will generate the value currently assigned to Record Source on the associated Connection.
Is Integration Key	This will flag the generated Column to become the Integration Key for the associated Object. Once selected it will automatically update Column Ordinal to "0" and also Is Primary Key to true.
Is Primary Key	This will flag the generated Column as a Primary Key for the associated Object.

Columns Tab Views

All Columns assigned to the current entity show here. New items can be entered entered via the Add action button. Existing items can be edited by double clicking the field needing adjustment. All the views have the same links to the Column.

Navigational Transitions

Item	Action	Entity Documentation
Column Value	Navigate to Column Editor, selecting clicked Column	Column Documentation

Overview

The Overview is available to give quick access to the more physical properties of the Columns relating to the selected entity. These are representations of the physical Source System and represent the raw definitions of the object in it's original form. Quick access is also provided for the various keys used across the separate Integration Layers or Integration Stages.

Settings

The Settings view allows for quick access to all the Boolean and flag properties associated with the Columns. In addition to the keys the ability to flag database concepts (such as IDENTITY or NULL), persistence, whether or not the Column is Derived, and the ability to flag as Excluded or Deleted.

Expressions

The Expressions view allows you to quickly view and manage all the expressions that may be used in the CAST, CONVERT, or general transformations that may be performed on any given Column. All values in this view are used to determine the ETL/ELT logic and transformation dataflow.

Mappings

The Mappings view shows the references and targets associated with the Columns. References are the equivalent of a Foreign Key in a Relational Database, though the enforcement of an actual constraint is configurable. References control how and where other tables relate to each other. Targets are the the Object and Column that the entity will populate in the associated Project's Target Connection. It is recommended that you use the Data Vault Accelerator or the Schema Diagram to populate these fields. This view is intended as easy way to reference and maintain previously entered metadata.

Overrides

The Overrides view is available to allow for quick management of modeled metadata from the Data Vault Accelerator or the Schema Diagram. This view is intended as easy way to reference and maintain previously entered metadata.