EIA: Overdue SDGs Report

Report Name: EIA: Overdue SDGs

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: Overdue SDGs report notifies users of Sample Delivery Groups (SDGs) they are expecting, but have not yet received.

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:

The report looks at all DT_CHAIN_OF_CUSTODY records where DT_CHAIN_OF_CUSTODY.SHIPPING_DATE is older than the current system date, minus a user-specified number of days (X). Of these, the report returns all records for which an SDG has not been received.

This report is setup as an EQuIS Information Agent (EIA) only. Instructions on how to setup EIAs is available here.

Tables: AT_SAMPLE_SDG, DT_CHAIN_OF_CUSTODY

Report Parameters *

Older than X days ago

Parameter to check for SDGs shipped over X days ago, but not yet received. Default: 7.

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

•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 CHAIN_OF_CUSTODY COOLER_ID COOLER_TEMP EBATCH CUSTOM_FIELD_1 CUSTOM_FIELD_2 CUSTOM_FIELD_3 CUSTOM_FIELD_4 CUSTOM_FIELD_5 SHIPPING_COMPANY SHIPPING_TRACKING_NUMBER CONTACT_NAME_1 CONTACT_NAME_2	COMPLETE_YN COOLER_COUNT SAMPLER_SIGNATURE TURN_AROUND_TIME LAB_CODE COOLER_DESC QUOTE_NUMBER SHIPPING_DATE EMAIL_INVOICE_TO EMAIL_REPORT_TO RELINQUISHED_BY RELINQUISHED_DATE REMARK LAB_RECEIPT_DATE	LAB_COOLER_COUNT LAB_COOLER_DESC LAB_SECURITY_SEAL LAB_COOLER_TEMP CHAIN_OF_CUSTODY SAMPLER_1 SAMPLER_2 SAMPLER_3 PROJECT_MANAGER PROJECT_ID PO_NUMBER DEPARTMENT

Report Output

FACILITY_ID

CHAIN_OF_CUSTODY

COOLER_ID

COOLER_TEMP

EBATCH

CUSTOM_FIELD_1

CUSTOM_FIELD_2

CUSTOM_FIELD_3

CUSTOM_FIELD_4

CUSTOM_FIELD_5

SHIPPING_COMPANY

SHIPPING_TRACKING_NUMBER

CONTACT_NAME_1

CONTACT_NAME_2

COMPLETE_YN

COOLER_COUNT

SAMPLER_SIGNATURE

TURN_AROUND_TIME

LAB_CODE

COOLER_DESC

QUOTE_NUMBER

SHIPPING_DATE

EMAIL_INVOICE_TO

EMAIL_REPORT_TO

RELINQUISHED_BY

RELINQUISHED_DATE

REMARK

LAB_RECEIPT_DATE

LAB_COOLER_COUNT

LAB_COOLER_DESC

LAB_SECURITY_SEAL

LAB_COOLER_TEMP

CHAIN_OF_CUSTODY

SAMPLER_1

SAMPLER_2

SAMPLER_3

PROJECT_MANAGER

PROJECT_ID

PO_NUMBER

DEPARTMENT

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