Radiological Data Management

EQuIS has specific tables that track radiological data. Most test data are tracked using a CAS_RN value (chemical number) and saved to a results table (DT_RESULT), which is also connected to test and sampling data. The RT_ANALYTE_DETAIL.HALF_LIFE_YEARS field and the following fields from the DT_RESULT table support radiological data:

UNCERTAINTY – The uncertainty of the counting error. Valid values include "1 sigma" or "2 sigma". This field is required if the COUNTING_ERROR field is populated.

MINIMUM_DETECTABLE_CONC – The lowest concentration of an analyte that can be detected. This value should be in the same unit as DT_RESULT.RESULT_UNIT.

COUNTING_ERROR – This is the error as reported by the laboratory for tests that depending on counting. This value should be in the same unit as DT_RESULT.RESULT_UNIT.

CRITICAL_VALUE – Critical value as reported by the laboratory.

RESULT_ERROR_DELTA – Error range applicable to the result value; typically used only for radiochemistry results. This is an optional field for the laboratory EDD unless otherwise specified by the EQuIS project manager.

Read more about these fields using the Data Dictionary dashboard available on the EarthSoft Community Center.

EQuIS has formats that allow for negative values, such as the EZEDD or EQEDD formats, or a format can be modified to allow negative values. The EQEDD format includes the fields referenced above in the Lab sections of the format. For more information regarding formats and format customization, see the Selecting an Appropriate EQuIS Format and Making Changes to Format Files articles.

The RT_UNIT and RT_UNIT_CONVERSION_FACTOR tables may need to be updated to handle unit radiological conversions. For additional guidance on how to add the appropriate values and information on how EQuIS handles these, please see the Unit Conversion Formulas and Add Unit Types to Report Parameter Selections articles.

Finally, since radiological data values could potentially exceed the 20-character limit of the result fields, it may be beneficial to review how EQuIS manages significant figures.