---
title: "Reports Specification"
canonical: "https://servicedesk.maxgeo.com/space/DS/1421705220/Reports%20Specification"
format: markdown
---
| **Report Name** | **Sub Report** | **DataSource                         ** |
| --- | --- | --- |
| Assay Summary | Assays Loader | ```sql
SELECT DISTINCT c.DataSet, b.Batch_No, b.MergeDate, b.SampleCount, b.SamplesMerged, b.ResultsCount,   b.ResultsMerged, b.LabCode, d.Description AS   Batch_Status, b.Validated_By,b.Date_Validated
FROM tblSYSDataSet AS c INNER JOIN
(SELECT   DISTINCT DataSet, LabCode, Batch_No
FROM tblAssay) AS a ON c.DataSet = a.DataSet RIGHT   OUTER JOIN
tblSYSAssBatch AS b ON a.LabCode = b.LabCode AND a.Batch_No = b.Batch_No left JOIN                                                                                                tblSYSAssbatchStatus AS d ON   d.Code = b.batch_Status
``` |
| Samples Dispatched | ```sql
SELECT d.DispatchID, d.ContractID, d.Dispatched_Date,d.Lab_Turnaround_Requirement, 
d.Total_Samples_Dispatched,   b.Lab_Job_Date, b.Batch_No, 
case when   isnull(b.Lab_Job_Date,0) <> 0 AND isnull(d.dispatched_date,0) <>   0 then Datediff(day,d.Dispatched_Date,b.Lab_Job_Date)
else 0 end AS Turnaround  , 
b.SampleCount   AS Lab_Sample_Count,  InvoiceID FROM tblSYSAssDispatchHeader d 
left outer JOIN tblSYSAssBatch b ON d.DispatchID = b.Dispatch_No 
``` |
| Audit Report - Assay and Sampling | Lab Received date Audit | ```sql
SELECT   "tblSYSAssBatch"."LabCode",   "tblSYSAssBatch"."Batch_No",
         "tblSYSAssBatch"."Dispatched_Date",
         "tblSYSAssBatch"."Dispatch_No",
         "tblSYSAssBatch"."Lab_Received_Date",
         "tblSYSAssBatch"."Lab_Job_Date",   "tblSYSAssBatch"."MergeDate",
         "tblSYSAssBatch"."Loaded_By"
FROM     "dbo"."tblSYSAssBatch" "tblSYSAssBatch"
WHERE    ("tblSYSAssBatch"."Dispatched_Date" is null
       AND ((@pDateFROM <=   "tblSYSAssBatch"."MergeDate")
       AND   ("tblSYSAssBatch"."MergeDate" <= @pDateTo)))
``` |
| Audit Report - Assay and Sampling contd. | Dispatch Samples Partial Results Audit | ```sql
SELECT   "tblVWSYSAssDispatchSampleCounts"."DispatchID",
         "tblVWSYSAssDispatchSampleCounts"."Dispatched_Date",
         "tblVWSYSAssDispatchSampleCounts"."Total_Dispatch_Samples",
         "tblVWSYSAssDispatchSampleCounts"."Total_Samples_In_Sample_Register",
         "tblVWSYSAssDispatchSampleCounts"."Assay_Results_Received"
FROM     "dbo"."tblVWSYSAssDispatchSampleCounts"
         "tblVWSYSAssDispatchSampleCounts"
WHERE    (("tblVWSYSAssDispatchSampleCounts"."Total_Dispatch_Samples"   <>   "tblVWSYSAssDispatchSampleCounts"."Assay_Results_Received")
       AND ((@pDateFROM <=   "tblVWSYSAssDispatchSampleCounts"."Dispatched_Date")
       AND ("tblVWSYSAssDispatchSampleCounts"."Dispatched_Date"   <= @pDateTo)))
``` |
| Dispatch Sample   Results Audit | ```sql
SELECT   "tblVWSYSAssDispatchSampleStatus"."DispatchID",
         "tblVWSYSAssDispatchSampleStatus"."Dispatched_Date",
         "tblVWSYSAssDispatchSampleStatus"."DataSet",
         "tblVWSYSAssDispatchSampleStatus"."SampleID",
         "tblVWSYSAssDispatchSampleStatus"."Sample_Created",
         "tblVWSYSAssDispatchSampleStatus"."Assay_Result_Received"
FROM     "dbo"."tblVWSYSAssDispatchSampleStatus"
         "tblVWSYSAssDispatchSampleStatus"
WHERE    (("tblVWSYSAssDispatchSampleStatus"."Assay_Result_Received"   = N'No')
       AND ((@pDateFROM <=   "tblVWSYSAssDispatchSampleStatus"."Dispatched_Date")
       AND   ("tblVWSYSAssDispatchSampleStatus"."Dispatched_Date"   <= @pDateTo)))
``` |
| Audit Report - Drill Activity | Drilling   Activity Depth Inconsistencies | ```sql
SELECT     DataSet, Hole_ID, [Planned Depth], 
           sum([Total   Drilling Depth]) AS [Total   Drilling Depth],
          [Contract End   Date],Hole_Status,Comments
FROM   [tblVWRepORtDrillingStatus]
group by   DataSet, Hole_ID,[Contract End Date],Hole_Status,[Planned Depth],Comments
HAVING    (CAST(SUM([Total Drilling Depth]) AS decimal(10, 2)) <> [Planned   Depth])
``` |
| Drill Activity Entries with duplicate from and to drill Depth | ```sql
SELECT * FROM   [tblVWRepORtContractActivityLogMetres]
``` |
| Drill Holes   Progress | Data | ```sql
Usp_rptDrillStatus,   tbllibHoleStatus
``` |
| Chart | ```sql
Usp_RPTdrillLogTableData,   tblLIBLithCode
``` |
| Drill Log by Dataset |  | ```sql
usp_RptDrillLogTableData
tblDHCollars 
usp_RPTCollars
``` |
| Drilling   Summary | Drill Holes   In progress | ```sql
usp_NDS_DrillHolesInProgress
``` |
| Significant   Drill Results | ```sql
usp_NDS_SignificantDrillResults,
tblSYSICPackage
``` |
| Logging   Statistics | ```sql
usp_NDS_LoggingStatistics
``` |
| Drilling   Meters YearToDate | ```sql
usp_NDS_DrillingMetresYearToDate
``` |
|  | ```sql
usp_NDS_DrillingMetresMonthToDate
``` |
| Drilling   Meters Month To Date | ```sql
usp_NDS_DrillingCostsYearToDate
``` |
| Drilling   Efficiency | ```sql
usp_NDS_DrillEfficiencyPeriodToDate
``` |
| Production   Summary |  | ```sql
tblVWRepORtProdBalance
``` |
| Blast Report |  | ```sql
tblProdBlasting,   tblProdBlock
``` |
| Feed Report |  | ```sql
tblVWRepORtProdBalance
``` |
| Location Survey Report |  | ```sql
tblProdEOMActualsStockpiles,
tblProdEOMActualsStockpileCommodity
tblProdLocations
``` |
| Movement Report |  | ```sql
tblVWRepORtProdBalance
``` |
| Daily Operating Report |  | ```sql
usp_RptProduction
``` |
| Mined vs   Planned Block |  | ```sql
usp_RptProdReco
``` |
| Planned vs   Reserve Block |  | ```sql
usp_RptProdReco
``` |
| Reserve vs   Resource Block |  | ```sql
usp_RptProdReco
``` |
| Trucked vs   Mined Block |  | ```sql
usp_RptProdReco
``` |
| ROM Report |  | ```sql
tblVWRepORtProdBalance
``` |
| Safety Report |  | ```sql
tblVWIncidentbyRepORtingType,   tblVWIncidentbyDepartment,
usp_RptIncident
``` |
| Stockpile   Summary by Block |  | ```sql
tblVWProdTruckingCalculated
tblVWProdBlockMerged
``` |
| Trucked Report |  | ```sql
tblVWProdTruckingRpt
``` |
| DH Drill Log Audit |  | ```sql
usp_RptDHDrillLogAudit
tblSysNORmAttribute
``` |
| Batch Status Report |  | ```sql
usp_RptBatchSummary
BatchStatusQuery   
SELECT Code, Description FROM (SELECT   '*ALL*' AS Code, '*ALL*' AS Description , 1 AS ORderData Union
SELECT code, Description, ROW_Number () Over(ORder by   tblsysAssBatchStatus.[Code]) + 1 AS   ORderData FROM tblsysAssBatchStatus) a ORder by ORderData

LabCodeQuery
SELECT '*ALL*' AS LabCode , 1 AS ORderData Union
( SELECT LabCode,ROW_Number () Over(ORder by LabCode) + 1 AS ORderData 
FROM (SELECT distinct LabCode FROM tblsysAssBatch) a ) ORder by ORderData
``` |
| Assay StripLog |  |  |
| Periodical Report   – Drill Hole and Sample Type Summary |  |  |
| Periodical Report   – Maximum Downhole Assay Results by Tenement |  |  |
| Periodical Report   – Maximum Downhole Assay Value |  |  |
| Periodical Report  – Tenement Drill Hole Summary |  |  |
| Periodical Report  – Tenement Linear Sample Summary |  |  |
| Periodical Report – Tenement Point Sample Summary |  |  |
| QAQC Monthly Report | Sample   Submission | ```sql
usp_RptQAQC_MonthlyRepORt
``` |
| Repeatability | ```sql
usp_RptQAQC_MonthlyReportRepeatability
``` |
| CRM Standards | ```sql
usp_RptQAQC_MonthlyReportCRMStANDards
``` |
| Crush Checks | ```sql
usp_RptQAQC_MonthlyReportCrushChecks
``` |
| Blank | ```sql
usp_RptQAQC_MonthlyReportBlank
``` |
| Flushes | ```sql
usp_RptQAQC_MonthlyReportFlushes
``` |
| Standards   Submitted | ```sql
usp_RptQAQC_MonthlyReportStANDardsSubmittedSummary
``` |
| Repeat   Scatter Plot | ```sql
usp_RptQAQC_MonthlyScatterPlotSummary 
usp_RptQAQC_MonthlyScatterPlotGrouping 
usp_RptQAQC_MonthlyScatterPlot_BadRpts 
usp_RptQAQC_MonthlyScatterPlotChart 
``` |
| Screen Test | ```sql
usp_RptQAQC_ScreenTest_Summary 
usp_RptQAQC_ScreenTest 
usp_RptQAQC_ScreenTest_Chart
``` |
| Horwitz   Trumpet | ```sql
usp_RptQAQC_HORwitzTrumpetSummary 
usp_RptQAQC_HORwitzTrumpetChart 
usp_RptQAQC_HORwitzTrumpetBadRepeats 
usp_RptQAQC_HORwitzTrumpetGroup 
usp_RptQAQC_HORwitzTrumpetAverageSTD
``` |
| QQ Plot | ```sql
usp_RptQAQC_MonthlyQQPlotSummary 
usp_RptQAQC_MonthlyQQPlot_Grouping
usp_RptQAQC_MonthlyQQPlotChart 
usp_RptQAQC_MonthlyQQPlot_BadRepeats 
``` |
| Lab   Turnaround | ```sql
usp_RptQAQC_LabTurnaround_Chart 
usp_RptQAQC_LabTurnaround_MonthAvg 
usp_RptQAQC_LabTurnaround_OverallAvg 
``` |
| Batch   Summary | ```sql
usp_RptQAQC_MonthlyReportBatchSummary
``` |