EIA: Past Max Turnaround Time Report

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports by Product > Standard with SPM > EIAs (EQuIS Information Agents) >

EIA: Past Max Turnaround Time Report

Report Name: EIA: Past Max Turnaround Time

File Name: EarthSoft.Reports.Library.48827.dll

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type: Excel1

 

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.

 

 

 

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.