Sample Parameters (Most Recent)

<< Click to Display Table of Contents >>

EQuIS Library > Reports > EarthSoft Standard Reports > Sample Parameter Reports >

Sample Parameters (Most Recent)

Report Name: Sample Parameters (Most Recent) II

*Previously called (Beta) Sample Parameters (Most Recent)

 

Report Type: Standard Report

 

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.

 

File Name: v5.4 sample_parameter_recent

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

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

 

Input Parameters

Input Parameter Screenshot

Output Columns

Location



Individual(s)


Group(s)

*Date Range



End Date

Parameter



Individual(s)


Group(s)


Unit

30087-input.params

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

Note: * refers to hidden parameters.

 

Tables: RT_GROUP

 

Database Type: SQL

 

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

 

Database Version: EQuIS 5.4.3+

 

Data Requirements: N/A

 

Report Requirements: Excel

 

Output Type: Excel

 

Example Output: View the following example.

 

30087-ex.output_zoom67

 

v54.sample_parameter_recent