Throughout WellRep input of certain data fields is restricted to values from a so-called drop-down list.  Selecting values from this drop-down list may be strictly enforced (i.e. no other values are accepted) or provided as a guideline only (i.e. other values may be entered).  Strictly enforced input for fields may also be from a dialog box.  To ensure consistent input the drop-down lists should be used as much as possible.

 

For some fields, only input of values that are found in another table (called a lookup table) are accepted.  The data in the other lookup table is called lookup data.  As such, the drop-down list for the field is populated with values found in the lookup table. In some case the drop-down list may be filtered depending on context or values found in other fields.  For example, Pump Type values are filtered for the current Pump Manufacturer or Serial Numbers in the BHA tally are filtered for the currently selected Tool Class. 

 

In some cases the drop-down list may be completely empty and it is not possible to input data.  In other cases the desired value is not available in the drop-down list.  In both cases, the required value(s) may be added to the lookup table which can be accessed by selecting [Utility] – [Lookup data maintenance] from the main menu in the Main Form.

 

Adding lookup values should be used sparsely and only if strictly necessary. To prevent inconsistent data entry and data incompatibility between databases (i.e. rig site and office), care should be taken to not enter duplicates (sometimes spelled differently).  All changes made should be communicated to other users so that they can add the new value(s) to their database as well.  This is important as a field value that is not in the drop-down list (i.e. in the lookup table in the database) will appear as a blank field in the data form when the field is selected (although the data value will still be present).

 

The available lookup tables that may be edited are shown in tabs [1].  Use the < and > arrows on the top-right [2] to scroll non-visible tables (tabs) into view.

The following tables are available for editing:

 

1.Accessories (tools). Used to define accessory types for Accessory Inventory and Tool Detail data.

2.Activity codes. Used for coding daily activities (operations).

3.Bulk. Used to define bulk type and unit of measurement for daily bulk inventory.

4.Company.  Define company names for a variety of input field.

5.Connections. Define thread connections for tool records.

6.Cost. Define cost groups, cost classes, cost types and charge types for Budget (AFE) and Daily Cost.

7.HSE Events.  Define event types for tracking on Daily Reports.

8.Lithology. Define lithologies and linked fill patterns.

9.Manufacturer.  Define manufacturer names for Tool Detail data.

10.Mud type.  Define mud types for daily mud data.

11.Phase code.  Define well phases and codes to group daily activities. Also used in well Budget (AFE) and Daily Cost.

12.Profile points.  Define profile point types for tool records.

13.Pumps.  Define additional pump models for repeat usage.

14.Root cause.  Define root causes used when classifying daily activities with NPT or Service Interrupt.

15.Tool style.  Define tool styles for pre-defined tool classes.

 

At the bottom of the lookup maintenance dialog, additional functionality is available.