Create Dynamic Calibration Form
Copyright © 2019 EarthSoft, Inc • Modified: 18 Feb 2019
The Equipment Calibration Form in EDGE is intended to store all field calibration data. The form is built dynamically from tables in EQuIS. This option requires entering data into several EQuIS database tables in advance of creating the Reference Values (RVF) file (or re-creating a new RVF file) as explained in Create a Reference Values File.
To simplify this process, use thre EDGE Configuration EDD Format with the example file available in Configuration Format to import the data into an EQuIS Database.
1.Use a copy of this example EDD to enter data.
2.The example EDD shows the kinds of data that can be entered in each column. Add, change or delete the data to get the values desired in the forms.
3.The format will map the data into each required table.
Complete the following steps to build the Equipment Calibration Form. This example centers around a Combustible Gas Detector.
1.RT_EQUIPMENT_TYPE: Populate RT_EQUIPMENT_TYPE as demonstrated below.
2. RT_EQUIPMENT_PARAM_TYPE: Populate RT_EQUIPMENT_PARAM_TYPE as demonstrated below.
3.AT_EQUIPMENT_PARAMETER: EDGE will build the form based on the information you place in AT_EQUIPMENT_PARAMETER to set the display order and calibration groups:
Note: DISPLAY_ORDER defines the order of both the CALIBRATION_GROUP and PARAM_CODE in EDGE.
4.RVF: Export RVF and copy/replace EDGE's old RVF with a new one. RVF export needs to be done with same format as used in EDGE. The completed calibration form will display as follows:
The data from this form will be stored in DT_EQUIPMENT_PARAMETER except for the REMARK field, which will be stored in DT_EQUIPMENT_NOTE. Data and comments are related by EQUIPMENT_CODE and CALIBRATION_DATE.
Calibration values now can be flagged if they are outside the acceptable ranges set in the action level tables.
Follow the steps below to set up calibration action levels.
1.Open the EDGE_Configuration.xsd located in EDGE\Configuration Formats folder in EDP.
2.Create a blank EDD by clicking "Blank EDD" in EDP.
3.Fill in the FIELD_RESULT_ACTION_LEVELS section with the calibration action levels as follows:
a.action_level_code: = at_equipment_parameter.equipment_type
b.param_code: = at_equipment_parameter.param_code
i.maximum value for range check
ii.for check against a standard like +- 0.2 for pH 7 for example, it will be 0.2
i.leave blank for range check
ii.+- for checks like +-0.2 of standard value
iii.+-% for checks like +-5% of standard value
e.warning_level: Standard to check against in d. Example value should be +-0.2 of pH 7 Standard.
f.action_level_type: Any value not to exceed 20 char. (i.e. Field Calibration)
g.action_level_min: Minimum value for range check
Please note that some error colors and fonts can be changed, as explained in EDP Settings.