---
title: "MDS v5.0.0 Release Notes"
canonical: "https://servicedesk.maxgeo.com/space/MDS/1646755848/MDS%20v5.0.0%20Release%20Notes"
format: markdown
---
<span style="color: #2e74b5">**							             **</span>


> ⚠️ Please Note! DataShed4 and LogChief3 are no longer supported in MDS v5.0.0

Minim Applicaiton Requirements

| **Application** | **Version** |
| --- | --- |
| SQL Server | 2019 (v15) |
| DataShed5 | v3.1.0 |
| LogChief Lite | v1.2.0 |
| QAQCR | v2.5.6 (Charting only) |


<u>**What’s New												**</u>

This release includes new features, improvements and maintenance fixes listed below. Some of them (*) have been delivered as hot fixes to various clients, as critical issues were determined or other products requirement.

|  |  |
| --- | --- |
| > Macro (anchor)

<span style="color: #ffffff">Component</span> | <span style="color: #ffffff">Description</span> |
| <span style="color: #000000">AutoGridTran extension</span> | <span style="color: #000000">AutoGridTran extension (if installed) objects will be removed</span> |
| <span style="color: #000000">tblAssay</span> | <span style="color: #000000">Removed negative Preferred record that's due to reload assay</span><br><span style="color: #000000">Changed LabElement column length from 25 to 100</span> |
| <span style="color: #000000">tblAssayHyperspectral</span> | <span style="color: #000000">Removed negative Preferred record that's due to reload assay</span><br><span style="color: #000000">Changed LabElement column length from 25 to 100</span> |
| <span style="color: #000000">tblAssayWater</span> | <span style="color: #000000">Removed negative Preferred record that's due to reload assay</span><br><span style="color: #000000">Changed LabElement column length from 25 to 100</span> |
| <span style="color: #000000">tblCATPlanIndex</span> | <span style="color: #000000">Removed column Coord_Map_Datum</span> |
| <span style="color: #000000">tblContractActivityLog</span> | <span style="color: #000000">Removed following FKs:			FK_tblContractActivityLog_tblLIBPerson_Client_Validated_By			FK_tblContractActivityLog_tblLIBPerson_Driller_Validated_By			FK_tblContractActivityLog_tblLIBPerson_Operator			FK_tblContractActivityLog_tblLIBPerson_Operator_Assistant1			FK_tblContractActivityLog_tblLIBPerson_Operator_Assistant2			FK_tblContractActivityLog_tblLIBPerson_Operator_Assistant3			FK_tblContractActivityLog_tblLIBPerson_Operator_Assistant4			FK_tblContractActivityLog_tblLIBPerson_Operator_Assistant5			FK_tblContractActivityLog_tblLIBPerson_Responsible_Person			FK_tblContractActivityLog_tblLIBPerson_Supervisor			FK_tblContractActivityLog_tblLIBPerson_Supervisor_Validated_By</span> |
| <span style="color: #000000">tblContractActivityLogCrew</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblContractDetails</span> | <span style="color: #000000">New column Lab_Turnaround</span> |
| <span style="color: #000000">tblContractHeader</span> | <span style="color: #000000">New column Email_Result_To, Email_Invoice_To</span> |
| <span style="color: #000000">tblDHAlteration</span> | <span style="color: #000000">New trigger TR_tblDHAlteration_Logged_Date</span> |
| <span style="color: #000000">tblDHColl</span> | <span style="color: #000000">Enhanced TR_utblDHColl_Max_Depth to handle tblDH* table has no Hole_ID *</span><br><span style="color: #000000">New trigger TR_itblDHColl_0m_Survey</span><br><span style="color: #000000">Changed Max_Depth to NOT NULL</span><br><span style="color: #000000">New columns Hole_Path, Hole_Position, Location, Program_ID, Target, LL_RL_Method</span><br><span style="color: #000000">Updated TR_iutblDHColl_UsingActiveLIBCode to reflect new columns</span><br><span style="color: #000000">Removed Orig/NAT/Local columns</span><br><span style="color: #000000">Removed LL_Geometry column*</span><br><span style="color: #000000">New column Report_No</span> |
| <span style="color: #000000">tblDHCollPlanned</span> | <span style="color: #000000">TR_iutblDHCollPlanned_DHColl_LCH reflect Orig/NAT/Local removal</span> |
| <span style="color: #000000">tblDHCoreRecoveryRun</span> | <span style="color: #000000">New trigger TR_tblDHCoreRecoveryRun_Logged_Date</span> |
| <span style="color: #000000">tblDHEvents</span> | <span style="color: #000000">New trigger TR_tblDHEvents_Logged_Date</span> |
| <span style="color: #000000">tblDHGeology</span> | <span style="color: #000000">New trigger TR_tblDHGeology_Logged_Date</span> |
| <span style="color: #000000">tblDHGeophysics</span> | <span style="color: #000000">New column Priority</span><br><span style="color: #000000">Changed PK to include Priority column</span><br><span style="color: #000000">Updated TR_iutblDHGeophysics_Interval_Overlap/TR_utblDHGeophysics to reflect PK changes</span> |
| <span style="color: #000000">tblDHGeophysics_SGAMMASUS</span> | <span style="color: #000000">Corrected typo in TR_utblDHGeophysics_SGAMMASUS</span> |
| <span style="color: #000000">tblDHGeophysicsHeader</span> | <span style="color: #000000">Bug fix TR_iutblDHGeophysicsHeader_LAS_Date_Read_Date</span> |
| <span style="color: #000000">tblDHGeophysicsPT</span> | <span style="color: #000000">New column Priority</span><br><span style="color: #000000">Changed PK to include Priority column</span><br><span style="color: #000000">Updated TR_utblDHGeophysicsPT to reflect PK changes</span> |
| <span style="color: #000000">tblDHGeotech</span> | <span style="color: #000000">New trigger TR_tblDHGeotech_Logged_Date</span> |
| <span style="color: #000000">tblDHGeotechLoadStrength</span> | <span style="color: #000000">New column Priority</span><br><span style="color: #000000">Changed PK to include Priority column</span><br><span style="color: #000000">Updated TR_iutblDHGeotechLoadStrength_Interval_Overlap/TR_utblDHGeotechLoadStrength to reflect PK changes</span> |
| <span style="color: #000000">tblDHGeotechLoadStrengthPT</span> | <span style="color: #000000">Dropped FK_tblDHGeotechLoadStrengthPT_tblPTSite_DataSet_Site_ID *</span><br><span style="color: #000000">Renamed Site_ID to Hole_ID *</span><br><span style="color: #000000">Updated PK to reflect Site_ID renamed to Hole_ID *</span><br><span style="color: #000000">New FK_tblDHGeotechLoadStrengthPT_tblDHColl_DataSet_Hole_ID *</span><br><span style="color: #000000">Updated TR_iudtblDHGeotechLoadStrengthPT_Validated/TR_iutblDHGeotechLoadStrengthPT_Depth/TR_iutblDHGeotechLoadStrengthPT_UsingActiveLIBCode/TR_utblDHGeotechLoadStrengthPT to reflect PK change *</span> |
| <span style="color: #000000">tblDHGeotechRMR</span> | <span style="color: #000000">New trigger TR_tblDHGeotechRMR_Logged_Date</span> |
| <span style="color: #000000">tblDHGeotechRQD</span> | <span style="color: #000000">New trigger TR_tblDHGeotechRQD_Logged_Date</span> |
| <span style="color: #000000">tblDHGrouting</span> | <span style="color: #000000">New column Grout_Status</span><br><span style="color: #000000">NEw FK_tblDHGrouting_tblLIBGroutStatus_Grout_Status</span><br><span style="color: #000000">Updated TR_iutblDHGrouting_UsingActiveLIBCode to reflect new column</span> |
| <span style="color: #000000">tblDHHazards</span> | <span style="color: #000000">New table</span> |
|  |  |
| <span style="color: #000000">tblDHLithology</span> | <span style="color: #000000">Updated CK_tblDHLithology_Lith2_Code definition *</span><br><span style="color: #000000">New trigger TR_tblDHLithology_Logged_Date</span><br><span style="color: #000000">New column Lith_Contact_Code/Lith1_Age/Lith2_Age/Lith1_Sorting/Lith2_Sorting/Lith1_Rounding/Lith2_Rounding</span><br><span style="color: #000000">Updated TR_iutblDHLithology_UsingActiveLIBCode to reflect new columns</span> |
| <span style="color: #000000">tblDHMagSus</span> | <span style="color: #000000">New column Priority</span><br><span style="color: #000000">Changed PK to include Priority column</span><br><span style="color: #000000">Updated TR_iutblDHMagSus_AveReading/TR_iutblDHMagSus_Interval_Overlap/TR_utblDHMagSus/TR_iutblDHMagSus_UsingActiveLIBCode to reflect PK changes</span> |
| <span style="color: #000000">tblDHMagSusPT</span> | <span style="color: #000000">New column Priority</span><br><span style="color: #000000">Changed PK to include Priority column</span><br><span style="color: #000000">Updated TR_iutblDHMagSusPT_AveReading/TR_utblDHMagSusPT to reflect PK changes</span> |
| <span style="color: #000000">tblDHMetaData</span> | <span style="color: #000000">Bug fix TR_iutblDHMetaData_Date_Completed *</span> |
| <span style="color: #000000">tblDHMetSamp</span> | <span style="color: #000000">New trigger TR_tblDHMetSamp_Logged_Date</span><br><span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group</span> |
| <span style="color: #000000">tblDHMetSampQC</span> | <span style="color: #000000">New trigger TR_tblDHMetSampQC_Logged_Date</span><br><span style="color: #000000">Enhanced trigger TR_iutblDHMetSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist</span><br><span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group</span> |
| <span style="color: #000000">tblDHMinerals</span> | <span style="color: #000000">New trigger TR_tblDHMinerals_Logged_Date</span><br><span style="color: #000000">New columns Min1_Abundance/Min2_Abundance/Min3_Abundance/Min4_Abundance/Min5_Abundance</span><br><span style="color: #000000">Updated TR_iutblDHMinerals_UsingActiveLIBCode to reflect new columns</span> |
| <span style="color: #000000">tblDHOrientation</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblDHOxidation</span> | <span style="color: #000000">New trigger TR_tblDHOxidation_Logged_Date</span> |
| <span style="color: #000000">tblDHRegolith</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblDHSamp</span> | <span style="color: #000000">New trigger TR_tblDHSamp_Logged_Date</span><br><span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group/Sample_Purpose/Sample_Quality/Sample_Recovery_Code/Composite_SampleID/Has_Fraction</span><br><span style="color: #000000">New FKs</span><br><span style="color: #000000">	FK_tblDHSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span><br><span style="color: #000000">	FK_tblDHSamp_tblLIBSamplePurpose_Sample_Purpose</span><br><span style="color: #000000">	FK_tblDHSamp_tblLIBSampleQuality_Sample_Quality</span><br><span style="color: #000000">	FK_tblDHSamp_tblLIBSampleRecovery_Sample_Recovery_Code</span><br><span style="color: #000000">Updated TR_iutblDHSamp_UsingActiveLIBCode to reflect new columns</span><br><span style="color: #000000">New trigger TR_utblDHSamp_Composite_SampleID</span> |
| <span style="color: #000000">tblDHSampComp</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblDHSampCompFrac</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblDHSampCompFracQC</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblDHSampCompQC</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblDHSampFrac</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblDHSampFracComp</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblDHSampFracCompQC</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblDHSampFracQC</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblDHSampHyper</span> | <span style="color: #000000">New table *</span> |
| <span style="color: #000000">tblDHSampHyperQC</span> | <span style="color: #000000">New table *</span> |
| <span style="color: #000000">tblDHSampQC</span> | <span style="color: #000000">New trigger TR_tblDHSampQC_Logged_Date</span><br><span style="color: #000000">Enhanced TR_iutblDHSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist</span><br><span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group</span> |
| <span style="color: #000000">tblDHSampWater</span> | <span style="color: #000000">New trigger TR_tblDHSampWater_Logged_Date</span> |
| <span style="color: #000000">tblDHSampWaterQC</span> | <span style="color: #000000">New trigger TR_tblDHSampWaterQC_Logged_Date</span> |
| <span style="color: #000000">tblDHStratigraphy</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblDHStructure</span> | <span style="color: #000000">New trigger TR_tblDHStructure_Logged_Date</span> |
| <span style="color: #000000">tblDHStructureOrient</span> | <span style="color: #000000">New column Priority</span><br><span style="color: #000000">Changed PK to include Priority column</span><br><span style="color: #000000">Updated TR_iutblDHStructureOrient_Alpha_Beta_Gamma_Calculate/TR_utblDHStructureOrient/TR_iutblDHStructureOrient_UsingActiveLIBCode to reflect PK changes</span><br><span style="color: #000000">New trigger TR_tblDHStructureOrient_Logged_Date</span> |
| <span style="color: #000000">tblDHSulphides</span> | <span style="color: #000000">New trigger TR_tblDHSulphides_Logged_Date</span><br><span style="color: #000000">New columns Sulph1_Abundance/Sulph2_Abundance/Sulph3_Abundance/Sulph4_Abundance/Sulph5_Abundance</span><br><span style="color: #000000">New FKs</span><br><span style="color: #000000">	FK_tblDHSulphides_tblLIBMinAbundance_Sulph1_Abundance</span><br><span style="color: #000000">	FK_tblDHSulphides_tblLIBMinAbundance_Sulph2_Abundance</span><br><span style="color: #000000">	FK_tblDHSulphides_tblLIBMinAbundance_Sulph3_Abundance</span><br><span style="color: #000000">	FK_tblDHSulphides_tblLIBMinAbundance_Sulph4_Abundance</span><br><span style="color: #000000">	FK_tblDHSulphides_tblLIBMinAbundance_Sulph5_Abundance</span><br><span style="color: #000000">Updated trigger TR_iutblDHSulphides_UsingActiveLIBCode to reflect new columns</span> |
| <span style="color: #000000">tblDHSurv</span> | <span style="color: #000000">Enhanced trigger TR_iudtblDHSurv_Priority_Recalculate to exclude Priority<-999 from recalculate and included Priority change to trigger recalculate</span> |
| <span style="color: #000000">tblDHVeins</span> | <span style="color: #000000">New trigger TR_tblDHVeins_Logged_Date</span> |
| <span style="color: #000000">tblDHWeathering</span> | <span style="color: #000000">New trigger TR_tblDHWeathering_Logged_Date</span> |
| <span style="color: #000000">tblGV_Fields</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblGV_HeaderFields</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblGV_Setup</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblGV_Setup_Extension</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblGV_SetupDataHeaders</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblGV_Tables</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblGV_TablesDataHeaders</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLease</span> | <span style="color: #000000">Increase Lease_No length from 15 to 50</span> |
| <span style="color: #000000">tblLIBAssay_Dispatch_Group</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBCoreDiameter</span> | <span style="color: #000000">New columns Hole_Diameter/Bit_Size</span><br><span style="color: #000000">Add/updated default data</span> |
| <span style="color: #000000">tblLIBCrewRole</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBDispatchPrefix</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBDispatchStatus</span> | <span style="color: #000000">Added default data</span> |
| <span style="color: #000000">tblLIBGroutStatus</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBHazardCode</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBHazardStatus</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBHoleDiameter</span> | <span style="color: #000000">New columns Core_Diameter/Hole_Diameter_Measurement</span><br><span style="color: #000000">Add/updated default data</span> |
| <span style="color: #000000">tblLIBHolePath</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBHolePosition</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBLandform</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBLithAge</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBLithContact</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBLithRegCode</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBLithRegQual</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBLithRegRegime</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBLithRounding</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBLithSorting</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBLocation</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBMinAbundance</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBOrientationConfidence</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBOrientationContinuity</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBOrientationQuality</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBOrientationType</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBProgramID</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBRLMethod</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBSampleFraction</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBSamplePurpose</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBSampleQuality</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBSampleRecovery</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBSampleRelationship</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBSoilCohesion</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBSoilType</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLIBTarget</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLSCoordinates</span> | <span style="color: #000000">New normalised coordinates table</span> |
| <span style="color: #000000">tblLSGeology</span> | <span style="color: #000000">New trigger TR_tblLSGeology_Logged_Date</span> |
| <span style="color: #000000">tblLSMetSamp</span> | <span style="color: #000000">New trigger TR_tblLSMetSamp_Logged_Date</span><br><span style="color: #000000">New column Quartz_Flush/Assay_Dispatch_Group</span><br><span style="color: #000000">New FK_tblLSMetSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span> |
| <span style="color: #000000">tblLSMetSampQC</span> | <span style="color: #000000">New trigger TR_tblLSMetSampQC_Logged_Date</span><br><span style="color: #000000">Enhanced trigger TR_iutblLSMetSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist</span><br><span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group</span><br><span style="color: #000000">New FK_tblLSMetSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span> |
| <span style="color: #000000">tblLSSamp</span> | <span style="color: #000000">New trigger TR_tblLSSamp_Logged_Date</span><br><span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group/Sample_Purpose/Sample_Quality/Sample_Recovery_Code</span><br><span style="color: #000000">New FKs</span><br><span style="color: #000000">	FK_tblLSSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span><br><span style="color: #000000">	FK_tblLSSamp_tblLIBSamplePurpose_Sample_Purpose</span><br><span style="color: #000000">	FK_tblLSSamp_tblLIBSampleQuality_Sample_Quality</span><br><span style="color: #000000">	FK_tblLSSamp_tblLIBSampleRecovery_Sample_Recovery_Code</span><br><span style="color: #000000">Updated trigger TR_iutblLSSamp_UsingActiveLIBCode to reflect new columns</span> |
| <span style="color: #000000">tblLSSampHyper</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLSSampHyperQC</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblLSSampQC</span> | <span style="color: #000000">New trigger TR_tblLSSampQC_Logged_Date</span><br><span style="color: #000000">Enhanced trigger TR_iutblLSSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist</span><br><span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group</span><br><span style="color: #000000">New FK_tblLSSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span> |
| <span style="color: #000000">tblLSSampWater</span> | <span style="color: #000000">New trigger TR_tblLSSampWater_Logged_Date</span> |
| <span style="color: #000000">tblLSSampWaterQC</span> | <span style="color: #000000">New trigger TR_tblLSSampWaterQC_Logged_Date</span> |
| <span style="color: #000000">tblLSSite</span> | <span style="color: #000000">Corrected LL_Geometry formula *</span><br><span style="color: #000000">New columns Location/LL_RL_Method</span><br><span style="color: #000000">New FKs</span><br><span style="color: #000000">	FK_tblLSSite_tblLIBLocation_Location</span><br><span style="color: #000000">	FK_tblLSSite_tblLIBRLMethod_LL_RL_Method</span><br><span style="color: #000000">Updated trigger TR_iutblLSSite_UsingActiveLIBCode to reflect new columns</span><br><span style="color: #000000">Fixed bug in TR_utblLSSite_Max_Length</span><br><span style="color: #000000">Removed Orig/NAT/Local columns</span><br><span style="color: #000000">Removed LL_Geometry column*</span><br><span style="color: #000000">New column Report_No</span> |
| <span style="color: #000000">tblPTCoordinates</span> | <span style="color: #000000">New normalised coordinates table</span> |
| <span style="color: #000000">tblPTMetSamp</span> | <span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group</span><br><span style="color: #000000">New FK_tblPTMetSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span> |
| <span style="color: #000000">tblPTMetSampQC</span> | <span style="color: #000000">Updated trigger TR_iutblPTMetSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist</span><br><span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group</span><br><span style="color: #000000">New FK_tblPTMetSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span> |
| <span style="color: #000000">tblPTSamp</span> | <span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group/Sample_Purpose/Sample_Quality/Sample_Recovery_Code/Soil_Cohesion/Soil_Type</span><br><span style="color: #000000">New FKs</span><br><span style="color: #000000">	FK_tblPTSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span><br><span style="color: #000000">	FK_tblPTSamp_tblLIBSamplePurpose_Sample_Purpose</span><br><span style="color: #000000">	FK_tblPTSamp_tblLIBSampleQuality_Sample_Quality</span><br><span style="color: #000000">	FK_tblPTSamp_tblLIBSampleRecovery_Sample_Recovery_Code</span><br><span style="color: #000000">	FK_tblPTSamp_tblLIBSoilCohesion_Soil_Cohesion</span><br><span style="color: #000000">	FK_tblPTSamp_tblLIBSoilType_Soil_Type</span><br><span style="color: #000000">Updated trigger TR_iutblPTSamp_UsingActiveLIBCode to reflect new columns</span> |
| <span style="color: #000000">tblPTSampHyper</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblPTSampHyperQC</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblPTSampQC</span> | <span style="color: #000000">Updated trigger TR_iutblPTSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist</span><br><span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group</span><br><span style="color: #000000">New FK_tblPTSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span> |
| <span style="color: #000000">tblPTSite</span> | <span style="color: #000000">Corrected LL_Geometry formula *</span><br><span style="color: #000000">New columns Landform/Location/Program_ID/LL_RL_Method</span><br><span style="color: #000000">New FKs</span><br><span style="color: #000000">	FK_tblPTSite_tblLIBLandform_Landform</span><br><span style="color: #000000">	FK_tblPTSite_tblLIBLocation_Location</span><br><span style="color: #000000">	FK_tblPTSite_tblLIBProgramID_Program_ID</span><br><span style="color: #000000">	FK_tblPTSite_tblLIBRLMethod_LL_RL_Method</span><br><span style="color: #000000">Updated trigger TR_iutblPTSite_UsingActiveLIBCode to reflect new columns</span><br><span style="color: #000000">Removed Orig/NAT/Local columns</span><br><span style="color: #000000">Removed LL_Geometry column*</span><br><span style="color: #000000">New column Report_No</span> |
| <span style="color: #000000">tblSampleRegister</span> | <span style="color: #000000">Enhanced logic to handle all sample tables with insert trigger to tblSampleRegister</span><br><span style="color: #000000">Granted update permission to DS_UserPlus</span> |
| <span style="color: #000000">tblSampleRelationship</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblStandardSamp</span> | <span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group/Sampled_By</span><br><span style="color: #000000">New FKs</span><br><span style="color: #000000">	FK_tblStandardSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span><br><span style="color: #000000">	FK_tblStandardSamp_tblLIBPerson_Sampled_By</span> |
| <span style="color: #000000">tblStandardSampQC</span> | <span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group/Sampled_By</span><br><span style="color: #000000">New FKs</span><br><span style="color: #000000">	FK_tblStandardSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span><br><span style="color: #000000">	FK_tblStandardSampQC_tblLIBPerson_Sampled_By</span><br><span style="color: #000000">Updated trigger TR_iutblStandardSampQC_UsingActiveLIBCode to reflect new columns</span> |
| <span style="color: #000000">tblSYSAALAttachment</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblSYSAssBatchDetail</span> | <span style="color: #000000">Changed LabElement column length from 25 to 100</span> |
| <span style="color: #000000">tblSYSAssDispatchDetails</span> | <span style="color: #000000">New column Email_Result_To/Other_Email_Result_To/Email_Invoice_To/Other_Email_Invoice_To</span> |
| <span style="color: #000000">tblSYSAssDispatchGroupDetail</span> | <span style="color: #000000">New column Lab_Turnaround_Requirement</span> |
| <span style="color: #000000">tblSYSAssDispatchHeader</span> | <span style="color: #000000">New column Date_Shipped/TemplateID</span> |
| <span style="color: #000000">tblSYSAssDispatchTemplates</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblSYSAssElement</span> | <span style="color: #000000">New column Report_Grade_Unit/Is_Active/Sort_Order</span> |
| <span style="color: #000000">tblSYSAssIncomingData</span> | <span style="color: #000000">Changed LabElement column length from 25 to 100</span> |
| <span style="color: #000000">tblSYSAssLab</span> | <span style="color: #000000">New column Is_Active/Sort_Order</span> |
| <span style="color: #000000">tblSYSAssLabElementAlias</span> | <span style="color: #000000">Changed LabElement column length from 25 to 100</span> |
| <span style="color: #000000">tblSYSAssLabMethod</span> | <span style="color: #000000">New column Is_Active/Sort_Order</span> |
| <span style="color: #000000">tblSYSAssMethodGeneric</span> | <span style="color: #000000">New column Is_Active/Sort_Order</span> |
| <span style="color: #000000">tblSYSAssQCResultDetail</span> | <span style="color: #000000">New column Repeat</span> |
| <span style="color: #000000">tblSYSConfigRelation</span> | <span style="color: #000000">Added configuration for Hyperspectral tables</span><br><span style="color: #000000">Remove any configured table no longer exist</span> |
| <span style="color: #000000">tblSYSConfigRelationField</span> | <span style="color: #000000">Added configuration for Hyperspectral tables</span> |
| <span style="color: #000000">tblSYSDSConfig</span> | <span style="color: #000000">Added configuration for Hyperspectral tables</span><br><span style="color: #000000">Added SampleDispatch and DMP extension configs</span> |
| <span style="color: #000000">tblSYSExtSQLStatement</span> | <span style="color: #000000">Updated SQLCode for MAX035 *</span><br><span style="color: #000000">Updated extension SQLCodes</span> |
| <span style="color: #000000">tblSYSFilter</span> | <span style="color: #000000">New column Filter_Definition</span> |
| <span style="color: #000000">tblSYSFilterItem</span> | <span style="color: #000000">New column FilterItem_Definition</span> |
| <span style="color: #000000">tblSYSIncomingDataMasks</span> | <span style="color: #000000">Fixed bug in TR_iutblSYSIncomingDataMasks_Identifier to do check properly</span> |
| <span style="color: #000000">tblSYSLASItemMapping</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblSYSLASMapping</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblSYSLASSourceItem</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblSYSLASSourceItemGroup</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblSYSLASUserInputField</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblSYSNormAttributeDef</span> | <span style="color: #000000">Added configuration for Hyperspectral tables</span> |
| <span style="color: #000000">tblSYSObject</span> | <span style="color: #000000">Added configuration for Hyperspectral tables</span><br><span style="color: #000000">Added new user DSSYSADMIN/DSUSERPLUS</span> |
| <span style="color: #000000">tblSYSObjectGroup</span> | <span style="color: #000000">Added configuration for Hyperspectral tables</span> |
| <span style="color: #000000">tblSYSParam</span> | <span style="color: #000000">Added SampleDispatch configs</span> |
| <span style="color: #000000">tblSYSSampleCutSheet</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblSYSSampleCutSheetConfig</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblSYSSampleCutSheetDetails</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblSYSSampleCutSheetTemplates</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblSYSSRSAffineTransform</span> | <span style="color: #000000">New table for new grid transformation</span> |
| <span style="color: #000000">tblSYSSRSConfidenceLevel</span> | <span style="color: #000000">New table for new grid transformation</span> |
| <span style="color: #000000">tblSYSSRSControlPoints</span> | <span style="color: #000000">New table for new grid transformation</span> |
| <span style="color: #000000">tblSYSSRSCoordinateSystem</span> | <span style="color: #000000">New column AuthorityCode</span><br><span style="color: #000000">Populated AuthorityCode</span><br><span style="color: #000000">Removed column DatumCode, ProjectionCode</span> |
| <span style="color: #000000">tblSYSSRSDatum</span> | <span style="color: #000000">Removed table</span> |
| <span style="color: #000000">tblSYSSRSEllipsoid</span> | <span style="color: #000000">Removed table</span> |
| <span style="color: #000000">tblSYSSRSProjection</span> | <span style="color: #000000">Removed table</span> |
| <span style="color: #000000">tblSYSSRSProjectionType</span> | <span style="color: #000000">Removed table</span> |
| <span style="color: #000000">tblSYSSRSTransformations</span> | <span style="color: #000000">New table for new grid transformation</span> |
| <span style="color: #000000">tblSYSSRSTransformationType</span> | <span style="color: #000000">New table for new grid transformation</span> |
| <span style="color: #000000">tblSYSXRFIncomingData</span> | <span style="color: #000000">Changed LabElement column length from 25 to 100</span> |
| <span style="color: #000000">tblVWDHAuditView</span> | <span style="color: #000000">Removed Orig/NAT/Local columns</span> |
| <span style="color: #000000">tblVWDHCollarAttributes</span> | <span style="color: #000000">Removed Orig/NAT/Local columns</span> |
| <span style="color: #000000">tblVWDHCollSurv</span> | <span style="color: #000000">Removed Orig/NAT/Local columns</span> |
| <span style="color: #000000">tblVWDHCoordinates</span> | <span style="color: #000000">New view</span> |
| <span style="color: #000000">tblVWDHCoordinateTransformations</span> | New view |
| <span style="color: #000000">tblVWDHMaxAssays</span> | <span style="color: #000000">Removed Orig/NAT/Local columns</span> |
| <span style="color: #000000">tblVWLSCoordinates</span> | New view |
| <span style="color: #000000">tblVWLSCoordinateTransformations</span> | New view |
| <span style="color: #000000">tblVWLSLogging</span> | Removed Orig/NAT/Local columns |
| <span style="color: #000000">tblVWLSMaxAssays</span> | Removed Orig/NAT/Local columns |
| <span style="color: #000000">tblVWLSSamp</span> | Removed Orig/NAT/Local columns |
| <span style="color: #000000">tblVWPTCoordinates</span> | New view |
| <span style="color: #000000">tblVWPTCoordinateTransformations</span> | New view |
| <span style="color: #000000">tblVWDHLithology</span> | <span style="color: #000000">Replaced * with actual column list in the view definition</span> |
| <span style="color: #000000">tblVWDispatchSelectSamples</span> | <span style="color: #000000">New view</span> |
| <span style="color: #000000">tblVWMissingSamplesAlreadyAssayed</span> | <span style="color: #000000">New view</span> |
| <span style="color: #000000">tblVWPTAssays</span> | <span style="color: #000000">Removed Orig/NAT/Local columns</span> |
| <span style="color: #000000">tblVWPTAssaysQC</span> | <span style="color: #000000">Added LabCode/Batch_No/GenericMethod</span> |
| <span style="color: #000000">tblVWPTAssaysWater</span> | <span style="color: #000000">Removed Orig/NAT/Local columns</span> |
| <span style="color: #000000">tblVWPTLogging</span> | <span style="color: #000000">Removed Orig/NAT/Local columns</span> |
| <span style="color: #000000">tblVWPTMaxAssays</span> | <span style="color: #000000">Removed Orig/NAT/Local columns</span> |
| <span style="color: #000000">tblVWPTSamp</span> | <span style="color: #000000">Removed Orig/NAT/Local columns</span> |
| <span style="color: #000000">tblVWQF_Samples</span> | <span style="color: #000000">New view</span> |
| <span style="color: #000000">tblVWReportCollar</span> | <span style="color: #000000">Removed Orig/NAT/Local columns</span> |
| <span style="color: #000000">tblVWSYSDispatchedSamples_CSV_Export</span> | <span style="color: #000000">New view for DS5 dispatch export</span> |
| <span style="color: #000000">tblVWWSDHColl</span> | <span style="color: #000000">Added filter on Priority 0</span> |
| <span style="color: #000000">tblVWWSXRFResults</span> | <span style="color: #000000">Removed Orig/NAT/Local columns</span> |
| <span style="color: #000000">tblXRFDHSampQC</span> | <span style="color: #000000">Updated trigger TR_iutblXRFDHSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist</span> |
| <span style="color: #000000">tblXRFResults</span> | <span style="color: #000000">Changed GenericMethod column length from 10 to 25</span><br><span style="color: #000000">Changed AssayResultNum/LimitLower/LimitUpper/sysResult/StdDev column decimal point from 6 to 9</span><br><span style="color: #000000">Changed LabElement column length from 25 to 100</span> |
| <span style="color: #000000">tblVWXRFIncomingResults</span> | <span style="color: #000000">Removed Orig/NAT/Local columns</span> |
| <span style="color: #000000">tblVWXRFResults</span> | <span style="color: #000000">Removed Orig/NAT/Local columns</span> |
| <span style="color: #000000">tblVWXRFResultsQC</span> | <span style="color: #000000">Removed Orig/NAT/Local columns</span> |
| <span style="color: #000000">tblXRFStandardSamp</span> | <span style="color: #000000">Updated trigger TR_itblXRFStandardSamp to fix bug with SourceTable name</span> |
| <span style="color: #000000">udf_CalcAvgSysResult</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_CheckAzimuthDeviation</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_CheckDipDeviation</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_ChecksumRemoveSpace</span> | <span style="color: #000000">New internal used function *</span> |
| <span style="color: #000000">udf_DistanceWAveDipAzi</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_GetBatch_No</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_GetDataSetForProdLocation</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_GetDispatchNo</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_GetGenericAndOrigMethodBatchNo</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_GetGenericMethod</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_GetLabCode</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_GetOrigMethod</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_GetViewOrderByList</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_OrientDipAzi</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_OrientDipDirection</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_RoboCalc</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">udf_RptGetFieldConvert</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">usp_AppUpsertJsonData</span> | <span style="color: #000000">New SP internal used by application</span> |
| <span style="color: #000000">usp_AdminBatchDelete</span> | <span style="color: #000000">Enhanced logic to handle sample involved in mulitple batches *</span><br><span style="color: #000000">Added handle of tblXRFResultsHeader *</span> |
| <span style="color: #000000">usp_DataAssayMergingProcess</span> | <span style="color: #000000">Reworked logic for Total/Merged counts</span><br><span style="color: #000000">	SampleCount: total unique sample counts in all assay and buffer tables combo</span><br><span style="color: #000000">	SampleMerged: unique sample counts in all assay tables</span><br><span style="color: #000000">	ResultCount: total unique (sampleid/genericmethod/element/repeat) assay records in all assay and buffer tables combo</span><br><span style="color: #000000">	ResultMerged: assay record count for Preferred=0 (or -1000).</span><br><span style="color: #000000">Added handle of other assay tables *</span><br><span style="color: #000000">Remove negative preferred records that's due to assay reloading</span> |
| <span style="color: #000000">usp_DataAssayQCRuleChecker</span> | <span style="color: #000000">Changed @Orig_SampleID from NVARCHAR(30) to NVARCHAR(50) *</span><br><span style="color: #000000">Added handle of other assay tables</span><br><span style="color: #000000">Added handle of Repeat</span><br><span style="color: #000000">Enhanced logic to not throw error "QC reference values missing" if a standard does not have the element configured (QCResultFailCode: STD5)</span> |
| <span style="color: #000000">usp_CRSApplyTransformation_DH</span> | <span style="color: #000000">New SP used by new grid transformation process</span> |
| <span style="color: #000000">usp_CRSApplyTransformation_FS</span> | <span style="color: #000000">New SP used by new grid transformation process</span> |
| <span style="color: #000000">usp_CRSApplyTransformation_LS</span> | <span style="color: #000000">New SP used by new grid transformation process</span> |
| <span style="color: #000000">usp_CRSApplyTransformation_PT</span> | <span style="color: #000000">New SP used by new grid transformation process</span> |
| <span style="color: #000000">usp_CRSFindAffineParameters</span> | <span style="color: #000000">New SP used by new grid transformation process</span> |
| <span style="color: #000000">usp_CRSTransform</span> | <span style="color: #000000">New SP used by new grid transformation process</span> |
| <span style="color: #000000">usp_CRSTransformToLatLong_DH</span> | <span style="color: #000000">New SP used by new grid transformation process</span> |
| <span style="color: #000000">usp_CRSTransformToLatLong_FS</span> | <span style="color: #000000">New SP used by new grid transformation process</span> |
| <span style="color: #000000">usp_CRSTransformToLatLong_LS</span> | <span style="color: #000000">New SP used by new grid transformation process</span> |
| <span style="color: #000000">usp_CRSTransformToLatLong_PT</span> | <span style="color: #000000">New SP used by new grid transformation process</span> |
| <span style="color: #000000">usp_DataAssayUpdateBatchStatus</span> | <span style="color: #000000">Added handle of other assay tables</span><br><span style="color: #000000">Added logic to de-prefer UP value. If there are UP Values in the re-assay batch these samples need to have a higher preferred and the previous loaded assay (sysAssStatus IS NULL) needs to have a preferred of 0</span> |
| <span style="color: #000000">usp_DataDesurvey</span> | <span style="color: #000000">Enhanced logic for preventing multiple concurrent run *</span><br><span style="color: #000000">Added option to skip desurvey survey table *</span><br><span style="color: #000000">Added logic to ignore validated holes *</span><br><span style="color: #000000">Enhanced logic to handle DH/LS table using Depth instead of Depth_From/Depth_To or Length_From/Length_To</span> |
| <span style="color: #000000">usp_DataSurveyDeviationChecker</span> | <span style="color: #000000">Add logic to exclude validated hole/site</span> |
| <span style="color: #000000">usp_DataXRFResultsMergingProcess</span> | <span style="color: #000000">Fixed total counts logic *</span> |
| <span style="color: #000000">Usp_ProcessImportData</span> | <span style="color: #000000">New DS5 used SP for import data</span> |
| <span style="color: #000000">usp_ProcessInComingDataDriver</span> | <span style="color: #000000">Exclude tblSYSIncomingDataMasks.Is_Active=0 *</span><br><span style="color: #000000">Added handle for lab Sample_Type/Sample_Method/Sampled_By/Sampled_Date</span><br><span style="color: #000000">Added handle for nested matching of identifiers, like %SARM-4% and %SARM-48%</span><br><span style="color: #000000">Added logic to validate configured sample table exists</span><br><span style="color: #000000">Added check Depth_From column exists on table not classified as Point table</span> |
| <span style="color: #000000">usp_ProcessLabChecksInComingData</span> | <span style="color: #000000">Added handle for lab Sample_Type/Sample_Method/Sampled_By/Sampled_Date</span><br><span style="color: #000000">Added handle for nested matching of identifiers, like %SARM-4% and %SARM-48%</span> |
| <span style="color: #000000">usp_ProcessStandardsInComingData</span> | <span style="color: #000000">Added handle for lab Sample_Type/Sample_Method/Sampled_By/Sampled_Date</span><br><span style="color: #000000">Added handle for nested matching of identifiers, like %SARM-4% and %SARM-48%</span> |
| <span style="color: #000000">usp_ProcessXRFInComingDataDriver</span> | <span style="color: #000000">Added handle for nested matching of identifiers, like %SARM-4% and %SARM-48%</span> |
| <span style="color: #000000">usp_ProcessXRFLabChecksInComingData</span> | <span style="color: #000000">Added handle for nested matching of identifiers, like %SARM-4% and %SARM-48%</span> |
| <span style="color: #000000">usp_ProcessXRFStandardsInComingData</span> | <span style="color: #000000">Added handle for nested matching of identifiers, like %SARM-4% and %SARM-48%</span> |
| <span style="color: #000000">usp_RptQAQC_MonthlyScatterPlot_BadRpts</span> | <span style="color: #000000">Added missing join on GenericMethod *</span> |
| <span style="color: #000000">usp_RptQAQC_MonthlyScatterPlotChart</span> | <span style="color: #000000">Added missing join on GenericMethod *</span> |
| <span style="color: #000000">usp_RptQAQC_MonthlyScatterPlotGrouping</span> | <span style="color: #000000">Added missing join on GenericMethod *</span> |
| <span style="color: #000000">usp_RptQAQC_MonthlyScatterPlotSummary</span> | <span style="color: #000000">Added missing join on GenericMethod *</span> |
| <span style="color: #000000">usp_RptStripLog</span> | <span style="color: #000000">Removed SP</span> |
| <span style="color: #000000">usp_RptStripLogHeader</span> | <span style="color: #000000">Removed SP</span> |
| <span style="color: #000000">uspIC_InterceptCalculator</span> | <span style="color: #000000">Enhanced logic to improve performance when source data (SampleTable) is view *</span> |
| <span style="color: #000000">utf_CRSAffineTransform3D</span> | <span style="color: #000000">New function used by new grid transformation process</span> |
| <span style="color: #000000">utf_Desurvey</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">utf_GetGenericAndOrigMethodBatchNo</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">utf_GetReportDays</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">utf_MXAuditExceptionAppList</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">utf_StringSpliter</span> | <span style="color: #000000">Granted execute permission to DS_SysAdmin/DS_UserPlus</span> |
| <span style="color: #000000">All triggers using TRIGGER_NESTLEVEL() filter</span> | <span style="color: #000000">Enhanced logic to handle insert/update via view</span> |
| <span style="color: #000000">All tables</span> | <span style="color: #000000">Removed ts column</span> |


