EIA: New Locations Report

Report Name: EIA: New Locations

File Name: EarthSoft.Reports.Library.48827.dll* and EarthSoft.Reports.Library.d39109

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type: Excel1

*Note: This report was previously part of the EarthSoft.Reports.Library.48827.dll file. Previously published reports that have 48827 in the filename will still be accessible within EQuIS Professional; however, they will have [Outdated] appended to the filename to differentiate between each location.

Description: The EIA: New Locations report can be used to notify users when records are added to the DT_LOCATION table, either via EDD or manual entry.

Installation Instructions: This report requires a licensed SPM and the SPM Schema applied to the database. For SPM usage, no additional steps are necessary. For Enterprise use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

Overview:

By design, the first execution of the report or EQuIS Information Agent (EIA) is not limited to new locations. The default value of the last_date parameter is defined as the day before the earliest start_date of DT_LOCATION, so the initial report output includes all the records of DT_LOCATION of the logged in facility.

Once the report is saved as a user report or an EIA is setup and is executed, the latest start_date of DT_LOCATION of the facility is saved into the default value of the last_date parameter of the user report or EIA. The report logic compares DT_LOCATION.START_DATE to the last_date saved from the last run of the report and generates the results with start_date greater than the last_date or start_date is null. The last_date is stored as a hidden parameter in the ST_USER_REPORT_PARAMETER table.

This report is setup as an EIA only. Instructions on how to setup EIAs is available in the online help article EZView.

Report Parameters *

Select Location Type(s)

Parameter to select location type(s).

* This report contains the following hidden parameter(s) that could affect the outcome of the report:

•ebatch

•Facility_ID

•Last Date

If listed, the Additional Fields parameter may be customized as explained in How To Customize the Additional Fields Parameter.

Consult an EQuIS administrator if hidden parameters 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
FACILITY_ID SYS_LOC_CODE LOC_NAME DATA_PROVIDER SUBFACILITY_CODE LOC_DESC LOC_TYPE LOC_PURPOSE LOC_TYPE_2 LOC_MAJOR_BASIN WITHIN_FACILITY_YN LOC_COUNTY_CODE LOC_DISTRICT_CODE LOC_STATE_CODE LOC_MINOR_BASIN CUSTOM_FIELD_1 STREAM_CODE CUSTOM_FIELD_2 STREAM_MILE CUSTOM_FIELD_3	CUSTOM_FIELD_4 PHASE_CODE CUSTOM_FIELD_5 REMARK_1 BORE_ID REMARK_2 START_DATE END_DATE DRILLING_METHOD GEOLOGIST SAMPLING_METHOD DRAWING_CHECKER DRAWING_CHECK_DATE DRAWING_EDITOR DRAWING_EDIT_DATE DRILLER UNITS DEPTH_TO_BEDROCK LOG_DATE	TOTAL_DEPTH BEARING APPROVED PLUNGE DRILLING_SUBCONTRACTOR ENGINEER_SUBCONTRACTOR ENGINEER ESTAB_COMPANY_CODE EXCAV_COMPANY_CODE INSPECTOR INSPECT_SUBCONTRACTOR EBATCH MAP_CODE PARENT_LOC_CODE STATUS_FLAG HOLE_DIAMETER HOLE_DIAMETER_UNIT LOC_COUNTRY TRIBAL_LAND_NAME TRIBAL_LAND_YN

Report Output

FACILITY_ID

SYS_LOC_CODE

LOC_NAME

DATA_PROVIDER

SUBFACILITY_CODE

LOC_DESC

LOC_TYPE

LOC_PURPOSE

LOC_TYPE_2

LOC_MAJOR_BASIN

WITHIN_FACILITY_YN

LOC_COUNTY_CODE

LOC_DISTRICT_CODE

LOC_STATE_CODE

LOC_MINOR_BASIN

CUSTOM_FIELD_1

STREAM_CODE

CUSTOM_FIELD_2

STREAM_MILE

CUSTOM_FIELD_3

CUSTOM_FIELD_4

PHASE_CODE

CUSTOM_FIELD_5

REMARK_1

BORE_ID

REMARK_2

START_DATE

END_DATE

DRILLING_METHOD

GEOLOGIST

SAMPLING_METHOD

DRAWING_CHECKER

DRAWING_CHECK_DATE

DRAWING_EDITOR

DRAWING_EDIT_DATE

DRILLER

UNITS

DEPTH_TO_BEDROCK

LOG_DATE

TOTAL_DEPTH

BEARING

APPROVED

PLUNGE

DRILLING_SUBCONTRACTOR

ENGINEER_SUBCONTRACTOR

ENGINEER

ESTAB_COMPANY_CODE

EXCAV_COMPANY_CODE

INSPECTOR

INSPECT_SUBCONTRACTOR

EBATCH

MAP_CODE

PARENT_LOC_CODE

STATUS_FLAG

HOLE_DIAMETER

HOLE_DIAMETER_UNIT

LOC_COUNTRY

TRIBAL_LAND_NAME

TRIBAL_LAND_YN

1Excel report output requires a valid license of Microsoft Excel to view the output.