The Raw data (Sample measurement) table stores the measured data for an individual
trial unit (
sampling
unit) for a given sample type and variate..
Raw data (sample measurement) can be changed (or updated)
by using the Import Raw data only (ie
there is NOT any Raw data Setup Form). Click here
for instruction on deleting Raw data.
Trait Instance Number
Trait Instance Number identifies the instances of the raw data taken in a trial
unit. It can have up to 16 alpha-numeric characters.
Trait Recorded Date
It is the date when the trait value (raw data) is recorded.
Operator
Operator is the person (ie
Contact) who recorded
the Raw data.
While importing raw data, if the source file does not have
Operator Name column or has empty (null) value for the
Operator Name column, then
contact info of the
logged-in user is used as operator.
Use [ Task > Quick Search > Contact Name @ Location
] to list all the (potential) operators in the database.
Though the raw data datagrid in the Trial Design Main Form displays data in the
simple term, underneath the presentation there are three tables: Variate, Variate
Operator and Raw data. Table structure shown below is simplified to make easily
understandable.
Sample Measurement
Table
|
Column Name |
Description |
|
TrialUnitId (PK) |
Id that identifies the Trial Unit of the raw data. |
|
SampleTypeId (PK) |
Id that identifies the Sample Type of the raw data. |
|
TraitId (PK) |
Id that identifies a Trait. |
|
TraitInstanceNumber (PK) |
Instance is number of occurance of the Trait for a trial in a day. |
|
OperatorId (PK) |
Id that identifies the operator (ie Contact). |
|
TraitRecordedDate (PK) |
Date when the Trait was recorded. |
|
TraitValue |
Trait Value??? |
- Variate tab in the data
Dictionary has detailed information on the columuns used in Variate and Variate
Operator tables.
The following information must exist before a Contact can be added into the database.
- Trial Unit: Trial Unit of the trial design
of the trial must exist in the database before the raw data can be added.
- Trait: The trait information of the raw data
must exist in the database before the raw data can be added.
- Sample Type: Sample type of the raw data must exist
in the SampleType table. If the design type information is
not available, then Unknown Sample
Typ should be used.
- Contact: The
operator name must exist in the Contact table. If the operator information is
not available, then
Unknown Contact should be used.
Note: Although Unknown Sample Type and Unknown Contact
can be used it is preferable to add the Sample Type and Contact before adding a
new raw data. This avoids changing at a later date.
Raw data are displayed in the
Raw
data datagrid of the
Trial Design Main Form.
Raw data Menu
Raw data menu can be accessed from either [ Record ] menu of the
Trial Design Main Form or from the tool bar of the
Trial Main Form.
- Export Raw data
- Import Raw data
- Delete Raw data
Illustrative snapshot of Raw data menu
in Trial Main Form:
- Export Raw data
- Import Raw data
Use [ Record > Raw data > Delete Raw data ] in
Trial Design Main Form to delete the Raw data of a trial permanently
from the database.
Important Note:
Delete Raw data is disabled once the Trial
AOV of the trial is added in the database.
- Trial information of the selected trial unit.
- Selected option (default) to delete raw data of the selected Trait Instance Number
and Sample Type.
- Tick one Trait Instance
Number .
- Select a Sample type.
- Use the buttons in the Dual-List
to add the Trait in the [ Included Traits ]. Raw
data of the [ Included Traits ] only for the selected trial are PERMANENTLY
deleted from the database.
- This option allows to delete all the raw data of the
selected traits (5) of the selected trial. But it is available to the
System Administrators only.
- Authorisation token to enter in (8)
- Enter exact authorisation token as shown in (7)
- Click it to PERMANENTLY delete the raw data of selected trial for the selected
traits (2), Trait
Intance Numbers (4) and Sample type (5).
