Location Parameters (Extra Fields)

Report Name: Location Parameters (Extra Fields) (example)

File Name: EarthSoft.Reports.Library.65991.dll

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

Description: The Location Parameters (Extra Fields) Report generates the location parameter information from DT_LOCATION_PARAMETER and other selectable fields from DT_FACILITY, DT_LOCATION_PARAMETER, DT_PRECIPITATION, VW_LOCATION and VW_WELL, RT_COMPANY, RT_TIMEZONE, RT_UNIT, RT_BASIN, RT_LOCATION_TYPE, RT_STATE, RT_STREAM, RT_SAMPLE_METHOD, RT_LAND_USE and RT_LOCATION_PARAM_TYPE. It is a class report where extra fields can be selected.

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

Overview:

The Location Parameters (Extra Fields) Report can be used as a replacement for the former Location Parameters Report.

Notes:

•Prior to build 7.21.2, this report cannot be run from a facility group.

•The report requires RT_GROUP_MEMBER.MEMBER_CODE = RT_LOCATION_PARAM_TYPE.PARAM_CODE. It fails if the required data are not populated and Parameter - Individual(s)/Group(s) are selected.

•Unit Conversion is handled by the unit conversion function within the database, which relies on the conversion factors stored in the RT_UNIT_CONVERSION_FACTOR table. If the report fails to convert units, it generates an informative error message of either "MISSING UNIT CONVERSION FACTOR - cannot convert ..." or "Actual unit value EQUALS the special "NO CONVERSION" value specified..." Note only the first encountered missing unit conversion factor will be included in the error message; additional errors may occur after the initial error is resolved.

Tables: DT_FACILITY, DT_LOCATION, DT_LOCATION_PARAMETER, DT_PRECIPITATION, RT_GROUP, RT_GROUP_MEMBER, RT_LOCATION_PARAM_TYPE, RT_UNIT, ST_REPORT_PARAMETER, VW_LOCATION,VW_WELL.

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 location parameter task codes.
Parameter
Individual(s)	Select one or more location parameters.
Group(s)	Select one or more location parameter groups.
Unit	Select the desired reporting unit.
Additional Fields

* The Additional Fields parameter may be customized as explained in the help article How To Customize Additional Fields Parameter.

** This report contains the hidden parameter: ebatch

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

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

Skip Missing Unit Conversions:

A hidden parameter, Skip Missing Unit Conversions is available for configuring the report to skip failed result unit conversions and generate a row of param_value=original numeric param_value or null if non-numeric, param_text=original param_value and param_unit = original param_unit. The Skip Missing Unit Conversions parameter defaults to unchecked (default_value=false) and can be set in the database (ST_REPORT_PARAMETER) and made visible, if necessary.

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