Edit Samples Module

The Edit Samples module allows the user to edit certain defined fields in the SAMPLE table on specific sample types. Edit Samples behaves differently from the other three sample modules in that the database changes cannot be performed from the main window. Instead, clicking on the “GO TO EDIT” button opens a new window where changes are made and then approved and processed to the database (Fig. 17). Unlike the other sample modules, samples at different levels of hierarchy can be operated upon in the same action.

 

Figure 17. Edit Sample Entry Screen.

In the edit entry screen actions performed on fields are represented by color coded cells as follows:

·    

Shaded = read-only cells

·    

White = editable cells

·    

Light blue = changed cells

·    

Yellow = cells with errors

User Account Privileges

The privileges for the Edit Sample modules are defined by sample type. A user may be given sample type = ALL, in which case their account can operate on all sample types (typically restricted to the curatorial staff). Alternatively, the user may be given privilege for specific sample types only (e.g., sample types needed at the sample table).

Even with the privilege to operate on “ALL” sample types, some sample types are not valid for editing. This includes hole, core, section (SECT), section half (SHLF), and piece (PC) samples. Samples of these types may appear in the search results table, but they are not selectable.

Edit Screen

The edit entry screen displays the following noneditable (slightly shaded) fields, which are shown for identification and information purposes only:

·    

LABEL_ID

·    

TEXT_ID

·    

Sample Type

·    

Changed By

·    

Changed On

·    

Parent Curated Length

The editable fields (white background) on the edit screen operate under the following rules:

Tool: Double-click in the field to open a drop-down value list. Select a tool or select blank to remove the tool and leave the field blank.

Top Offset (cm): Must be a number that is nonnegative, not equal to or less than the length of the Parent Curated Length, and equal to or less than Bottom Offset.

Bottom Offset (cm): Must be a number that is nonnegative, equal to or less than the length of the Parent Curated Length, and equal to or greater than Top Offset.

Length: Autocalculated from the top and bottom offsets. Does not allow manual entry. Note that if these linked fields have an error, it may be necessary to reenter either field to fully clear the error.

Volume (cc): Optional field (may be blank). Must be a number that is nonnegative.

Test List: Double-click in the field to open a drop-down value list. Select a test or the blank row to leave the field blank. Note that selecting the moisture and density (MAD) test requires entry of a container number.

Container: Optional field (may be blank). Must be a number that is nonnegative. This field is editable only if no MAD analysis results have been uploaded to LIMS. Once MAD data have been uploaded to LIMS, the user may not change this field.

Request Number: Alphanumeric. Double-click in the field to open a drop-down value list of request numbers, or type a value (maximum = 20 characters).

Request Code: Alphanumeric. Double-click in the field to open a drop-down value list of request codes, or type a value (maximum = 10 characters).

Name: Alphanumeric. Type a value (maximum = 30 characters).

Comment: Alphanumeric. Type text (maximum = 250 characters).

Field entries must obey the rules for that field or an error will be generated (yellow highlight in the cell). All errors must be resolved before any of the changes can be updated in LIMS.

Printing New Labels

The user can print new labels for the edited sample(s) by selecting the “Print Labels on Update” checkbox; if this is checked, labels for the edited samples and all of their children, grandchildren, etc., down to the bottom of the hierarchy tree, will print. All of the labels print on the same label printer and the same label format, so some sample labels may have to be reprinted using the Sample Master application.

Procedure

1.        

Perform a search as described in “Search Functions.” This search query returns only active samples and their children.

2.        

Click “Expand All” and select one or more samples to be edited. The “GO TO EDIT” button will become active.

3.        

Click the “GO TO EDIT” button.

4.        

Edit the desired fields following the validation rules given above (edited fields show blue highlight).

5.        

If desired, check “Print Labels on Update.”

6.        

Click the “UPDATE ALL SAMPLES IN THIS TABLE” button.

7.        

An audit trail pop-up window (see Fig. 13) appears, prompting the user for a reason for taking this action. Enter a reason (5–150 characters).

8.        

Click “Save Reason and continue.” Note that the “NO CHANGE and return” button returns the user to the previous state and no database action will occur. Similarly, the edit entry popup screen has a “NO CHANGE” button that returns the user to the search results.

9.        

Once “Save Reason and continue” is clicked, the operation is performed and the original search query runs again; edited samples and their children may or may not show in the results depending on the query parameters.

Important notes about Edit Samples

·    

Length is a calculated field derived from the Top Offset and Bottom Offset. If these linked fields have an error, it may be necessary to enter and leave the other field to fully clear the error.

·    

Edited fields are highlighted blue. These fields will be changed in LIMS on “UPDATE ALL SAMPLES IN THIS TABLE.”

·    

Fields containing an error are highlighted yellow, and a count of total errors in the edit table is shown at the top of the screen.

·    

All errors on the edit table must be resolved before the data can be updated. Attempting to update without resolving errors will cause an error message.

·    

Samples shown on the results table are limited by user account privilege and therefore may not show the complete hierarchy tree.