Scribe - LabResults Report

<< Click to Display Table of Contents >>

Navigation:  Professional > Interfaces > Data Interfaces > Scribe >

Scribe - LabResults Report

Report Name: Scribe - LabResults

File Name: EarthSoft.Reports.Library.d38451.dll

Dependencies: Analytical Results II Report

Software: EQuIS Professional and EQuIS Enterprise

Source: Available for the EarthSoft Primary Point of Contact (POC) on the EarthSoft Community Center Downloads dashboard from the All Items > Formats folder.

Language: English

Output Type: Excel1

 

Description: The Scribe - LabResults Report can be used to export data from an EQuIS database into a Microsoft Excel (*.XLSX) file that can be used to submit laboratory results to Scribe, a desktop software tool developed by the United State Environmental Protection Agency's Environmental Response Team (ERT) to assist in the process of managing environmental data. Scribe Desktop publishes projects and data to Scribe.NET as a way of storing and sharing between Scribe Desktop clients and/or enterprise SQL database clients. This report is based off the Scribe EDDLabResults template provided by the USEPA and can be utilized in tandem with the EQuIS Scribe Format (which includes a LabResults section for importing data). More information about Scribe can be accessed from the Scribe website.

 

Installation Instructions: Download the Scribe - LabResults Report, unblock the *.zip file and extract the EarthSoft.Reports.Library.d38451.dll file to the EQuIS Professional installation folder. For default installations, this directory is C:\Program Files\EarthSoft\EQuIS or (for per-user installation) %localappdata%\Programs\EarthSoft\EQuIS\. The report will be available for selection once Professional has been relaunched.  

 

Overview: The Scribe - LabResults Report uses the same parameters as the Analytical Results II report, but with the following modifications:

1.The “Format Results” section along with the “Additional Fields” and “Workflow Status(es)” parameters have been excluded.

2.A new parameter called “Remap Code” has been added. This parameter will allow a remap code to be selected that will update the values in the report.

3.A new parameter called “Result Qualifier” has been added. This parameter will filter by either DT_RESULT.INTERPRETED_QUALIFIERS or DT_RESULT.VALIDATOR_QUALIFIERS for the report.

 

Potential Workflow: This is an example workflow for importing data from the Scribe format’s LabResults section to Scribe Desktop using the Scribe - LabResults Report.

1.Load the Scribe format in Professional EDP.

2.Populate the LabResults section. Make sure reference values are setup.

a.Setup dt_location and rt_company.

b.Make sure valid values are setup in rt_test_batch_type and rt_sample_parameter_type.

3.Create and Commit the data.

4.Once the data have been imported, go to Professional and click Reports on the Home ribbon.

5.Navigate to the report titled “Scribe - LabResults” and click Open.

6.Filter the data desired to be included in the report by the following parameters:

a.Location

b.Sample

c.Test

d.Result

e.Remap Code

f.Result Qualifier

7.After the report parameters have been set, click the Go Arrow right-16 icon on the Report toolbar to run the report.

8.When the report is generated, it will automatically create an Excel file and open Microsoft Excel.

 

Note: It is encouraged to apply a filter ANALYSIS_LOCATION = LB once the report has been generated. This is to ensure that lab analyses are differentiated from field analyses.

 

9.Save the file as a .csv file.

10.Login to Scribe Desktop (software provided by USEPA).

11.Go to File -> Import -> Custom Import. Users will be prompted to backup their data.

12.The Scribe Import Data Wizard should be populated accordingly.

a.Data Category: Lab Results

b.Import Data File: The file name of the .csv version of the Scribe - LabResults Report

c.Script Name: UniversalEDD Format

13.Click Next.

14.In the “Map Data To Import” step, make sure that the Scribe Fields (Destination) match the Import Fields (Source).

15.Click Next.

16.In the “Data To Be Imported” step, confirm that the fields have been populated properly.

17.Click Next.

18.In the “Ready To Import” step, choose an import option (either “Add New data records” or “Add New data records AND Update existing data records).

19.Click Import.

20.Once the data have been imported, click on Scribe.NET in the main ribbon and then click Publish.

21.The Scribe.NET Publisher Wizard will open. Click Next.

22.The Scribe.NET Publisher Wizard should then be populated accordingly:

a.Publisher ID: The USEPA region the data is associated with (e.g., USEPA Region 5)

b.Password: can be blank. No password required to publish.

23.Click Publish.

24.The new data for the Project have been published to Scribe.NET and are now available for subscription.

 

Note: A subscription ID and password will need to be acquired through ertsupport@epa.gov.

 

 

Source Tables: DT_CHAIN_OF_CUSTODY, DT_RESULT, DT_RESULT_QC, DT_SAMPLE, DT_SAMPLE_PARAMETER, DT_TEST, RT_ANALYTE, RT_MATRIX, RT_SAMPLE_TYPE

 

 

Report Parameters

Location

Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Use DT_GEOGRAPHY for coordinate data

