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.
- Click here for data
dictionary.
- Click here for more information on validation
rule of virtual column.
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:
- Must have at least 2 characters and can have upto 64 characters
- Can have any characters other than specified in the "Invalid
Character for string Alternate Key (AK) value [ System > Manage Sub-system
]
- Must be unique among Trait Name, Trait Alias, Column Name, Column Alias, Virtual
Column Name and Column Alias.
- 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.
Use [
Task > System >
Manage Virtual Column and Alias ] to load Virtual Column Main Form with all the
virtual columns in the database.
Illustrative snapshot:
- Virtual Column Main Form displaying the virtual columns.
- Click here for
an illustration of the main form template.
- Virtual Column Validation Rule form displaying
the validation rules for each Sub-system in which the virtual column can be used.
- Alias of the selected Virtual Column
(ie August Rain in the snapshot).
To add/edit a Virtual Column, follow the steps below :
- Select a Virtual Column in the virtual column main form to
modify.
- Use [ Record > Add Virtual Column ] or [ Record > Edit Virtual
Column ] or [ Record > Repeat Virtual Column ] to load the Virtual
Column Setup Form to add/edit a Virtual Column.
- Click here
for an illustration of the setup form template.
Illustrative snapshot:
- Virtual Column Name. It can not be changed once the
virtual column has any data.
- Virtual Column Caption. It will be disabled
if the virtual column has any data. Click
here for information on editing restricted value.
- Virtual Column Description. It will
be disabled if the virtual column has any data. Click
here for information on editing restricted value.
- Table name
of the virtual column. It can not be changed once the virtual column has any
data.
- Virtual Column data Type. It will be disabled
if the virtual column has any data. Click
here for information on editing restricted value.
- 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.
- Tick it if the virtual column can have null value.
- 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.
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.