Multi Facility Overview

Report Name: Multi Facility Overview (example)

File Name: EarthSoft.Reports.Library.d37969.dll

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

Description: The Multi Facility Overview report compiles information from the DT_FACILITY, DT_COORDINATE and RT_WORKFLOW_STATUS tables regarding facility address, administrative details, locations with coordinates, and an approximate coordinate point for the facility. This report can be used to review details for a single facility, facility group(s), or multiple individual facilities. The report output can be used in the Map widget and Data Grid widget in Enterprise, with the following limitations within those widgets:

•Only User Reports of the Multi Facility Overview report can be loaded.

•Report records without X_COORD and Y_COORD values will not be displayed.

Note: Users will only be able to access facilities to which they have permission to view/edit.

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

Overview: The report output is generated based on selected parameters (see below Parameters table) from multiple tables (DT_FACILITY, DT_COORDINATE and RT_WORKFLOW_STATUS). See below Report Output table for report fields and source/calculation thereof.

Tables: DT_COORDINATE, DT_FACILITY, RT_WORKFLOW_STATUS

Report Parameters

FACILITY_ID	Login facility.
Facility/Individual(s)	Multi-select and defaults to the login facility. Select one or more DT_FACILITY.FACILITY_ID fields.
Facility/Group(s)	Multi-select and defaults to empty. Select one or more facility groups from RT_GROUP.GROUP_CODE, where FACILTY_ID < 0 and STATUS_FLAG = 'A'. Note: Report generates the results of the login facility if both Facility/Individual(s) and Group are not selected, or a warning message if no session facility is selected in Enterprise.
Location/Coordinate Type Code	REQUIRED, single-select, and defaults to LAT LONG. Options for parameter come from RT_COORD_TYPE.COORD_TYPE_CODE.
Location/Identifier	REQUIRED, single-select, and defaults to PRIMARY.

Consult an EQuIS administrator if hidden parameter(s) should be visible or use different default values in a published report (a report that allows saving of user reports). Hidden parameters cannot be viewed or changed in unpublished reports outside of a report parameter file.

Report Output	Data Mapping	Remark
FACILITY_CODE	DT_FACILITY.FACILITY_CODE
FACILITY_NAME	DT_FACILITY.FACILITY_NAME
START_DATE	DT_FACILITY.START_DATE
PROJECT_MANAGER	DT_FACILITY.PROJECT_NUMBER
WORKFLOW_STATUS	DT_FACILITY.WORKFLOW_STATUS
WORKFLOW_NAME	RT_WORKFLOW_STATUS.NAME or DT_FACILITY.WORKFLOW_STATUS	Select RT_WORKFLOW_STATUS.NAME if not null, else DT_FACILITY.WORKFLOW_STATUS.
LOC_COUNT	Count of DT_COORDINATE.SYS_LOC_CODE	Select count of DT_COORDINATE.SYS_LOC_CODE for facility.
X_COORD	DT_FACILITY or DT_COORDINATE	Calculated in following order: If extent of facility defined in DT_FACILITY (XMIN, XMAX, YMIN, YMAX) then select mean of XMIN and XMAX else select mean of all DT_COORDINATE.X_COORD records of facility.
Y_COORD	DT_FACILITY or DT_COORDINATE	Calculated in following order: If extent of facility defined in DT_FACILITY (XMIN, XMAX, YMIN, YMAX) then select mean of YMIN and YMAX else select mean of all DT_COORDINATE.Y_COORD records of facility.
ADDRESS_1	DT_FACILITY.ADDRESS_1
ADDRESS_2	DT_FACILITY. ADDRESS_2
CITY	DT_FACILITY.CITY
COUNTY	DT_FACILITY.COUNTY
STATE	DT_FACILITY.STATE
COUNTRY	DT_FACILITY.COUNTRY
CLIENT	DT_FACILITY.CLIENT

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