Following are new features, improvements, and maintenance fixes for Production model objects:

|  |  |
| --- | --- |
| Component | Description |
| <span style="color: #000000">tblFSCoordinates</span> | <span style="color: #000000">New normalised coordinates table</span> |
| <span style="color: #000000">tblFSGeology</span> | <span style="color: #000000">New trigger TR_tblFSGeology_Logged_Date</span> |
| <span style="color: #000000">tblFSMetSamp</span> | <span style="color: #000000">New trigger TR_tblFSMetSamp_Logged_Date</span><br><span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group</span><br><span style="color: #000000">New FK_tblFSMetSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span> |
| <span style="color: #000000">tblFSMetSampQC</span> | <span style="color: #000000">New trigger TR_tblFSMetSampQC_Logged_Date</span><br><span style="color: #000000">Enhanced trigger TR_iutblFSMetSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist</span><br><span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group</span><br><span style="color: #000000">New FK_tblFSMetSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span> |
| <span style="color: #000000">tblFSSamp</span> | <span style="color: #000000">New trigger TR_tblFSSamp_Logged_Date</span><br><span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group/Sample_Purpose/Sample_Quality/Sample_Recovery_Code</span><br><span style="color: #000000">New FKs</span><br><span style="color: #000000">	FK_tblFSSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span><br><span style="color: #000000">	FK_tblFSSAMP_tblLIBSamplePurpose_Sample_Purpose</span><br><span style="color: #000000">	FK_tblFSSAMP_tblLIBSampleQuality_Sample_Quality</span><br><span style="color: #000000">	FK_tblFSSAMP_tblLIBSampleRecovery_Sample_Recovery_Code</span><br><span style="color: #000000">Updated trigger TR_iutblFSSamp_UsingActiveLIBCode to reflect new columns</span> |
| <span style="color: #000000">tblFSSampHyper</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblFSSampHyperQC</span> | <span style="color: #000000">New table</span> |
| <span style="color: #000000">tblFSSampQC</span> | <span style="color: #000000">New trigger TR_tblFSSampQC_Logged_Date</span><br><span style="color: #000000">Enhanced trigger TR_iutblFSSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist</span><br><span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group</span><br><span style="color: #000000">New FK_tblFSSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span> |
| <span style="color: #000000">tblFSSampWater</span> | <span style="color: #000000">New trigger TR_tblFSSampWater_Logged_Date</span> |
| <span style="color: #000000">tblFSSampWaterQC</span> | <span style="color: #000000">New trigger TR_tblFSSampWaterQC_Logged_Date</span> |
| <span style="color: #000000">tblFSSite</span> | <span style="color: #000000">Corrected LL_Geometry formula *</span><br><span style="color: #000000">New columns Location/LL_RL_Method</span><br><span style="color: #000000">New FKs</span><br><span style="color: #000000">	FK_tblFSSite_tblLIBLocation_Location</span><br><span style="color: #000000">	FK_tblFSSite_tblLIBRLMethod_LL_RL_Method</span><br><span style="color: #000000">Updated trigger TR_iutblFSSite_UsingActiveLIBCode to reflect new columns</span><br><span style="color: #000000">Removed Orig/NAT/Local columns</span><br><span style="color: #000000">Updated column Parent_Face_ID/Responsible_Person/Historic_Face_ID description</span><br><span style="color: #000000">Removed LL_Geometry column*</span><br><span style="color: #000000">New column Report_No</span> |
| <span style="color: #000000">tblFSSurv</span> | <span style="color: #000000">Updated column Depth/Temp/Temp_UnitCode description</span> |
| <span style="color: #000000">tblLIBProdBlockSource</span> | <span style="color: #000000">Removed table</span> |
| <span style="color: #000000">tblLIBProdMovementType</span> | <span style="color: #000000">Removed table</span> |
| <span style="color: #000000">tblLIBProdParentStope</span> | <span style="color: #000000">Removed table</span> |
| <span style="color: #000000">tblProdActivity</span> | <span style="color: #000000">Removed columns Activity_Date/Shift/LGSD</span><br><span style="color: #000000">Removed TR_iutblProdActivity_Activity_Date_Shift_ShiftDateCode</span><br><span style="color: #000000">Changed Operator to allow null</span><br><span style="color: #000000">Changed Activity_Amount to not allow null</span> |
| <span style="color: #000000">tblProdBlasting</span> | <span style="color: #000000">Removed columns  ShiftDateCode/LG_SD</span><br><span style="color: #000000">Removed TR_iutblProdBlasting_Blast_Date_Shift_ShiftDateCode</span> |
| <span style="color: #000000">tblProdBlastingBlock</span> | <span style="color: #000000">New FK_tblProdBlastingBlock_tblProdBlasting_Blast_Cut_ID</span><br><span style="color: #000000">Removed column LG_SD</span> |
| <span style="color: #000000">tblProdBlastingBlockSurvey</span> | <span style="color: #000000">Removed columns ShiftDateCode/LGSD</span><br><span style="color: #000000">Removed TR_iutblProdBlastingBlockSurvey_Survey_Date_Shift_ShiftDateCode</span><br><span style="color: #000000">Changed PK</span> |
| <span style="color: #000000">tblProdBlastingSurvey</span> | <span style="color: #000000">New FK_tblProdBlastingSurvey_tblProdBlasting_Blast_Cut_ID</span><br><span style="color: #000000">Removed column ShiftDateCode</span><br><span style="color: #000000">Changed PK</span> |
| <span style="color: #000000">tblProdBlockCommodities</span> | <span style="color: #000000">Removed DF_tblProdBlockCommodities_Grade_Unit</span> |
| <span style="color: #000000">tblProdBlockPlanned</span> | <span style="color: #000000">Changed Material_Type to allow null</span> |
| <span style="color: #000000">tblProdBlockPlannedCommodities</span> | <span style="color: #000000">Removed DF_tblProdBlockPlannedCommodities_Planned_Grade_Unit</span> |
| <span style="color: #000000">tblProdBlockReserve</span> | <span style="color: #000000">Removed columns GridID/X/Y/Z</span><br><span style="color: #000000">Changed Material_Type to allow null</span> |
| <span style="color: #000000">tblProdBlockReserveCommodities</span> | <span style="color: #000000">Removed DF_tblProdBlockReserveCommodities_Reserve_Grade_Unit</span> |
| <span style="color: #000000">tblProdBlockResource</span> | <span style="color: #000000">Changed Material_Type to allow null</span><br><span style="color: #000000">Removed columns GridID/X/Y/Z</span> |
| <span style="color: #000000">tblProdBlockResourceCommodities</span> | <span style="color: #000000">Removed DF_tblProdBlockResourceCommodities_Resource_Grade_Unit</span> |
| <span style="color: #000000">tblProdEquipmentUtilisation</span> | <span style="color: #000000">Changed columns Fuel_Status/Supervisor to allow null *</span><br><span style="color: #000000">Removed columns Scheduled_Date/Shift/LG_SD</span> |
| <span style="color: #000000">tblProdLocationBalance</span> | <span style="color: #000000">New column NegativeBalanceAmount</span> |
| <span style="color: #000000">tblProdMaterialMovement</span> | <span style="color: #000000">Changed column Time_Loaded to allow null *, removed default constraint and changed data type to tim(7)</span><br><span style="color: #000000">Changed Time_Dumped to allow null and changed data type to tim(7)</span><br><span style="color: #000000">Removed columns Movement_Type/LG_SD/ShiftDateCode</span> |
| <span style="color: #000000">tblProdSamp</span> | <span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group</span><br><span style="color: #000000">New FK_tblProdSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span><br><span style="color: #000000">Changed Sampled_Date to allow null</span><br><span style="color: #000000">Removed columns ShiftDateCode/LG_SD</span> |
| <span style="color: #000000">tblProdSampQC</span> | <span style="color: #000000">Updated trigger TR_iutblProdSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist</span><br><span style="color: #000000">New columns Quartz_Flush/Assay_Dispatch_Group</span><br><span style="color: #000000">New FK_tblProdSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group</span><br><span style="color: #000000">Removed columns ShiftDateCode/LG_SD</span> |
| <span style="color: #000000">tblProdShiftRegister</span> | <span style="color: #000000">Removed column LG_SD</span> |
| <span style="color: #000000">tblProdSiteAssay</span> | <span style="color: #000000">New columns Modified_Date/Modified_By/ts</span><br><span style="color: #000000">New trigger TR_utblProdSiteAssay</span><br><span style="color: #000000">New FK_tblProdSiteAssay_tblProdSiteRegister_Prod_SourceID</span> |
| <span style="color: #000000">tblProdSurvey</span> | <span style="color: #000000">Removed columns ShiftDateCode/LG_SD</span><br><span style="color: #000000">Changed PK</span> |
| <span style="color: #000000">tblProdSurveyCommodity</span> | <span style="color: #000000">Added column Surveyed_Date</span><br><span style="color: #000000">Removed columns ShiftDateCode/LG_SD</span> |
| <span style="color: #000000">tblProdWeightometer</span> | <span style="color: #000000">Removed table</span> |
| <span style="color: #000000">tblVWFSCoordinates</span> | New view |
| <span style="color: #000000">tblVWFSCoordinateTransformations</span> | New view |
| <span style="color: #000000">tblVWFSLogging</span> | Removed Orig/NAT/Local columns |
| <span style="color: #000000">tblVWFSMaxAssays</span> | Removed Orig/NAT/Local columns |
| <span style="color: #000000">tblVWFSSamp</span> | Removed Orig/NAT/Local columns |
| <span style="color: #000000">tblVWProdActivity</span> | New view |
| <span style="color: #000000">tblVWProdEOMActualsStockpilesMerged</span> | Reflect table column name change |
| <span style="color: #000000">tblVWProdEquipmentUtilisation</span> | Added tblProdShiftRegister |
| <span style="color: #000000">tblVWProdLocationBalance</span> | Updated view to used tblSYSAssElement.Report_Grade_Unit |
| <span style="color: #000000">tblVWProdMaterialMovement</span> | Added Assay_Grade_Unit |
| <span style="color: #000000">tblVWProdReconTrucktoResource</span> | Added Assay_Grade_Unit column, IsPrimary filter |
| <span style="color: #000000">tblVWProdTruckingCalculated</span> | Added Assay_Grade_Unit<br>Mined value using assay grade when ProdReport_GradeFromAssay is configured<br>Updated Mined_Metal/Mined_Ounces calculation |
| <span style="color: #000000">tblVWProdTruckingClaimed</span> | Added Assay_Grade_Unit |
| <span style="color: #000000">usp_PopulateProdSiteAssay</span> | Treat NULL Shift as dayshift (‘D’) |
| <span style="color: #000000">usp_PopulateProdLocationBalance</span> | <span style="color: #000000">If survey grade is NULL or 0, using calculated grade from previous day</span><br><span style="color: #000000">Record actual negative value been reset</span> |


Following are new features, improvements, and maintenance fixes for Diamond model objects:

|  |  |
| --- | --- |
| Component | Description |
| <span style="color: #000000">tblDHMinerals</span> | <span style="color: #000000">New column Min_Abundance</span><br><span style="color: #000000">New FK_tblDHMinerals_tblLIBMinAbundance_Min_Abundance</span><br><span style="color: #000000">Updated TR_iutblDHMinerals_UsingActiveLIBCode to reflect new column</span> |


Following are new features, improvements, and maintenance fixes for Coal model objects:

|  |  |
| --- | --- |
| Component | Description |
| <span style="color: #000000">tblDHSulphides</span> | <span style="color: #000000">New trigger TR_iutblDHSulphides_UsingActiveLIBCode</span> |