Location Parameters (Extra Fields)

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Location Parameter Reports >

Location Parameters (Extra Fields)

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

 

Report Type: Standard

 

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. It is a class report

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

Report.

 

Note: 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.

 

File Name: EarthSoft.Reports.Library.65991

 

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

 

Language: English

 

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

 

Note that the Additional Fields parameter may be customized as explained here.

 

Input Parameters

Input Parameter Screenshot

Output Columns

* ebatch


Location


Reporting Frequency


Location



Individual(s)


Group(s)

Measurement

Start


End


Task(s)

Parameter

Individual(s)


Group(s)


Unit

Additional Fields








                                               

30070-input.params.scrnsht

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

 

Note: * refers to hidden parameters

 

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.

 

Database Type: SQL

 

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

 

Database Version: EQuIS 5.5.1+

 

Data Requirements: N/A

 

Report Requirements: N/A

 

Output Type: PRO Grid

 

Revision History:

 

In EQuIS 7

1.The report is modified to report LOC_NAME from DT_LOCATION rather than VW_LOCATION (Case 145574)

 

Example Output

 

Note: ADDRESS_1 of the table below is selected over the Additional Fields of input parameters.

 

30070-ex.output_zoom45

 

Note: The Location Name ("LOC_NAME" field) for this report is pulled from VW_LOCATION.  Any location that does not have a correctly configured record in DT_COORDINATE (where DT_COORDINATE.COORD_TYPE_CODE = DT_FACILITY.COORD_TYPE_CODE and DT_COORDINATE.IDENTIFIER = DT_FACILITY.IDENTIFIER) will not be displayed.  As a workaround, you can select the DT_LOCATION.LOC_NAME field as an "Additional Fields" parameter to display the Location Name from the DT_LOCATION table.  This will be resolved in a future release of EQuIS Professional.