System and Virtual Columns

Katmandoo stores data using two distinct field types, system columns and virtual columns (factors).

System columns are built into the underlying Katmandoo database structure. Because these fields are defined within the database schema, their data type and length cannot be altered. Their caption, description and validation options can be customised.

Virtual Columns are defined by the user. They allow customisation of sections of the database to fit specific data sets. Virtual columns have the same field options as system columns but allow greater flexibility.

Column Fields

When creating new System and Virtual columns, comes with the following fields

Field nameDescription
ColumnNameThis field is for storing a unique name for either system or Virtual Column in the database
Examples: TrialId (System), GenotypeName (System), OrganisationType (Virtual)
ColumnCaptionThis field is for storing a unique, short descriptive name for either a System or Virtual Column in the database
Examples: Trial Id (System), Geno Name (System), OrgTyp (Virtual)
ColumnDescriptionThe full text description for the System or Virtual Column
Examples: Identification Number that uniquely identifies a Trial (System),
The Type of organisation (Virtual)
TableNameOfColumnThe name of the table that the system or virtual column is for
Examples: TrialFactor, GenotypeFactor, OrganisationFactor
ColumnDataTypeThe Data type of the System or Virtual Column
Examples: Decimal, String, Integer
CanColumnHaveNullThis field specifies if this column is allowed to have null values
Examples: True (It can have null values), False (It cannot have null values)
ColumnValueMinLengthThe minimum length for the value of the column
Examples: 0, 2, 10
ColumnValueMaxLength The maximum length for the value of the column
Examples: 4, 16, 20
ColumnUnitThe unit for the column
Examples: Text, It, Barcode, Count
IsSystemColumnThe field in the database that specifies whether or not the column is a system or virtual column
Examples: True (It is a System Column), False (It is a virtual column)

For help on the basic functions surrounding the columns’ page, here are some links below

Searching for Columns
This link will give instructions on all the functions and tools that appear on the search page


Adding and Editing Columns
This link has all the information needed on how data can be added in Katmandoo V3


Importing Columns
This link will go to the help page that details how to import large amounts of data in the Database.


Exporting Columns
This link will go to the export page with all the information surrounding the Export pop-up and all of its functions


Deleting Data
This link will go to the help page that details how a piece of data
can be deleted from the database