Home | Using Katmandoo | Quick Start Guide | How-to | Task Menu | Table of Contents | See Also | Collapse All

Virtual Column and Alias

Overview

The virtual column is an attribute of a table but (as name suggested) is not part of the database structure which enables system administrator to add or remove any virtual column.

Detail

Following information of virtual column are stored in the Factor table of the database. Click here for Factor table structure.
The validation rules and validation error message of the virtual column are stored in the the FactorSubSystem table of the database.

Virtual Column Name

Column name of a virtual column can be modified if the column does not have dependant data. Click here for information on virtual column naming convention.

Column name has following constraints:
  1. Must have at least 2 characters and can have upto 64 characters
  2. Can have any characters other than specified in the "Invalid Character for string Alternate Key (AK) value [ System > Manage Sub-system ]
  3. Must be unique among Trait Name, Trait Alias, Column Name, Column Alias, Virtual Column Name and Column Alias.
  4. Must not be a reserved keyword [ Task > System > Manage Reserved Keywords ]

Virtual Column Caption

Click here for more information on Column Caption.

Virtual Column Description

Click here for more information on Column Description.

Virtual data type

Click here for more information on data Type.

Table Name of Virtual Column Name

The table name must be one of the table name for virtual column.

Size of the Column Value (Virtual Column Value Text Size)

Click here for more information on Size of the column value.

Unit of the Virtual Column

Unit of the virtual column data (if available) but it is optional.

Can have Null value

Set it true if the virtual column can have null (empty or blank) value. Set it false to force user to enter value of the virtual column.

Table Structure

Column Name Description
FactorId (PK) Identification Number to uniquely identify a Factor that can be a column or (or virtual column)
FactorName (AK1) Name of the column (or virtual column)
FactorCaption (AK2) Short descriptive Name of the column (or virtual column)

Main Form

Use [ Task > System > Manage Virtual Column and Alias ] to load Virtual Column Main Form with all the virtual columns in the database.
Illustrative snapshot:
Main Form of Virtual Column (Click it to change its size)
  1. Virtual Column Main Form displaying the virtual columns. 
    • Click here for an illustration of the main form template.
  2. Virtual Column Validation Rule form displaying the validation rules for each Sub-system in which the virtual column can be used.
  3. Alias of the selected Virtual Column (ie August Rain in the snapshot).

Setup Form

To add/edit a Virtual Column, follow the steps below :
Illustrative snapshot:
Setup Form of Virtual Column (Click it to change its size)
  1. Virtual Column Name. It can not be changed once the virtual column has any data.
  2. Virtual Column Caption. It will be disabled if the virtual column has any data. Click here for information on editing restricted value.
  3. Virtual Column Description. It will be disabled if the virtual column has any data. Click here for information on editing restricted value.
  4. Table name of the virtual column. It can not be changed once the virtual column has any data.
  5. Virtual Column data Type. It will be disabled if the virtual column has any data. Click here for information on editing restricted value.
  6. Text size of the Virtual Column value and Unit of the virtual column. It will be disabled if the virtual column has any data. Click here for information on editing restricted value. 
  7. Tick it if the virtual column can have null value.
  8. This option is enabled while adding new Virtual Column only and when ticked, empty validation rule for each Sub-systems are added so that the Virtual Column can be used in all the Sub-systems that exist in the database (ie for the new Sub-system added later, the validation rule either needs to be copied from another Sub-system or added manually.

Alias of the Virtual Column

Click here for more information on Alias.

Use [ Record > Update Virtual Column Alias ] to add or edit alias of the column selected in the virtual column main form.

Export / Import

Export
Import

See Also