Soil Gas Survey

Report Name: Soil Gas Survey (example)

Stored Procedure: v54.soil_gas

Report Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Report Grid1

Description: The Soil Gas Survey Report is a simple report for soil gas survey data. Enter Soil Gas data with the EDGE format.

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

Instructions:

Note: The primary key for DT_SOIL_GAS_SURVEY includes SYS_LOC_CODE, SURVEY_DATE and PARAM_CODE. Differentiating readings from the same location/date by depth requires a different time in SURVEY_DATE for each entry.

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

Tables: RT_GROUP, DT_SOIL_GAS_SURVEY, DT_LOCATION, DT_TASK, DT_EQUIPMENT

Report Parameters *

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Parameter(s)	Parameter for selecting the param_code.
Date Range	Section to select the start date, and end date.

* This report includes the hidden parameter ebatch, that could affect the output of the report.

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

Report Output
FACILITY_ID FACILITY_CODE SYS_LOC_CODE SURVEY_DATE PARAM_CODE READING READING_UNIT	READING_DEPTH DEPTH_UNIT SAMPLING_METHOD INSTRUMENT_TYPE PARAM DESCRIPTION AREA_DESCRIPTION LITHOLOGY_CODE	EQUIPMENT CODE BOREHOLE_DRILL_METHOD REMARK TECHNICIAN TASK_CODE

Report Output

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

SURVEY_DATE

PARAM_CODE

READING

READING_UNIT

READING_DEPTH

DEPTH_UNIT

SAMPLING_METHOD

INSTRUMENT_TYPE

PARAM DESCRIPTION

AREA_DESCRIPTION

LITHOLOGY_CODE

EQUIPMENT CODE

BOREHOLE_DRILL_METHOD

REMARK

TECHNICIAN

TASK_CODE

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