EIA: Past Max Turnaround Time Report

Report Name: EIA: Past Max Turnaround Time

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: Past Max Turnaround Time report notifies the user of samples that have not been received within the expected turnaround time.

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 calculates the actual turnaround time for samples as the difference in days between DT_CHAIN_OF_CUSTODY.LAB_RECEIPT_DATE and ST_FILE_REGISTRATION.RECEIVED_DATE. It then compares this number to the expected turnaround time for the associated SPM Contract Analytic Method and returns all records for which the actual turnaround time exceeded the expected turnaround time.

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

Tables: DT_CHAIN_OF_CUSTODY, DT_CHAIN_OF_CUSTODY_MAG, DT_CHAIN_OF_CUSTODY_MAG_MEMBER, DT_FACILITY, DT_SAMPLE, DT_SPM_CONTRACT_METHOD, ST_FILE_REGISTRATION

Input Parameters *
This report contains no input parameters
* 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.

Input Parameters *

This report contains no input parameters

* 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_NAME SYS_SAMPLE_CODE SAMPLE_DATE COC_RECEIVED_DATE EDD_RECEIVED_DATE TURNAROUND_TIME MAX_TURNAROUND_DAYS ANALYTIC_METHOD 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_ID SAMPLER_1 SAMPLER_2 SAMPLER_3 PROJECT_MANAGER PROJECT_ID PO_NUMBER DEPARTMENT NB_OF_BOTTLES_RETURNED BOTTLES_RETURNED_DESC

Report Output

FACILITY_NAME

SYS_SAMPLE_CODE

SAMPLE_DATE

COC_RECEIVED_DATE

EDD_RECEIVED_DATE

TURNAROUND_TIME

MAX_TURNAROUND_DAYS

ANALYTIC_METHOD

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_ID

SAMPLER_1

SAMPLER_2

SAMPLER_3

PROJECT_MANAGER

PROJECT_ID

PO_NUMBER

DEPARTMENT

NB_OF_BOTTLES_RETURNED

BOTTLES_RETURNED_DESC

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