Sample Parameters

<< Click to Display Table of Contents >>

Sample Parameters

Report Name: Sample Parameters

 

Report Type: Standard Report

 

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.

 

File Name: v54.sample_parameters

 

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)


Measurement




Date Range




Start Date



End Date

Measurement




Task(s)


Parameter




Individual(s)



Group(s)



Unit


                                               

30083-ex.output

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

LOC_NAME

LOC_GROUP

LOC_REPORT_ORDER MEASUREMENT_DAT 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

 

Databse Type: SQL

 

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

 

Databse Version: EQuIS 5.4.3+

 

Data Requirements: N/A

 

Report Requirements: Excel

 

Output Type: Excel

 

Example Output: View the following example.

 

30083-ex.output_zoom75

 

v54.sample_parameters