---
title: "Drilling Summary Dashboard Data Requirements"
canonical: "https://servicedesk.maxgeo.com/space/DS/1846837252/Drilling%20Summary%20Dashboard%20Data%20Requirements"
format: markdown
---
This document outlines the SQL Server database tables and fields required to populate the drilling dashboard.

![Drilling Dashboard Image.png](media://973a184c-0648-469b-86f4-40fd61f70020)

# Required Tables and Fields

## 1. dbo.tblSYSUserDataset

Fields: UserName, SelectionName, DataSet, Modified_By, Loaded_By, Modified_Date, Load_Date  
Purpose: Stores user dataset selections to filter active datasets (e.g., ACTIVEDS).

## 2. dbo.tblContractProjectArea

Fields: ContractID, Project_Area, DataSet  
Purpose: Links projects and areas with contract records, used for filtering and joining activity logs.

## 3. dbo.tblContractActivityLog

Fields: ActivityID, ContractID, Activity_Log_Date, MachineryID  
Purpose: Stores activity log entries per contract, including machinery used and log dates.

## 4. dbo.tblContractActivityLogMetres

Fields: ActivityID, ContractID, DataSet, Hole_ID, Drill_Item, Depth_From, Depth_To  
Purpose: Stores drilling metre details, hole information, and drill items.

## 5. dbo.tblVWDASHContractCosts

Fields: DataSet, Hole_ID, ContractID, ActivityID, Log_Date, Shift, Item_Category, Item_Code, TotalCost, Quantity, MachineryID, Drill_Item  
Purpose: Central view used for calculating drilling progress, metres drilled per shift, and costs.

## 6. dbo.tblBudgets

Fields: Reporting_Type (ContractID), Reporting_Period, Budget_Date, Budget_Quantity, Budget_Amount  
Purpose: Provides planned budget quantities and costs, compared against actuals.

## 7. dbo.tblDHColl

Fields: DataSet, Hole_ID, Max_Depth (Planned_Depth), Hole_Status, Hole_Purpose, Prospect, Date_Completed, Current_Depth, Total_Depth  
Purpose: Stores drill hole master data and progress information.

## 8. dbo.tblContractHeader

Fields: ContractID, Contract_End_Date  
Purpose: Provides contract-level details such as end dates for activity tracking.

## 9. dbo.tblVWDASHFilter

Fields: DataSet  
Purpose: Stores available dataset filters for dashboard dropdowns.

# Dashboard Component Mapping

1. Total Metres Drilled Per Shift → tblVWDASHContractCosts, tblBudgets  
2. Cost Per Metre → tblVWDASHContractCosts, tblBudgets  
3. Drill Hole Progress → tblDHColl, tblContractActivityLogMetres, tblContractActivityLog  
4. Item Categories (Cost Breakdown) → tblVWDASHContractCosts  
5. Filters (DataSet, Project, Drill Rig, HoleID, Drill Items) → tblSYSUserDataset, tblVWDASHFilter, tblContractProjectArea