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 name Description
ColumnName This field is for storing a unique name for either system or Virtual Column in the database
Examples: TrialId (System), GenotypeName (System), OrganisationType (Virtual)
ColumnCaption This 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)
ColumnDescription The full text description for the System or Virtual Column
Examples: Identification Number that uniquely identifies a Trial (System),
The Type of organisation (Virtual)
TableNameOfColumn The name of the table that the system or virtual column is for
Examples: TrialFactor, GenotypeFactor, OrganisationFactor
ColumnDataType The Data type of the System or Virtual Column
Examples: Decimal, String, Integer
CanColumnHaveNull This field specifies if this column is allowed to have null values
Examples: True (It can have null values), False (It cannot have null values)
ColumnValueMinLength The 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
ColumnUnit The unit for the column
Examples: Text, It, Barcode, Count
IsSystemColumn The 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