EIA: Samples by Type Report

Report Name: EIA: Samples by Type (example)

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: Samples by Type report generates a summary of data from the DT_SAMPLE table based on a user-defined DT_SAMPLE.SAMPLE_TYPE value. This report can be run in EQuIS Professional or published to EQuIS Enterprise.

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:

When run as an EDD-triggered EIA in EQuIS Enterprise, the report will check the incoming EDD for SAMPLE_TYPE values matching the selection parameter. For example, if a SAMPLE_TYPE of "NST" (no sample taken) is selected and exists in the EDD, the report will generate output.

Tables: DT_FIELD_SAMPLE, DT_SAMPLE

Report Parameters *

Sample Type

Parameter to select sample type.

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

•ebatch

•Facility_ID

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 SAMPLE_ID SYS_SAMPLE_CODE SAMPLE_NAME DATA_PROVIDER SAMPLE_CLASS SYS_LOC_CODE CAT_SAMPLE_CODE START_DEPTH SAMPLE_SOURCE SAMPLE_TYPE_CODE DEPTH_UNIT END_DEPTH SAMPLE_DESC DURATION DURATION_UNIT SAMPLE_METHOD SAMPLE_DATE REMARK TASK_CODE LAB_SOLUTION_SOURCE	EQUIPMENT_CODE PARENT_SAMPLE_CODE MEDIUM_CODE MATRIX_CODE CUSTOM_FIELD_1 CUSTOM_FIELD_2 CUSTOM_FIELD_3 CUSTOM_FIELD_4 CUSTOM_FIELD_5 EBATCH ALT_LIMITS BASELINE_YN TASK_CODE_2 EUID WEATHER_CONDITION SAMPLE_START_DATE SPM_SAMPLE_ID FACILITY_ID1 SAMPLE_ID1 CHAIN_OF_CUSTODY	EQUIPMENT_CAL_DATE FIELD_SDG COLL_PROC_CODE COLLECTION_QUARTER SENT_TO_LAB_DATE SAMPLE_RECEIPT_DATE COMPOSITE_YN COMPOSITE_DESC SAMPLER SAMPLING_COMPANY SAMPLING_REASON FILTER_TYPE AIR_VOLUME AIR_VOLUME_UNIT REMARK1 EBATCH1 EUID1 FLD_QUALIFIER FLD_QUALIFIER_NOTE FILTERED_DATE

Report Output

FACILITY_ID

SAMPLE_ID

SYS_SAMPLE_CODE

SAMPLE_NAME

DATA_PROVIDER

SAMPLE_CLASS

SYS_LOC_CODE

CAT_SAMPLE_CODE

START_DEPTH

SAMPLE_SOURCE

SAMPLE_TYPE_CODE

DEPTH_UNIT

END_DEPTH

SAMPLE_DESC

DURATION

DURATION_UNIT

SAMPLE_METHOD

SAMPLE_DATE

REMARK

TASK_CODE

LAB_SOLUTION_SOURCE

EQUIPMENT_CODE

PARENT_SAMPLE_CODE

MEDIUM_CODE

MATRIX_CODE

CUSTOM_FIELD_1

CUSTOM_FIELD_2

CUSTOM_FIELD_3

CUSTOM_FIELD_4

CUSTOM_FIELD_5

EBATCH

ALT_LIMITS

BASELINE_YN

TASK_CODE_2

EUID

WEATHER_CONDITION

SAMPLE_START_DATE

SPM_SAMPLE_ID

FACILITY_ID1

SAMPLE_ID1

CHAIN_OF_CUSTODY

EQUIPMENT_CAL_DATE

FIELD_SDG

COLL_PROC_CODE

COLLECTION_QUARTER

SENT_TO_LAB_DATE

SAMPLE_RECEIPT_DATE

COMPOSITE_YN

COMPOSITE_DESC

SAMPLER

SAMPLING_COMPANY

SAMPLING_REASON

FILTER_TYPE

AIR_VOLUME

AIR_VOLUME_UNIT

REMARK1

EBATCH1

EUID1

FLD_QUALIFIER

FLD_QUALIFIER_NOTE

FILTERED_DATE

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