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

Trait and Alias

Overview

A trait in Katmandoo is a numeric or alpha-numeric characteristic of the sampling unit that is recorded and stored against the appropriate design and treatment factors for an experiment. For example, traits in varietal testing regimes might include plant responses such as grain yield, plant height, disease resistance, seed colour etc.

Click here for more information on Statistical Data Structure.

Click here for trait dictionary.

Click here for more information on validation rule of Trait.

Detail

Following information of Traits are stored in the Trait table of the database. 
  1. Trait Name
  2. Trait Caption
  3. Trait Description
  4. Data type
  5. Size of the Trait Value
  6. Unit of the Trait 
The validation rules and validation error message of the Trait (Factor) are stored in the the "FactorSubSystem" table of the database.

Trait Name

Trait name of a Trait can not be modified once it has dependant data.

Trait 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 ]

Trait Caption

In the User Iterface (ie forms), Trait captions are displayed in stead of Trait name.

Trait caption 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
  4. Must not be a reserved keyword [ Task > System > Manage Reserved Keywords ]

Trait Description

The description of the Trait or factor has following constraints:
  1. Must have at least 2 characters and can have upto 255 characters
  2. Can have any characters other than specified in the "Invalid Character for string Alternate Key (AK) value [ System > Manage Sub-system ]

Trait Data type

These are the data types that can be used for the Trait.
Data Type Example
String (Alpha numeric) XYZ123, 56MX-12
Integer 1234
Decimal 1234.21, 0.123

Click here to find minimum and maximum size of each of the above data type.

Size of the Trait Value

Size (Trait name in the database if FactorValueMaxLength) of the Trait value defines the maximum number of characters / digit that the Trait value can have.
Data Type Max Character / Digit
String (Alpha numeric) Maximum size for a string (text) Trait is 255 characters.

Example:
To store "DARK KHAKI" value for "Color" trait, the size of the Trait Value should be 10.
Integer Maximum digit for a Integer Trait is 10 but not exceeding values from negative 2,147,483,648 to positive 2,147,483,647
Decimal (upto 6 decimal places) Maximum digit for a Decimal Trait is 38 including precision, scale and decimal of the value (but not exceeding values from negative 79,228,162,514,264,337,593,543,950,335 to positive 79,228,162,514,264,337,593,543,950,335).

Example:
To store 12345.123456, the size of the Trait value should be 12.

Unit of the Trait

Identifies unit of the Trait. If not available, use NA.

Table Structure

Trait Name Description
TraitId (PK) Identification Number that uniquely identify a Trait

This is an Integer Auto Number and is generated by the database automatically.
TraitName (AK) Name that uniquely identifies a Trait

Main Form

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

Setup Form

To add/edit a Trait, follow the steps below :
Illustrative snapshot:
Setup Form of Trait (Click it to change its size)
  1. Trait Name. It can not be changed once the trait has any data.
  2. Trait Caption. It will be disabled if the Trait has any data. Click here for information on editing restricted value.
  3. Trait Description. It will be disabled if the Trait has any data. Click here for information on editing restricted value.
  4. Trait Data Type. It will be disabled if the Trait has any data. Click here for information on editing restricted value.
  5. Text size of the Trait value. It will be disabled if the Trait has any data. Click here for information on editing restricted value. 
  6. Unit of the Trait. It will be disabled if the Trait has any data. Click here for information on editing restricted value. 
  7. Tick it if the trait can be used for analysis.
  8. This option is enabled while adding new Trait only and when ticked, empty validation rule for each Sub-systems are added so that the Trait 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 Trait

A trait alias is an alternate name that can be used to represent the trait. A trait can have one or more aliases but an alias is always associated with a trait.

Alias is used while importing trait value to map trait names used in the spreadsheet with the trait names used in the database when the spreadsheet uses trait name that is not trait name in the database.

A trait can have one or more aliases but an alias is always associated with only one trait.

Merge Trait

To merge data of a trait into another trait, use [ Record > Merge Trait ] in the  Trait main form.
Illustrative snapshot:
Merge Trait
  1. Read this important note!
  2. Master Trait is the one that will hold data of the Slave Trait.
  3. Master TraitId replaces all the Slave TraitIds in the database.
  4. Slave Trait is saved as an alias of Master Trait.
  5. Slave TraitId.
  6. Conditions when Merge Trait can not be used.
  7. Authorised token.
  8. User must enter the exact authorised token (case-sensitive) to merge data.
    • Tips: Copy the token to a text file. Next time, copy the token from the text file and pasting here.
  9. After carefully entering all the required information, click [ Merge... ] button. 
IMPORTANT NOTE: 

Export / Import

Export
Import

See Also

  1. How to import traits?
  2. How to modify existing Traits?
  3. How to set different validation rules of a trait for different Sub-system?
  4. Import Trait and Validation Rule