Toggle to use DT_GEOGRAPHY for coordinate data. Default: False.

Sample

Type(s)

Select one or more sample types.

Date Range

Section to select the start date, end date, most recent sampling (False), and the option to use date range to select the most recent sampling events (False).

Matrix(es)

Select one or more matrices.

Task(s)

Select one or more tasks.

Task_Code_2(s)

Select one or more task_code_2s.

Field SDG(s)

Select one or more Field SDGs.

Depth

Section for selecting the minimum and maximum start and end depths as well as depth unit.

Minimum Start Depth

If a value is entered, only samples that start (DT_SAMPLE.START_DEPTH) above that value will be included. Sample with null START_DEPTH will be excluded.

Maximum End Depth

If a value is entered, only samples that end (DT_SAMPLE.END_DEPTH) below that value will be included. Sample with null END_DEPTH will be excluded.

Maximum Start Depth

If a value is entered, only samples that start (DT_SAMPLE.START_DEPTH) below that value will be included. Sample with null START_DEPTH will be excluded.

Minimum End Depth

If a value is entered, only samples that end (DT_SAMPLE.END_DEPTH) above that value will be included. Sample with null END_DEPTH will be excluded.

Unit

Select the desired unit for sample depth min/max.

DQM Status

Select the status of the DQM.

Test

Method(s)

Select one or more test methods.

Fraction(s)

Select one or more fractions.

Column Number(s)

Select one or more column numbers.

Type(s)

Select one or more test types.

Lab Matrix(es)

Select one or more lab matrices.

Prep Method(s)

Select one or more prep methods.

Lab SDG(s)

Select one or more Lab SDGs.

Result

Analyte

Section for selecting individual analytes, analyte groups, or excluding analytes that were not detected.

Unit

Selection for report result units.

Type(s)

Select one or more result types.

Detect Flag(s)

Select one or more options for detect flags.

Non-Detect Multiplier

Enter the desired non-detect multiplier value.

Non-Detect Symbol

Enter the desired non-detect symbol ("< ?", "ND", ...).  "?" will be replaced with reporting limit multiplied by non-detect multiplier.

Non-Detect Qualifier

Enter the desired non-detect qualifier (e.g., "U") to have that qualifier override the DETECT_FLAG column.

Reportable

Select one or more options for reportable results.

Validated

Selection for whether the result is validated or not.

Reporting Limit

Select which reporting limit to use (REPORTING_DETECTION_LIMIT, METHOD_DETECTION_LIMIT, etc.).

Remap Code

Select a remap code to be applied to values in the report.

Result Qualifier

Select the qualifier field returned by the report.

 

Report Output

DT_CHAIN_OF_CUSTODAY.CHAIN_OF_CUSTODY

DT_RESULT.CAS_RN

DT_RESULT.DETECT_FLAG

DT_RESULT.DETECTION_LIMIT_UNIT

DT_RESULT.INTERPRETED_QUALIFIERS

DT_RESULT.LAB_QUALIFIERS

DT_RESULT.METHOD_DETECTION_LIMIT

DT_RESULT.QUANTITATION_LIMIT

DT_RESULT.REPORTABLE_RESULT

DT_RESULT.REPORTING_DETECTION_LIMIT

DT_RESULT.RESULT_NUMERIC

DT_RESULT.RESULT_TEXT

DT_RESULT.RESULT_TYPE_CODE

DT_RESULT.RESULT_UNIT

DT_RESULT_QC.DQM_REMARK

DT_SAMPLE.SAMPLE_DATE

DT_SAMPLE.SYS_LOC_CODE

DT_SAMPLE.SYS_SAMPLE_CODE

DT_SAMPLE_PARAMETER.PARAM_VALUE

DT_TEST.ANALYSIS_DATE

DT_TEST.ANALYTIC_METHOD

DT_TEST.BASIS

DT_TEST.CUSTOM_FIELD_1

DT_TEST.DILUTION_FACTOR

DT_TEST.FINAL_VOLUME

DT_TEST.FINAL_VOLUME_UNIT

DT_TEST.FRACTION

DT_TEST.LAB_NAME_CODE

DT_TEST.LAB_REPORT_RECEIPT_DATE

DT_TEST.LAB_SAMPLE_ID

DT_TEST.PERCENT_MOISTURE

DT_TEST.PREP_DATE

DT_TEST.PREP_METHOD

DT_TEST.SUBSAMPLE_AMOUNT

DT_TEST.SUBSAMPLE_AMOUNT_UNIT

DT_TEST.TEST_TYPE

RT_ANALYTE.CHEMICAL_NAME

RT_MATRIX.MATRIX_DESC

RT_SAMPLE_TYPE.SAMPLE_TYPE_DESC

 

1Excel report output requires a valid license of Microsoft Excel to view the output.

 

 



Copyright © 2025 EarthSoft, Inc. • Modified: 23 Jun 2025