Location Parameters (Most Recent)

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Location & Location Parameter Reports >

Location Parameters (Most Recent)

Report Name: Location Parameters (Most Recent) (example)

Function: v54.location_parameter_recent

Dependencies: Location Parameters Report

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Report Grid1

 

Description: The Location Parameters (Most Recent) Report compiles the PARAM_VALUES along with other parameters in DT_LOCATION_PARAMETER that are obtained most recently. It uses the Location 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. The 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.

 

Installation Instructions: This report is part of the EQuIS Schema and is created when the EQuIS database is created. No additional steps necessary.

 

Overview:

 

Tables: All the tables used by the Location Parameters Report

 

Report Parameters

Location


Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Parameter


Individual(s)

Select one or more location parameters.

Group(s)

Select one or more location parameter groups.

Unit

Select the desired reporting unit.

* This report contains the hidden parameter: ebatch, facility_id and Date Range

 

 

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

 

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