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.
Following information of Traits are stored in the
Trait table of the database.
- Trait Name
- Trait Caption
- Trait Description
- Data type
- Size of the Trait Value
- 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:
- 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 ]
Trait Caption
In the User Iterface (ie forms), Trait captions are displayed in stead of
Trait name.
Trait caption 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
- Must not be a reserved keyword [ Task > System
> Manage Reserved Keywords ]
Trait Description
The description of the Trait or factor has following constraints:
- Must have at least 2 characters and can have upto 255 characters
- 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.
Use [
Task > System >
Manage Trait and Alias ] to load Trait Main Form with all the Traits in
the database.
Illustrative snapshot:
- Trait Main Form displaying the Traits (in the snapshot
Drought Severity trait is selected).
- Click here for
an illustration of the main form template.
- Trait Validation Rule form displaying the
validation rules for each Sub-system in which the virtual column can be used.
- Alias of the selected Trait Column (ie Drought_Severity in the snapshot).
To add/edit a Trait, follow the steps below :
- Select a Trait in the Trait main form.
- Use [ Record > Add Trait ] or [ Record > Edit Trait ] or [ Record > Repeat
Trait ] to load the Trait Setup Form to add/edit a Trait.
- Click here
for an illustration of the setup form template.
Illustrative snapshot:
- Trait Name. It can not be changed once the trait has
any data.
- Trait Caption. It will be disabled if the Trait has
any data. Click
here for information on editing restricted value.
- Trait Description. It will be disabled if
the Trait has any data. Click
here for information on editing restricted value.
- Trait Data Type. It will be disabled if the Trait
has any data. Click
here for information on editing restricted value.
- Text size of the Trait value. It will
be disabled if the Trait has any data. Click
here for information on editing restricted value.
- Unit of the Trait. It will be disabled if the
Trait has any data. Click
here for information on editing restricted value.
- Tick it if the trait can be used for analysis.
- 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.
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.
To merge data of a trait into another trait, use [ Record > Merge Trait ]
in the
Trait main form.
Illustrative snapshot:
- Read this important note!
- Master Trait is the one that will hold data of the Slave Trait.
- Master TraitId replaces all the Slave TraitIds in the database.
- Slave Trait is saved as an alias of Master Trait.
- Slave TraitId.
- Conditions when Merge Trait can not be used.
- Authorised token.
- 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.
- After carefully entering all the required information, click [ Merge... ] button.
IMPORTANT NOTE:
- Validation rule and
other info such as Description etc of the Slave Trait will be discarded.
- THIS PROCESS CAN NOT BE ROLLED-BACK!