Location Parameters (Rollup)

Report Name: Location Parameters (Rollup) (example)

Function: v54.location_parameters_rollup

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Report Grid1

Description: The Location Parameters (Rollup) Report compiles the hourly, daily, weekly or monthly average values of PARAM_VALUES in DT_LOCATION_PARAMETER based on selected parameters. It uses the Location Parameters Report. Note that the MEASUREMENT_DATE is precise to hours and that the max values of PARAM_UNIT, X_COORD, Y_COORD, Longitude and Latitude are reported.

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

Overview:

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 and end date range
Task(s)	Select a task code
Parameter
Individual(s)	Select one or more location parameters.
Group(s)	Select one or more location parameter groups.
Unit	Select the desired reporting unit.
Average By	Select how to compile the averages: hourly, daily, weekly, monthly

* This report contains the hidden parameter: ebatch, which 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.

Report Output
FACILITY_ID FACILITY_CODE SYS_LOC_CODE MEASUREMENT_DATE PARAM_CODE	PARAM_VALUE PARAM_UNIT MEASUREMENT_METHOD TASK_CODE X_COORD	Y_COORD LONGITUDE LATITUDE COUNT

Report Output

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

MEASUREMENT_DATE

PARAM_CODE

PARAM_VALUE

PARAM_UNIT

MEASUREMENT_METHOD

TASK_CODE

X_COORD

Y_COORD

LONGITUDE

LATITUDE

COUNT

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