Sample Parameters (Most Recent)

<< Click to Display Table of Contents >>

EQuIS 7  >>  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. It uses the Sample Parameters Report. Note that 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 you make 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_zoom68

 

v54.sample_parameter_recent