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
|
