Sample Parameters

Report Name: Sample Parameters (example)

Function: v54.sample_parameters

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Report Grid1

Note: The v54 reports have been superseded by more comprehensive class reports (version ‘II’). The Sample Parameters report was replaced by Sample Parameters (Extra Fields). EarthSoft recommends using the Sample Parameters (Extra Fields) report rather than Sample Parameters to take advantage of additional features, fixes, and performance optimization.

Description: This report queries data from the DT_SAMPLE_PARAMETER table. The Sample Parameter standard report has been improved to fill non-numeric results as PARAM_TEXT in their respective outputs. Numeric results are still reported as PARAM_VALUE per original functionality. Note this report attempts unit conversion to display results in like units. When the PARAM_UNIT is not set, the corresponding report output is set to a flag value indicating conversion error. These flag values are 1E+8 or 99999999.

Installation Instructions: This report is part of the EQuIS Schema and is created when the EQuIS database is created. No additional steps are necessary.

Overview:

Tables: DT_FACILITY, DT_LOCATION, DT_SAMPLE, DT_SAMPLE_PARAMETER, RT_GROUP, RT_GROUP_MEMBER, VW_LOCATION

Report Parameters *

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Measurement
Date Range	Section to select the start date and end date measurement date range.
Task(s)	Selct one or more sample parameter task codes.
Parameter
Individual(s)	Select one or more sample parameters.
Group(s)	Select one or more sample parameter groups.
Unit	Select the desired reporting unit.

* This report includes the following hidden parameter(s) that could affect the output of the report:

•ebatch

•facility_id

If listed, the Additional Fields parameter may be customized as explained in How To Customize the Additional Fields Parameter.

Consult an EQuIS administrator if hidden parameters should be visible or use different default values in a published report (a report that allows saving of user reports). Hidden parameters cannot be viewed or changed in unpublished reports outside of a report parameter file.

Report Output
FACILITY_ID FACILITY_CODE SYS_LOC_CODE LOC_NAME LOC_GROUP LOC_REPORT_ORDER MEASUREMENT_DATE	PARAM_CODE PARAM_VALUE PARAM_TEXT PARAM_UNIT MEASUREMENT_METHOD TASK_CODE	X_COORD Y_COORD LONGITUDE LATITUDE SYS_SAMPLE_CODE SAMPLE_NAME

Report Output

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

LOC_NAME

LOC_GROUP

LOC_REPORT_ORDER

MEASUREMENT_DATE

PARAM_CODE

PARAM_VALUE

PARAM_TEXT

PARAM_UNIT

MEASUREMENT_METHOD

TASK_CODE

X_COORD

Y_COORD

LONGITUDE

LATITUDE

SYS_SAMPLE_CODE

SAMPLE_NAME

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML or a printer.