Sample Parameters (Most Recent)

Report Name: Sample Parameters (Most Recent) (example)

Function: v54.sample_parameter_recent

Report Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Excel1

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

Description: Sample Parameters (Most Recent) II Report compiles the PARAM_VALUE along with other parameters in DT_SAMPLE_PARAMETER

that are obtained most recently, and uses the Sample Parameters Report. The END_DATE input parameter is not visible by default. If the

END_DATE is selected, the "most recently" will be relative to the END_DATE. Note that a most recent record may have multiple values of

PARAM_TEXT, PARAM_UNIT, MEASUREMENT_METHOD, TASK_CODE, X_COORD, Y_COORD, longitude and latitude except the ones reported in

the report.

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

Overview:

Report Parameters *

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
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 contains the hidden parameter Date Range, that could affect the output of the report.

Consult an EQuIS administrator if these parameters should be visible or use different default values in a published report (a report
that allows saving of user reports). These paramaters 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

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