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

Unit Position of Trial Unit

Overview

The unit position virtual column(s) are those design factors that uniquely locate the experimental unit in time and/or space.
Different type of trial uses different Unit Position name and value to identify a trial unit in a trial design. Since Katmandoo is designed to accomodate Bioscience trial data, it is designed to generate Unit Position dynamically using the virtual column defined for the UnitPositionFactor table.

Before a Unit Position record must exist in the UnitPosition table before a unit position can be used in any trial design.

Detail

The column name of Unit Position must be added in the database as a Virtual Column before a Unit Position record can be created. 

Unit Position Text

Unit Position Text uniquely identifies a unit position in the Unit Position table and it is generated by system using the Unit Position Virtual Column and its value as shown in the example below. So, the Unit Position Text or value of the Unit Position Virtual Column can not be modified.

Unit Position Text Unit Position Virtual Column and its value Can be From...
Range1|Row2 Range = 1 and Row = 2 Plant Agronomy Trial
Cage5|Row2 Cage = 5 and Row = 2 Pig Trial
MaltRun2|Cannister1|Partition1 Malt Run = 2, Cannister = 1 and Partition = 1 Barley Malting
MillDay3|MillingSequence40 Mill Day = 3 and Milling Dequence = 40 Wheat Milling
Flask1 Flask = 1 Hot Water Extraction
Plot_IdA1|Tree1 Plot_Id = A1 and Tree 1 Forest Research

In the above example following are the Unit Position Virtual Columns which must be added in the database before the Unit Position Text can be generated.
There are following two ways to add Unit Position Text in the database.
  1. Use Unit Position Setup Form to bulk insert unit position records using the starting and ending value of the Virtual Column (of the UnitPositionFactor table).
  2. Using Import Trial Design. While importing data, system use the Virtual Column (of the UnitPositionFactor table) and its value to generate the Unit Position Text as shown above and save them into the database.
Once the Unit Position Text are saved in the database, it can be used in the trial design to uniquely identify each trial unit of a trial design. In the Trial Unit Main Form, the Unit Position Text are displayed but [ Record > Export > Export Trial Design ] can be used to view the trial design as it was in the source file.

Unit Position Virtual Column

These are the Virtual Columns of UnitPositionFactor table and are used to generate Unit Position Text that uniquely identifies a record (or row) in the Unit Position Table.

Follow these steps to add a Virtual Column for UnitPositionFactor Table:
  1. [ Task > System > Manage Virtual Column and Alias ] to load Virtual Column Main Form with all the virtual columns in the database.
  2. [ Record > Add Virtual Column ] to load the Virtual Column Setup Form.
  3. Enter name, caption, description of the Virtual Column
  4. Select UnitPositionFactor for Table Name of Virtual Column.
  5. Select Data Type of Virtual Column. Integer is strongly recommended.
  6. Enter a value between 1 and 32 for the Text size of the Virtual Column value.
  7. Leave the Unit of the virtual column blank (empty).
  8. Must uncheck checkbox for Can have Null Value?.
  9. Check the Tickbox to add validation rule for all the Sub-systems.
  10. Then click on [ Save and Exit ].

Table Structure

Column Name Description
UnitPositionId (PK) Identification Number that uniquely identifies a Unit Position.
UnitPositionText (AK) Automatically generated unit position text using the information of the Unit Position Virtual Column.

Pre-requisite

The following information must exist before a Contact can be added into the database.

Main Form

Use [ Task > Trial > Raw Data > Manage Unit Position of Trial Unit ] to load Unit Position Main Form with all the unit positions in the database.
Illustrative snapshot:
Main Form of Unit Position (Click it to change its size)
  1. Unit Position Main Form displaying the Unit Positions at the selected location. 
    • Click here for an illustration of the main form template.
  2. Unit Position subform displays virtual column information of the selected Unit Position in the Unit Position Main Form (Unit Position Text "BlockNo2|ColumnNo2|RowNo2" in the snapshot).

Setup Form

Important Note: The Unit Position records are added while importing trial design, if they already do not exist in the database. So, use this Setup Form to Bulk-insert the Unit Position records for initial setup only.

To add Unit Positions, follow the steps below :
Illustrative snapshot:
Setup Form of Unit Position (Click it to change its size)
  1. Virtual Columns of UnitPositionFactor Table. Click here for instruction on adding Unit Position Virtual Column.
  2. Enter Minimum (ie starting) Value to generate Unit Position Text.
  3. Enter Maximum (ie ending) Value to generate Unit Position Text.
  4. Enter Increment Value to generate Unit Position Text.
When saved, this will generate the Unit Positions as shown in the Unit Position Main Form (see the selected row).

Export / Import

Export
Import

See Also