Quick Reference

Menu map, demo-data codes and statuses

Group Models
Exploration & Licences Project, Exploration Licence, Licence Condition, Land Access Agreement, Exploration Program, Target
Drill Planning & Holes Drill Plan, Drill Site, Drillhole, Hole Collar Survey, Downhole Survey
Drilling Operations Drilling Contract, Rig, Rig Assignment, Drilling Shift, Daily Drilling Report, Drilling Activity, Drilling Delay, Hole Interval, Bit Run, Drilling Consumable Usage
Geology & Core Geology Log, Lithology Dictionary, Alteration Log, Mineralisation Log, Structure Log, Geotechnical Log, Core Run, Core Tray, Core Photo
Sampling & Assay Sample, Sampling Batch (+Items), Sample Preparation, Sample Dispatch, Chain Of Custody Event, Laboratory Job, Analysis Method, Assay Result, Reference Material (+Values), QAQC Insertion, QAQC Evaluation, Assay Validation, Storage Location, Sample Storage
Equipment & Maintenance Equipment, Equipment Meter Reading, Inspection Template (+Items), Inspection, Inspection Result, Maintenance Plan, Work Order, Inventory Item, Inventory Transaction
Safety, Environment & Rehab Risk Assessment, Hazard, Control, Incident, Corrective Action, Environmental Observation, Rehabilitation Plan, Rehabilitation Activity, Rehabilitation Inspection
Compliance & Reporting Source Authority, Source Document, Requirement, Requirement Applicability, Regulatory Report, Data Submission, Submission File, Validation Issue, Expenditure Record
Administration Organisation, Person, Jurisdiction, Document, Competency, Person Competency

Key Codes in the Demo Data

Code What it is
MGP / E28/2841 Mulga Rocks Gold Project and its exploration licence (WA)
MGP-26D / DP-MGP-001 The 2026 RC/DD drilling program and its approved drill plan
MRD-001 Diamond hole — completed, target intersected: VG in a quartz vein at 185.4 m
MRD-001W1 Planned wedge daughter of MRD-001
MRC-002 RC hole — mid-drilling at 96 m, stopped by a compressor breakdown
MGP-B001 / DSP-0001 Sample batch (6 core + blank/standard/duplicate) and its lab dispatch
KAL26-04477 Laboratory job — best result 12.7 g/t Au (MGP-S0004)
OREAS-204 Certified standard that fails QA/QC (2.31 vs 2.05 g/t) → corrective action
WO-0001 Urgent breakdown work order — compressor EQ-COMP01 on RIG-RC02
INC-2026-001 Near-miss on the MRS-02 access spur, under investigation
SUB-0001 Drilling data submission for the annual report (one corrected validation issue)

Status Vocabularies (the important ones)

Drillhole lifecycle: planned → approved → drilling → suspended → completed → abandoned → rehabilitated, with outcome target_intersected · target_not_intersected · incomplete · lost_hole

Sample lifecycle: planned → collected → prepared → dispatched → received → assayed → retained → disposed

Assay result: result status provisional → accepted → rejected → superseded; validation status unchecked → passed / warning / failed

QA/QC outcome: pass · warning · fail — evaluated against certified values (standards), tolerance (duplicates) and detection limits (blanks); job-level validation lands accepted · conditionally_accepted · rejected · reanalysis_required

Work order: requested → approved → planned → in_progress → completed → cancelled

Data submission: generated → validating → validation_failed → ready → submitted → accepted / rejected

Rules of Thumb

  • A hole's logs, samples and expenditure all key on the hole — start at the Drillhole and drill down rather than searching child tables directly.
  • Every sampling batch carries its QA/QC insertions (blank, certified standard, field duplicate ~1 in 20); a failed standard holds the whole job at conditionally accepted until re-assayed.
  • Shift delay hours are classified (weather, mechanical, …) because the drilling contract settles standby differently per cause.
  • A completed hole triggers the rehabilitation clock — licence condition C7 gives six months to cap, backfill and respread.
  • Below-detection assays are stored with a less_than qualifier, not a zero — the regulator's template wants the −LLD convention on export.
  • Suspect downhole surveys (magnetic interference near mineralisation) are kept and flagged, never deleted — the gyro re-shot supersedes them.