WS Master Data File

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Analytical Results >

WS Master Data File

Report Name: WS Master Data File

 

Report Type: Standard

 

Description: The WS Master Data File report, an EQuIS database stored procedure, reports pre-defined sampling activity related information (see Main output data mapping below) from DT_SAMPLE and DT_FIELD_SAMPLE during the user selected sampling date range. If users provide FIELD_PARAMETERS or LAB_PARAMETERS over RT_MTH_ANL_GROUP, the four extra columns with information of sampling number at REPORTABLE_RESULT='Y', REPORTING_DETECT_LIMIT, unit and LAB_QUALIFIER for each chemical are added into the report.

 

If the CHEMICAL_NAME is TURBIDITY, Column Field Comment is added. If the CHEMICAL_NAME is StandH20Level, another four columns of Standing Water Elevation (SWE), SWE pql, SWE units and SWE comments are added. It is a Professional stored procedure which calls DBO.WS_MASTER_DATA_FILE_PARAM.

 

Input Data Mapping: FIELD_PARAMETERS = METHOD_ANALYTE_GROUP_CODE from RT_MTH_ANL_GROUP where STATUS_FLAG='A'

LAB_PARAMETERS = METHOD_ANALYTE_GROUP_CODE from RT_MTH_ANL_GROUP where STATUS_FLAG='A'  

 

Main Output Data Mapping:

 

Error

number of samples with REPORTABLE_RESULT=Y(>1),
* or Error**

Site

FACILITY_CODE

Location

SYS_LOC_CODE

Date/Time

SAMPLE_DATE

Field ID

SYS_LOC_CODE, SAMPLE_DATE

Sampling Contractor

COMPANY_NAME. COMPANY_CODE

Sampled By

Sampler

WS Contract No.

NULL

Project No.

FACILITY_CODE

Laboratory

DT_TEST.LAB_NAME_CODE

Lab Report No.

FIELD_SDG

Contractor Sample ID

SYS_SAMPLE_CODE

Lab Sample ID

DT_TEST.LAB_SAMPLE_ID

Sample Type

MATRIX_DESC, MATRIX_CODE

QA/QC

SAMPLE_TYPE_DESC, SAMPLE_TYPE_CODE

Sampling Location ID

LOC_NAME

Top of Casing Level (TOC)

TOP_CASING_ELEV

TOC pql

NULL

TOC units

'm AHD' c

TOC comments

NULL

Note: *: the item after , means an alternative value. **: if no single Error happens, this column is removed.

 

Extra Output Data Mapping for each Chemical Provided over FIELD_PARAMETERS or LAB_PARAMETERS:

 

CHEMICAL_NAME ( _FRACTION.DESC or _FRACTION. Note: FRACTION=RT_MTH_ANL_GROUP_MEMBER.TOTAL_OR_DISSOLVED)

DT_RESULT.NUMERIC (Converted if RT_MTH_ANL_GROUP_MEMBER.REPORTING_UNITS entered).

CHEMICAL_NAME_PQL

REPORT_DETECTION_LIMIT or selected (converted in order of REPORTING_DETECTION_LIMIT

RESULT_UNIT

RT_MTH_ANL_GROUP_MEMBER. REPORTING_DETECT_LIMIT)

CHEMICAL_NAME_UNITS

RT_MTH_ANL_GROUP_MEMBER.REPORTING_UNITS *RESULT_UNIT

CHEMICAL_NAME_COMMENTS

DT_RESULT.LAB_QUALIFIERS RT_MTH_ANL_GROUP_MEMBER.DEFAULT_QUALIFIER

Note: *: the item after , means an alternative value

 

Extra Output Data Mapping for TURBIDITY:

 

Field Comments

DT_RESULT.REMARK

 

Extra Output Data Mapping for StandH20Level:

 

Standing Water Elevation (SWE)

Top of Casing Level (TOC) - RESULT_NUMERIC

[SWE pql]

REPORTING_DETECTION_LIMIT
*RT_MTH_ANL_GROUP_MEMBER.REPORTING_DETECT_LIMIT

[SWE units]

mAHD

[SWE comments]

NULL

Note:  *: the item after, means an alternative value

 

File Name: dbo.ws_master_data_file

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Report Requirements

Input Parameter Screenshot

Output Columns

Field Parameters


Lab Parameters


Date Range

 


Start Date


End Date

Contact support@earthsoft.com for
more information.

Contact support@earthsoft.com for
more information.

 

Tables: DT_SAMPLE, DT_FIELD_SAMPLE, DT_LOCATION, DT_WELL, RT_MATRIX, RT_SAMPLE_TYPE, RT_COMPANY, DT_TEST, DT_RESULT, RT_MTH_ANL_GROUP, RT_MTH_ANL_GROUP_PARAMETER.

 

Database Type: SQL

 

Database Schema: Standard (no custom or add-on schemas required).

 

Database Version: EQuIS 5.4.3+

 

Data Requirements: N/A

 

Report Requirements: N/A

 

Output Type: Igrid

 

Example Output: View the following example.

 

30110-ex.output-ws_masterdatafile_zoom59

 

ws_master_data_file