|
<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > Standard Reports > Locations & Location Parameters > Location Parameters (Extra Fields) Report |
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.
The report output is sorted by LOC_REPORT_ORDER, SYS_LOC_CODE, PARAM_REPORT_ORDER, and PARAM_CODE.
This report will fill non-numeric results as PARAM_TEXT in their respective outputs. Numeric results are reported as PARAM_VALUE per original functionality.
Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.
Overview: Use the Location Parameters (Extra Fields) Report as a replacement for the deprecated Location Parameters Report.
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
The report uses a database unit conversion function, relying upon the conversion factors stored in the RT_UNIT_CONVERSION_FACTOR reference table.
During a unit conversion, the output's PARAM_UNIT uses one of the existing unit specifications, in order:
1.Parameter\Unit report parameter
2.RT_LOCATION_PARAM_TYPE.STANDARD_UNIT field
3.DT_LOCATION_PARAMETER.PARAM_UNIT field
Warning: By default, there are no unit conversions if the Parameter section is not selected. The report only performs unit conversions in these scenarios: •Parameter\Unit is selected •Parameter\Unit is not selected but Parameter\Individual(s) or Group(s) is selected. |
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 * |
||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||
* This report includes hidden parameters 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.
**The Additional Fields parameter may be customized as explained in the help article How To Customize Additional Fields Parameter.
|
Report Output |
||
|---|---|---|
FACILITY_ID FACILITY_CODE SYS_LOC_CODE LOC_NAME LOC_GROUP LOC_REPORT_ORDER |
MEASUREMENT_DATE PARAM_CODE PARAM_REPORT_ORDER 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.
Copyright © 2026 EarthSoft, Inc. • Modified: 16 Nov 2026