Sort Samples By

Parameter for setting the sort order of location/sample values. Default is NULL, which results in sorting by SYS_SAMPLE_CODE.

SPM Task Filter

Select one or more tasks.

Date Range

Start

Select a start date.

End

Select an end date.

Dynamic Adjustment

Parameter for offsetting the start date so that forms can be created ahead of the task start date. Integer value.

Department(s)

Parameter for selecting department(s).

Monitoring Program(s)

Parameter for selecting monitoring program(s).

Monitoring Type(s)

Parameter for selecting monitoring type(s).

Authority(s)

Parameter for selecting authority(s).

Authority Type(s)

Parameter for selecting authority type(s).

Task Type(s)

Parameter for selecting task type(s).

Priority Ranking(s)

Parameter for selecting priority ranking(s).

Person Name(s)

Parameter for selecting person(s).

Company Code(s)

Parameter for selecting company code(s).

Project(s)

Parameter for selecting project(s).

SPM Task Code(s)

Parameter for selecting SPM task code(s).

Sampling Company Code(s)

Select one or more sampling company code.

Only Task Locations

Check box to only include locations from the selected tasks. Default is True.

Include SPM COCs for Selected Tasks

Check box to include SPM COCs for selected tasks. Default is False.

User(s)

Select one or more user. Users selected can be available as list in collect forms.

Include Subfacilities

Check box to include subfacilities related to the selected locations. Default is False.

Only Selected Locations

Check box to only include locations from the selected locations below. Default is False.

Task exist check

Check box to generate report output only if tasks exist. Task table is not checked when parameter is set to false. Default is False.

Reference Locations

Individual(s)

Parameter for selecting individual location(s).

Group(s)

Parameter for selecting location group(s).

Coord_Type_Code

Parameter for selecting the COORD_TYPE_CODE.

Identifier

Parameter for selecting the coordinate identifier.

Status Flag

Selection parameter for STATUS_FLAG.

Exclude Locations Without Coordinates

Parameter for excluding locations that do not have COORD_TYPE_CODE configured. Default is False. NOTE: If the parameter is set to True and COORD_TYPE_CODE is populated, the record will be included in the report output whether or not values for X_COORD and/or Y_COORD are populated.

Task Code(s)

Option to prepopulate TASK_CODE from DT_TASK rather than use SPM.

Well Segments

First Well Segment

Select Segment Type for
Top of Screen

Parameter for selecting the segment type for the top of the screen for the first well segment.

Select Top of Screen
Material Type

Parameter for selecting the segment type for the top of the screen material type for the first well segment.

Second Well Segment

Select 2nd Well Segment Type

Parameter for selecting the segment type for the top of the screen for the second well segment.

Select 2nd Well Segment Material Type

Parameter for selecting the segment type for the top of the screen material type for the second well segment.

Reference Elevation

Parameter to select the reference elevation source: HISTORICAL_REFERENCE_ELEV, MEASURE_DATUM, or TOP_CASING_ELEV.

Historical

Water Levels

Years Back

Select how many years back to pull data. Value must be an integer.

Historical range outlier

The percent of outlier data that will be excluded from the minimum and maximum range used to check new detpth to water values.

Include Most Recent Field Measurements

Check box to include most recent field measurements data in the output. Default is False.

Select Most Recent Data Type

Select one or more type of most recent field measurements data to include in the most_recent_measurements worksheet of the output.

Sample Type Code

Select sample type code for most recent field measurements.

Analytic Method

Select the analytical method.

Sample Remark Type

Select the source for sample remark.

Field Parameter(s)

Please select field parameter(s) for most recent measurements. If nothing is selected, then all parameters will be returned.

Action Levels

Aggregate Data

When enabled, action level data will be aggregated by COMPARISON_ID and PARAM_CODE in the DT_ACTION_LEVEL_LOOKUP table. Enabled by default.

Param Codes

Parameter selection for PARAM_CODES.

Action Level Codes

Action level code parameter selection.

Select list of ad-hoc analysis

Parameter selection for ad-hoc analysis.

Equipment Types

Parameter selection for equipment types.

Equipment Parameter Code(s)

Select one or more parameter code(s). Most recent data will be downloaded to Collect for selected equipment type(s) and equipment parameter code(s).

Select remap code(s)

Parameter selection for remap codes.

Scribe

Starting CLP Number

Starting CLP Number (without chars: I O U V).

Location Blank Rows

Location Blank Rows.

Output File Type

Parameter for report output type: XLS or XLSX.

Lab(s)

Select one or more lab(s) to include in the output.