Location Parameters (Most Recent)

<< Click to Display Table of Contents >>

Location Parameters (Most Recent)

Report Name: Location Parameters (Most Recent)*

*previously called (Beta) Location Parameters (Most Recent)

 

Report Type: Standard

 

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.

 

File Name: v54.location_parameter_recent

 

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

 

Language: English

 

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

 

Input Parameters

Input Parameter Screenshot

Output Columns

Location



Individual(s)


Group(s)

*Date Range



End

Parameter



Individual(s)


Group(s)


Unit















                                               

30071-input.params

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

 

Tables: All the tables used by the Location Parameters Report

 

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: Excel

 

Output Type: Excel

 

Example Output: View the following example or download the attachment.

 

30071-ex.output_zoom80

 

EarthSoft.Reports.Library._69844.LocationParametersMostRecent