--- title: "MDS v4.6.6 and below Release Notes" canonical: "https://servicedesk.maxgeo.com/space/MDS/1647017985/MDS%20v4.6.6%20and%20below%20Release%20Notes" format: markdown ---
v4.6.6 ************************************* Following changes are for v4.6.6 ALL models *************************************       --tblAssay             Removed negative Preferred record that's due to reload assay             Changed LabElement column length from 25 to 100                   --tblAssayHyperspectral             Removed negative Preferred record that's due to reload assay             Changed LabElement column length from 25 to 100             --tblAssayWater             Removed negative Preferred record that's due to reload assay             Changed LabElement column length from 25 to 100                   --tblCATPlanIndex             Removed column Coord_Map_Datum             --tblContractActivityLog             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         --tblContractActivityLogCrew             New table                   --tblContractDetails             New column Lab_Turnaround                   --tblContractHeader             New column Email_Result_To, Email_Invoice_To                   --tblDHAlteration             New trigger TR_tblDHAlteration_Logged_Date                   --tblDHColl             Enhanced TR_utblDHColl_Max_Depth to handle tblDH* table has no Hole_ID             New trigger TR_itblDHColl_0m_Survey             Changed Max_Depth to NOT NULL             New columns Hole_Path, Hole_Position, Location, Program_ID, Target, LL_RL_Method             Updated TR_iutblDHColl_UsingActiveLIBCode to reflect new columns             Removed Orig/NAT/Local columns             Removed LL_Geometry column*             New column Report_No             --tblDHCollPlanned             TR_iutblDHCollPlanned_DHColl_LCH reflect Orig/NAT/Local removal                   --tblDHCoordinates             New normalised coordinates table                   --tblDHCoreRecoveryRun             New trigger TR_tblDHCoreRecoveryRun_Logged_Date                   --tblDHEvents             New trigger TR_tblDHEvents_Logged_Date                   --tblDHGeology             New trigger TR_tblDHGeology_Logged_Date                   --tblDHGeophysics             New column Priority             Changed PK to include Priority column             Updated TR_iutblDHGeophysics_Interval_Overlap/TR_utblDHGeophysics to reflect PK changes                   --tblDHGeophysics_SGAMMASUS             Corrected typo in TR_utblDHGeophysics_SGAMMASUS             --tblDHGeophysicsHeader             Bug fix TR_iutblDHGeophysicsHeader_LAS_Date_Read_Date             --tblDHGeophysicsPT             New column Priority             Changed PK to include Priority column             Updated TR_utblDHGeophysicsPT to reflect PK changes                   --tblDHGeotech             New trigger TR_tblDHGeotech_Logged_Date                   --tblDHGeotechLoadStrength             New column Priority             Changed PK to include Priority column             Updated TR_iutblDHGeotechLoadStrength_Interval_Overlap/TR_utblDHGeotechLoadStrength to reflect PK changes                   --tblDHGeotechLoadStrengthPT             Dropped FK_tblDHGeotechLoadStrengthPT_tblPTSite_DataSet_Site_ID             Renamed Site_ID to Hole_ID             Updated PK to reflect Site_ID renamed to Hole_ID             New FK_tblDHGeotechLoadStrengthPT_tblDHColl_DataSet_Hole_ID             Updated TR_iudtblDHGeotechLoadStrengthPT_Validated/TR_iutblDHGeotechLoadStrengthPT_Depth/TR_iutblDHGeotechLoadStrengthPT_UsingActiveLIBCode/TR_utblDHGeotechLoadStrengthPT to reflect PK change                   --tblDHGeotechRMR             New trigger TR_tblDHGeotechRMR_Logged_Date                   --tblDHGeotechRQD             New trigger TR_tblDHGeotechRQD_Logged_Date                   --tblDHGrouting             New column Grout_Status             NEw FK_tblDHGrouting_tblLIBGroutStatus_Grout_Status             Updated TR_iutblDHGrouting_UsingActiveLIBCode to reflect new column             --tblDHHazards             New table                   --tblDHLithology             Updated CK_tblDHLithology_Lith2_Code definition             New trigger TR_tblDHLithology_Logged_Date             New column Lith_Contact_Code/Lith1_Age/Lith2_Age/Lith1_Sorting/Lith2_Sorting/Lith1_Rounding/Lith2_Rounding             Updated TR_iutblDHLithology_UsingActiveLIBCode to reflect new columns                   --tblDHMagSus             New column Priority             Changed PK to include Priority column             Updated TR_iutblDHMagSus_AveReading/TR_iutblDHMagSus_Interval_Overlap/TR_utblDHMagSus to reflect PK changes                   --tblDHMagSusPT             New column Priority             Changed PK to include Priority column             Updated TR_iutblDHMagSusPT_AveReading/TR_utblDHMagSusPT to reflect PK changes                   --tblDHMetaData             Bug fix TR_iutblDHMetaData_Date_Completed                   --tblDHMetSamp             New trigger TR_tblDHMetSamp_Logged_Date             New columns Quartz_Flush/Assay_Dispatch_Group             --tblDHMetSampQC             New trigger TR_tblDHMetSampQC_Logged_Date             Enhanced trigger TR_iutblDHMetSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist             New columns Quartz_Flush/Assay_Dispatch_Group                   --tblDHMinerals             New trigger TR_tblDHMinerals_Logged_Date             New columns Min1_Abundance/Min2_Abundance/Min3_Abundance/Min4_Abundance/Min5_Abundance             Updated TR_iutblDHMinerals_UsingActiveLIBCode to reflect new columns                   --tblDHOrientation             New table                   --tblDHOxidation             New trigger TR_tblDHOxidation_Logged_Date                   --tblDHRegolith             New table                   --tblDHSamp             New trigger TR_tblDHSamp_Logged_Date             New columns Quartz_Flush/Assay_Dispatch_Group/Sample_Purpose/Sample_Quality/Sample_Recovery_Code/Composite_SampleID/Has_Fraction             New FKs                   FK_tblDHSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group                   FK_tblDHSamp_tblLIBSamplePurpose_Sample_Purpose                   FK_tblDHSamp_tblLIBSampleQuality_Sample_Quality                   FK_tblDHSamp_tblLIBSampleRecovery_Sample_Recovery_Code             Updated TR_iutblDHSamp_UsingActiveLIBCode to reflect new columns             New trigger TR_utblDHSamp_Composite_SampleID                   --tblDHSampComp             New table             --tblDHSampCompFrac             New table                   --tblDHSampCompFracQC             New table             --tblDHSampCompQC             New table             --tblDHSampFrac             New table             --tblDHSampFracComp             New table             --tblDHSampFracCompQC             New table             --tblDHSampFracQC             New table             --tblDHSampHyper             New table             --tblDHSampHyperQC             New table             --tblDHSampQC             New trigger TR_tblDHSampQC_Logged_Date             Enhanced TR_iutblDHSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist             New columns Quartz_Flush/Assay_Dispatch_Group             --tblDHSampWater             New trigger TR_tblDHSampWater_Logged_Date             --tblDHSampWaterQC             New trigger TR_tblDHSampWaterQC_Logged_Date             --tblDHStratigraphy             New table             --tblDHStructure             New trigger TR_tblDHStructure_Logged_Date                   --tblDHStructureOrient             New column Priority             Changed PK to include Priority column             Updated TR_iutblDHStructureOrient_Alpha_Beta_Gamma_Calculate/TR_utblDHStructureOrient to reflect PK changes             New trigger TR_tblDHStructureOrient_Logged_Date                   --tblDHSulphides             New trigger TR_tblDHSulphides_Logged_Date             New columns Sulph1_Abundance/Sulph2_Abundance/Sulph3_Abundance/Sulph4_Abundance/Sulph5_Abundance             New FKs                   FK_tblDHSulphides_tblLIBMinAbundance_Sulph1_Abundance                   FK_tblDHSulphides_tblLIBMinAbundance_Sulph2_Abundance                   FK_tblDHSulphides_tblLIBMinAbundance_Sulph3_Abundance                   FK_tblDHSulphides_tblLIBMinAbundance_Sulph4_Abundance                   FK_tblDHSulphides_tblLIBMinAbundance_Sulph5_Abundance             Updated trigger TR_iutblDHSulphides_UsingActiveLIBCode to reflect new columns                   --tblDHSurv             Enhanced trigger TR_iudtblDHSurv_Priority_Recalculate to exclude Priority<-999 from recalculate and included Priority change to trigger recalculate                   --tblDHVeins             New trigger TR_tblDHVeins_Logged_Date                   --tblDHWeathering             New trigger TR_tblDHWeathering_Logged_Date                               --tblGV_Fields             New table             --tblGV_HeaderFields             New table             --tblGV_Setup             New table             --tblGV_Setup_Extension             New table             --tblGV_SetupDataHeaders             New table             --tblGV_Tables             New table             --tblGV_TablesDataHeaders             New table                   --tblLease             Increase Lease_No length from 15 to 50             --tblLIBAssay_Dispatch_Group             New table                   --tblLIBCoreDiameter             New columns Hole_Diameter/Bit_Size             Add/updated default data             --tblLIBCrewRole             New table             --tblLIBDispatchPrefix             New table             --tblLIBDispatchStatus             Added default data             --tblLIBGroutStatus             New table             --tblLIBHazardCode             New table             --tblLIBHazardStatus             New table             --tblLIBHoleDiameter             New columns Core_Diameter/Hole_Diameter_Measurement             Add/updated default data             --tblLIBHolePath             New table             --tblLIBHolePosition             New table             --tblLIBLandform             New table             --tblLIBLithAge             New table             --tblLIBLithContact             New table             --tblLIBLithRegCode             New table             --tblLIBLithRegQual             New table             --tblLIBLithRegRegime             New table             --tblLIBLithRounding             New table             --tblLIBLithSorting             New table             --tblLIBLocation             New table             --tblLIBMinAbundance             New table             --tblLIBOrientationConfidence             New table             --tblLIBOrientationContinuity             New table             --tblLIBOrientationQuality             New table             --tblLIBOrientationType             New table             --tblLIBProgramID             New table             --tblLIBRLMethod             New table             --tblLIBSampleFraction             New table             --tblLIBSamplePurpose             New table             --tblLIBSampleQuality             New table             --tblLIBSampleRecovery             New table             --tblLIBSampleRelationship             New table             --tblLIBSoilCohesion             New table             --tblLIBSoilType             New table             --tblLIBTarget             New table                   --tblLSCoordinates             New normalised coordinates table         --tblLSGeology             New trigger TR_tblLSGeology_Logged_Date                   --tblLSMetSamp             New trigger TR_tblLSMetSamp_Logged_Date             New column Quartz_Flush/Assay_Dispatch_Group             New FK_tblLSMetSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group                   --tblLSMetSampQC             New trigger TR_tblLSMetSampQC_Logged_Date             Enhanced trigger TR_iutblLSMetSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist             New columns Quartz_Flush/Assay_Dispatch_Group             New FK_tblLSMetSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group                   --tblLSSamp             New trigger TR_tblLSSamp_Logged_Date             New columns Quartz_Flush/Assay_Dispatch_Group/Sample_Purpose/Sample_Quality/Sample_Recovery_Code             New FKs                   FK_tblLSSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group                   FK_tblLSSamp_tblLIBSamplePurpose_Sample_Purpose                   FK_tblLSSamp_tblLIBSampleQuality_Sample_Quality                   FK_tblLSSamp_tblLIBSampleRecovery_Sample_Recovery_Code             Updated trigger TR_iutblLSSamp_UsingActiveLIBCode to reflect new columns             --tblLSSampHyper             New table             --tblLSSampHyperQC             New table                   --tblLSSampQC             New trigger TR_tblLSSampQC_Logged_Date             Enhanced trigger TR_iutblLSSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist             New columns Quartz_Flush/Assay_Dispatch_Group             New FK_tblLSSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group                   --tblLSSampWater             New trigger TR_tblLSSampWater_Logged_Date                   --tblLSSampWaterQC             New trigger TR_tblLSSampWaterQC_Logged_Date                   --tblLSSite             Corrected LL_Geometry formula             New columns Location/LL_RL_Method             New FKs                   FK_tblLSSite_tblLIBLocation_Location                   FK_tblLSSite_tblLIBRLMethod_LL_RL_Method             Updated trigger TR_iutblLSSite_UsingActiveLIBCode to reflect new columns             Fixed bug in TR_utblLSSite_Max_Length             Removed Orig/NAT/Local columns             Removed LL_Geometry column*             New column Report_No             --tblPTCoordinates             New normalised coordinates table         --tblPTMetSamp             New columns Quartz_Flush/Assay_Dispatch_Group             New FK_tblPTMetSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group                   --tblPTMetSampQC             Updated trigger TR_iutblPTMetSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist             New columns Quartz_Flush/Assay_Dispatch_Group             New FK_tblPTMetSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group                   --tblPTSamp             New columns Quartz_Flush/Assay_Dispatch_Group/Sample_Purpose/Sample_Quality/Sample_Recovery_Code/Soil_Cohesion/Soil_Type             New FKs                   FK_tblPTSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group                   FK_tblPTSamp_tblLIBSamplePurpose_Sample_Purpose                   FK_tblPTSamp_tblLIBSampleQuality_Sample_Quality                   FK_tblPTSamp_tblLIBSampleRecovery_Sample_Recovery_Code                   FK_tblPTSamp_tblLIBSoilCohesion_Soil_Cohesion                   FK_tblPTSamp_tblLIBSoilType_Soil_Type             Updated trigger TR_iutblPTSamp_UsingActiveLIBCode to reflect new columns                               --tblPTSampHyper             New table             --tblPTSampHyperQC             New table                   --tblPTSampQC             Updated trigger TR_iutblPTSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist             New columns Quartz_Flush/Assay_Dispatch_Group             New FK_tblPTSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group             --tblPTSite             Corrected LL_Geometry formula             New columns Landform/Location/Program_ID/LL_RL_Method             New FKs                   FK_tblPTSite_tblLIBLandform_Landform                   FK_tblPTSite_tblLIBLocation_Location                   FK_tblPTSite_tblLIBProgramID_Program_ID                   FK_tblPTSite_tblLIBRLMethod_LL_RL_Method             Updated trigger TR_iutblPTSite_UsingActiveLIBCode to reflect new columns             Removed Orig/NAT/Local columns             Removed LL_Geometry column*             New column Report_No             --tblSampleRegister             Enhanced logic to handle all sample tables with insert trigger to tblSampleRegister             Granted update permission to DS_UserPlus             --tblSampleRelationship             New table                   --tblStandardSamp             New columns Quartz_Flush/Assay_Dispatch_Group/Sampled_By             New FKs                   FK_tblStandardSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group                   FK_tblStandardSamp_tblLIBPerson_Sampled_By             --tblStandardSampQC             New columns Quartz_Flush/Assay_Dispatch_Group/Sampled_By             New FKs                   FK_tblStandardSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group                   FK_tblStandardSampQC_tblLIBPerson_Sampled_By             Updated trigger TR_iutblStandardSampQC_UsingActiveLIBCode to reflect new columns             --tblSYSAALAttachment             New table                   --tblSYSAssBatchDetail             Changed LabElement column length from 25 to 100                   --tblSYSAssDispatchDetails             New column Email_Result_To/Other_Email_Result_To/Email_Invoice_To/Other_Email_Invoice_To             --tblSYSAssDispatchGroupDetail             New column Lab_Turnaround_Requirement             --tblSYSAssDispatchHeader             New column Date_Shipped/TemplateID                   --tblSYSAssDispatchTemplates             New table             --tblSYSAssElement             New column Report_Grade_Unit/Is_Active/Sort_Order                   --tblSYSAssIncomingData             Changed LabElement column length from 25 to 100                   --tblSYSAssLab             New column Is_Active/Sort_Order                   --tblSYSAssLabElementAlias             Changed LabElement column length from 25 to 100                   --tblSYSAssLabMethod             New column Is_Active/Sort_Order                   --tblSYSAssMethodGeneric             New column Is_Active/Sort_Order                   --tblSYSAssQCResultDetail             New column Repeat             --tblSYSConfigRelation             Added configuration for Hyperspectral tables             Remove any configured table no longer exist             --tblSYSConfigRelationField             Added configuration for Hyperspectral tables             --tblSYSDSConfig             Added configuration for Hyperspectral tables             Added SampleDispatch and DMP extension configs             --tblSYSExtSQLStatement             Updated SQLCode for MAX035             Updated extension SQLCodes             --tblSYSFilter             New column Filter_Definition             --tblSYSFilterItem             New column FilterItem_Definition                   --tblSYSIncomingDataMasks             Fixed bug in TR_iutblSYSIncomingDataMasks_Identifier to do check properly             --tblSYSLASItemMapping             New table             --tblSYSLASMapping             New table             --tblSYSLASSourceItem             New table             --tblSYSLASSourceItemGroup             New table             --tblSYSLASUserInputField             New table             --tblSYSNormAttributeDef             Added configuration for Hyperspectral tables             --tblSYSObject             Added configuration for Hyperspectral tables             Added new user DSSYSADMIN/DSUSERPLUS             --tblSYSObjectGroup             Added configuration for Hyperspectral tables             --tblSYSParam             Added SampleDispatch configs                   --tblSYSSRSAffineTransform             New table for new grid transformation                   --tblSYSSRSConfidenceLevel             New table for new grid transformation         --tblSYSSRSControlPoints             New table for new grid transformation         --tblSYSSRSCoordinateSystem             New column AuthorityCode             Populated AuthorityCode             Removed column DatumCode, ProjectionCode         --tblSYSSRSDatum             Removed table                   --tblSYSSRSEllipsoid             Removed table                   --tblSYSSRSProjection             Removed table                   --tblSYSSRSProjectionType             Removed table         --tblSYSSRSTransformations             New table for new grid transformation         --tblSYSSRSTransformationType             New table for new grid transformation         --tblSYSSampleCutSheet             New table             --tblSYSSampleCutSheetConfig             New table             --tblSYSSampleCutSheetDetails             New table             --tblSYSSampleCutSheetTemplates             New table                   --tblSYSXRFIncomingData             Changed LabElement column length from 25 to 100             --tblVWDHAuditView             Removed Orig/NAT/Local columns                   --tblVWDHCollarAttributes             Removed Orig/NAT/Local columns             --tblVWDHCollSurv             Removed Orig/NAT/Local columns             --tblVWDHCoordinates             New view             --tblVWDHCoordinateTransformations             New view                   --tblVWDHMaxAssays             Removed Orig/NAT/Local columns                   --tblVWLSCoordinates             New view             --tblVWLSCoordinateTransformations             New view             --tblVWLSLogging             Removed Orig/NAT/Local columns             --tblVWLSMaxAssays             Removed Orig/NAT/Local columns         --tblVWLSSamp             Removed Orig/NAT/Local columns         --tblVWPTAssays             Removed Orig/NAT/Local columns             --tblVWPTAssaysWater             Removed Orig/NAT/Local columns             --tblVWPTCoordinates             New view             --tblVWPTCoordinateTransformations             New view                   --tblVWPTLogging             Removed Orig/NAT/Local columns                   --tblVWPTMaxAssays             Removed Orig/NAT/Local columns                   --tblVWPTSamp             Removed Orig/NAT/Local columns             --tblVWDHLithology             Replaced * with actual column list in the view definition                   --tblVWDispatchSelectSamples             New view             --tblVWMissingSamplesAlreadyAssayed             New view             --tblVWPTAssaysQC             Added LabCode/Batch_No/GenericMethod                   --tblVWQF_Samples             New view             --tblVWReportCollar             Removed Orig/NAT/Local columns                   --tblVWSYSDispatchedSamples_CSV_Export             New view for DS5 dispatch export             --tblVWWSDHColl             Added filter on Priority 0                   --tblVWWSXRFResults             Removed Orig/NAT/Local columns                   --tblVWXRFIncomingResults             Removed Orig/NAT/Local columns             --tblVWXRFResults             Removed Orig/NAT/Local columns                   --tblVWXRFResultsQC             Removed Orig/NAT/Local columns                   --tblXRFDHSampQC             Updated trigger TR_iutblXRFDHSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist                   --tblXRFResults             Changed GenericMethod column length from 10 to 25             Changed AssayResultNum/LimitLower/LimitUpper/sysResult/StdDev column decimal point from 6 to 9             Changed LabElement column length from 25 to 100                   --tblXRFStandardSamp             Updated trigger TR_itblXRFStandardSamp to fix bug with SourceTable name                   --udf_CalcAvgSysResult             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_CheckAzimuthDeviation             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_CheckDipDeviation             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_ChecksumRemoveSpace             New internal used function         --udf_DistanceWAveDipAzi             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_GetBatch_No             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_GetDataSetForProdLocation             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_GetDispatchNo             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_GetGenericAndOrigMethodBatchNo             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_GetGenericMethod             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_GetLabCode             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_GetOrigMethod             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_GetViewOrderByList             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_OrientDipAzi             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_OrientDipDirection             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_RoboCalc             Granted execute permission to DS_SysAdmin/DS_UserPlus         --udf_RptGetFieldConvert             Granted execute permission to DS_SysAdmin/DS_UserPlus                   --usp_AppUpsertJsonData             New SP internal used by application         --usp_AdminBatchDelete             Enhanced logic to handle sample involved in mulitple batches             Added handle of tblXRFResultsHeader                   --usp_CRSApplyTransformation_DH             New SP used by new grid transformation process                   --usp_CRSApplyTransformation_FS             New SP used by new grid transformation process                   --usp_CRSApplyTransformation_LS             New SP used by new grid transformation process                   --usp_CRSApplyTransformation_PT             New SP used by new grid transformation process                   --usp_CRSFindAffineParameters             New SP used by new grid transformation process                   --usp_CRSTransform             New SP used by new grid transformation process                   --usp_CRSTransformToLatLong_DH             New SP used by new grid transformation process             --usp_CRSTransformToLatLong_FS             New SP used by new grid transformation process                   --usp_CRSTransformToLatLong_LS             New SP used by new grid transformation process                   --usp_CRSTransformToLatLong_PT             New SP used by new grid transformation process             --usp_DataAssayMergingProcess             Reworked logic for Total/Merged counts                   SampleCount: total unique sample counts in all assay and buffer tables combo                   SampleMerged: unique sample counts in all assay tables                   ResultCount: total unique (sampleid/genericmethod/element/repeat) assay records in all assay and buffer tables combo                   ResultMerged: assay record count for Preferred=0 (or -1000).             Added handle of other assay tables             Remove negative preferred records that's due to assay reloading                   --usp_DataAssayQCRuleChecker             Changed @Orig_SampleID from NVARCHAR(30) to NVARCHAR(50)             Added handle of other assay tables             Added handle of Repeat             Enhanced logic to not throw error "QC reference values missing" if a standard does not have the element configured (QCResultFailCode: STD5)         --usp_DataAssayUpdateBatchStatus             Added handle of other assay tables             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         --usp_DataDesurvey             Enhanced logic for preventing multiple concurrent run             Added option to skip desurvey survey table             Added logic to ignore validated holes             Enhanced logic to handle DH/LS table using Depth instead of Depth_From/Depth_To or Length_From/Length_To         --usp_DataSurveyDeviationChecker             Add logic to exclude validated hole/site         --usp_DataXRFResultsMergingProcess             Fixed total counts logic                   --usp_ProcessImportData             New DS5 used SP for import data                   --usp_ProcessInComingDataDriver             Exclude tblSYSIncomingDataMasks.Is_Active=0             Added handle for lab Sample_Type/Sample_Method/Sampled_By/Sampled_Date             Added handle for nested matching of identifiers, like %SARM-4% and %SARM-48%             Added logic to validate configured sample table exists             Added check Depth_From column exists on table not classified as Point table                   --usp_ProcessLabChecksInComingData             Added handle for lab Sample_Type/Sample_Method/Sampled_By/Sampled_Date             Added handle for nested matching of identifiers, like %SARM-4% and %SARM-48%                   --usp_ProcessStandardsInComingData             Added handle for lab Sample_Type/Sample_Method/Sampled_By/Sampled_Date             Added handle for nested matching of identifiers, like %SARM-4% and %SARM-48%                   --usp_ProcessXRFInComingDataDriver             Added handle for nested matching of identifiers, like %SARM-4% and %SARM-48%                   --usp_ProcessXRFLabChecksInComingData             Added handle for nested matching of identifiers, like %SARM-4% and %SARM-48%                   --usp_ProcessXRFStandardsInComingData             Added handle for nested matching of identifiers, like %SARM-4% and %SARM-48%                   --usp_RptQAQC_MonthlyScatterPlot_BadRpts             Added missing join on GenericMethod                   --usp_RptQAQC_MonthlyScatterPlotChart             Added missing join on GenericMethod                   --usp_RptQAQC_MonthlyScatterPlotGrouping             Added missing join on GenericMethod                   --usp_RptQAQC_MonthlyScatterPlotSummary             Added missing join on GenericMethod                   --uspIC_InterceptCalculator             Enhanced logic to improve performance when source data (SampleTable) is view                   --utf_CRSAffineTransform3D             New function used by new grid transformation process                   --utf_Desurvey             Granted execute permission to DS_SysAdmin/DS_UserPlus                   --utf_GetGenericAndOrigMethodBatchNo             Granted execute permission to DS_SysAdmin/DS_UserPlus         --utf_GetReportDays             Granted execute permission to DS_SysAdmin/DS_UserPlus         --utf_MXAuditExceptionAppList             Granted execute permission to DS_SysAdmin/DS_UserPlus         --utf_StringSpliter             Granted execute permission to DS_SysAdmin/DS_UserPlus         --All triggers using TRIGGER_NESTLEVEL() filter             Enhanced logic to handle insert/update via view                   --All tables             Removed ts column   ************************************* Following changes are for v4.6.6 and model specific: ************************************* For Prod model       --tblFSCoordinates             New normalised coordinates table         --tblFSGeology             New trigger TR_tblFSGeology_Logged_Date                   --tblFSMetSamp             New trigger TR_tblFSMetSamp_Logged_Date             New columns Quartz_Flush/Assay_Dispatch_Group             New FK_tblFSMetSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group                   --tblFSMetSampQC             New trigger TR_tblFSMetSampQC_Logged_Date             Enhanced trigger TR_iutblFSMetSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist             New columns Quartz_Flush/Assay_Dispatch_Group             New FK_tblFSMetSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group                   --tblFSSamp             New trigger TR_tblFSSamp_Logged_Date             New columns Quartz_Flush/Assay_Dispatch_Group/Sample_Purpose/Sample_Quality/Sample_Recovery_Code             New FKs                   FK_tblFSSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group                   FK_tblFSSAMP_tblLIBSamplePurpose_Sample_Purpose                   FK_tblFSSAMP_tblLIBSampleQuality_Sample_Quality                   FK_tblFSSAMP_tblLIBSampleRecovery_Sample_Recovery_Code             Updated trigger TR_iutblFSSamp_UsingActiveLIBCode to reflect new columns                   --tblFSSampHyper             New table             --tblFSSampHyperQC             New table                   --tblFSSampQC             New trigger TR_tblFSSampQC_Logged_Date             Enhanced trigger TR_iutblFSSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist             New columns Quartz_Flush/Assay_Dispatch_Group             New FK_tblFSSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group                   --tblFSSampWater             New trigger TR_tblFSSampWater_Logged_Date                   --tblFSSampWaterQC             New trigger TR_tblFSSampWaterQC_Logged_Date                   --tblFSSite             Corrected LL_Geometry formula             New columns Location/LL_RL_Method             New FKs                   FK_tblFSSite_tblLIBLocation_Location                   FK_tblFSSite_tblLIBRLMethod_LL_RL_Method             Updated trigger TR_iutblFSSite_UsingActiveLIBCode to reflect new columns             Removed Orig/NAT/Local columns             Updated column Parent_Face_ID/Responsible_Person/Historic_Face_ID description             Removed LL_Geometry column*             New column Report_No                   --tblFSSurv             Updated column Depth/Temp/Temp_UnitCode description         --tblLIBProdBlockSource             Removed table             --tblLIBProdMovementType             Removed table         --tblLIBProdParentStope             Removed table         --tblProdActivity             Removed columns Activity_Date/Shift/LGSD             Removed TR_iutblProdActivity_Activity_Date_Shift_ShiftDateCode             Changed Operator to allow null             Changed Activity_Amount to not allow null             --tblProdBlasting             Removed columns  ShiftDateCode/LG_SD             Removed TR_iutblProdBlasting_Blast_Date_Shift_ShiftDateCode             --tblProdBlastingBlock             New FK_tblProdBlastingBlock_tblProdBlasting_Blast_Cut_ID             Removed column LG_SD                     --tblProdBlastingBlockSurvey             Removed columns ShiftDateCode/LGSD             Removed TR_iutblProdBlastingBlockSurvey_Survey_Date_Shift_ShiftDateCode             Changed PK             --tblProdBlastingSurvey             New FK_tblProdBlastingSurvey_tblProdBlasting_Blast_Cut_ID             Removed column ShiftDateCode             Changed PK             --tblProdBlockCommodities             Removed DF_tblProdBlockCommodities_Grade_Unit             --tblProdBlockPlanned             Changed Material_Type to allow null                   --tblProdBlockPlannedCommodities             Removed DF_tblProdBlockPlannedCommodities_Planned_Grade_Unit             --tblProdBlockReserve             Removed columns GridID/X/Y/Z             Changed Material_Type to allow null                   --tblProdBlockReserveCommodities             Removed DF_tblProdBlockReserveCommodities_Reserve_Grade_Unit                   --tblProdBlockResource             Changed Material_Type to allow null             Removed columns GridID/X/Y/Z                   --tblProdBlockResourceCommodities             Removed DF_tblProdBlockResourceCommodities_Resource_Grade_Unit                   --tblProdEquipmentUtilisation             Changed columns Fuel_Status/Supervisor to allow null             Removed columns Scheduled_Date/Shift/LG_SD                   --tblProdLocationBalance             New column NegativeBalanceAmount                   --tblProdMaterialMovement             Changed column Time_Loaded to allow null, removed default constraint and changed data type to tim(7)             Changed Time_Dumped to allow null and changed data type to tim(7)             Removed columns Movement_Type/LG_SD/ShiftDateCode                         --tblProdSamp             New columns Quartz_Flush/Assay_Dispatch_Group             New FK_tblProdSamp_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group             Changed Sampled_Date to allow null             Removed columns ShiftDateCode/LG_SD                   --tblProdSampQC             Updated trigger TR_iutblProdSampQC_DataSet_Orig_SampleID_SampleID to handle Orig_SampleID does not exist             New columns Quartz_Flush/Assay_Dispatch_Group             New FK_tblProdSampQC_tblLIBAssay_Dispatch_Group_Assay_Dispatch_Group             Removed columns ShiftDateCode/LG_SD                   --tblProdShiftRegister             Removed column LG_SD                   --tblProdSiteAssay             New columns Modified_Date/Modified_By/ts             New trigger TR_utblProdSiteAssay             New FK_tblProdSiteAssay_tblProdSiteRegister_Prod_SourceID                   --tblProdSurvey             Removed columns ShiftDateCode/LG_SD             Changed PK                   --tblProdSurveyCommodity             Added column Surveyed_Date             Removed columns ShiftDateCode/LG_SD                   --tblProdWeightometer             Removed table                   --tblVWFSCoordinates             New view             --tblVWFSCoordinateTransformations             New view                   --tblVWFSLogging             Removed Orig/NAT/Local columns             --tblVWFSMaxAssays             Removed Orig/NAT/Local columns         --tblVWFSSamp             Removed Orig/NAT/Local columns                   --tblVWProdActivity             New view                   --tblVWProdEOMActualsStockpilesMerged             Reflect table column name change                   --tblVWProdEquipmentUtilisation             Added tblProdShiftRegister                   --tblVWProdLocationBalance             Updated view to used tblSYSAssElement.Report_Grade_Unit             --tblVWProdMaterialMovement             Added Assay_Grade_Unit                   --tblVWProdReconTrucktoResource             Added Assay_Grade_Unit column, IsPrimary filter                   --tblVWProdTruckingCalculated             Added Assay_Grade_Unit             Mined value using assay grade when ProdReport_GradeFromAssay is configured             Updated Mined_Metal/Mined_Ounces calculation                   --tblVWProdTruckingClaimed             Added Assay_Grade_Unit                   --usp_PopulateProdSiteAssay             Treat NULL Shift as dayshift (‘D’)                   --usp_PopulateProdLocationBalance             If survey grade is NULL or 0, using calculated grade from previous day             Record actual negative value been reset             For Diamond model       --tblDHMinerals             New column Min_Abundance             New FK_tblDHMinerals_tblLIBMinAbundance_Min_Abundance             Updated TR_iutblDHMinerals_UsingActiveLIBCode to reflect new column   For Coal model       --tblDHSulphides             New trigger TR_iutblDHSulphides_UsingActiveLIBCode
v4.6.5 ************************************* Following changes are for v4.6.5 ALL models *************************************       --tblAssayFlat             New columns LabCode/Batch_No/GenericMethod                   --tblAssayHyperspectral             New table             --tblAssayHyperspectralFlat             New Table                   --tblAssayWaterFlat             New columns LabCode/Batch_No/GenericMethod                   --tblContractActivityLog             New CK_tblContractActivityLog_Project_Area_Site             New CK_tblContractActivityLog_Contractor_MachineryID             Updated FK_tblContractActivityLog_tblLIBContractActivityLogStatus_Activity_Signoff_Status with cascade on                   --tblContractActivityLogDetails             New FK_tblContractActivityLogDetails_tblSYSDataSet_DataSet                   --tblContractDetails             New CK_tblContractDetails_LabMethod_LabCode             Updated FK_tblContractDetails_tblLIBContractItemCategory_Item_Category with cascade on             Updated FK_tblContractDetails_tblSYSUnits_Unit with cascade on         --tblDHColl             New TR_utblDHColl_Rename to update tblStandardSamp.SourceID when DataSet/Hole_ID renamed             Enhanced TR_utblDHColl_Max_Depth to only check DBO schema tables and include tblXRFDH* tables, fixed @Rowcount bug             Enhanced TR_utblDHColl_Orig_Grid_Audit to audit on Validated value changes             New column LL_Geometry/In_MRE             Changed Date_Completed data type from datetime to date                   --tblDHCollHistory             New column Validated             Updated FK_tblDHCollHistory_tblLIBSurveyMethod_Survey_Method with cascade on             Updated FK_tblDHCollHistory_tblSYSSRSCoordinateSystem_Grid_ID with cascade on                   --tblDHCollPlanned             Added UPDATE CASCADE to FK_tblDHCollPlanned_tblLIBCompany_Plan_Survey_Company                   --tblDHCoreRecoveryRun             New columns Priority/Degree_Of_Offset/Solid_Recovery_pct/Total_Core_Recovery_Interval/Total_Core_Recovery_pct/Solid_Recovery_Interval             TR_iutblDHCoreRecoveryRun_RQDPct_RecoveryPct fixed wrong reference to Recovery_Interval for RQD_pct calculation and added option to use either Interval or Recover_Interval to calculate RQD_pct             Changed PK to include Priority                   --tblDHCoreStorage             New TR_iutblDHCoreStorage_Validated_Date ensures the Validated_Date is not earlier than tblDHColl.Date_Started                   --tblDHCoreStorageDetails             New TR_iutblDHCoreStorageDetails_Validated_Date ensures the Validated_Date is not earlier than tblDHColl.Date_Started                   --tblDHDrillRigMetaData             New TR_iutblDHDrillRigMetaData_Drill_Date ensures the Drill_Date is not earlier than tblDHColl.Date_Started                   --tblDHGeophysics_DENS             Updated FK_tblDHGeophysics_DENS_tblDHGeophysicsHeader_DataSet_Hole_ID_Instrument_Priority with cascade on             Updated FK_tblDHGeophysics_DENS_tblSYSUnits_SSD_UnitCode with cascade on             --tblDHGeophysics_IP             Updated FK_tblDHGeophysics_IP_tblDHGeophysicsHeader_DataSet_Hole_ID_Instrument_Priority with cascade on             Updated FK_tblDHGeophysics_IP_tblSYSUnits_VSP_UnitCode with cascade on             --tblDHGeophysics_RES             Updated FK_tblDHGeophysics_RES_tblDHGeophysicsHeader_DataSet_Hole_ID_Instrument_Priority with cascade on             Updated FK_tblDHGeophysics_RES_tblSYSUnits_RLLD_UnitCode with cascade on             Updated FK_tblDHGeophysics_RES_tblSYSUnits_RLLS_UnitCode with cascade on             --tblDHGeophysics_SGAMMASUS             Updated FK_tblDHGeophysics_SGAMMASUS_tblDHGeophysicsHeader_DataSet_Hole_ID_Instrument_Priority with cascade on             Updated FK_tblDHGeophysics_SGAMMASUS_tblSYSUnits_NGAM_UnitCode with cascade on             Updated FK_tblDHGeophysics_SGAMMASUS_tblSYSUnits_MSUS_UnitCode with cascade on             --tblDHGeophysics_SP             Updated FK_tblDHGeophysics_SP_tblDHGeophysicsHeader_DataSet_Hole_ID_Instrument_Priority with cascade on             Updated FK_tblDHGeophysics_SP_tblSYSUnits_SP_UnitCode with cascade on                   --tblDHGeophysicsHeader             New TR_iutblDHGeophysicsHeader_LAS_Date_Read_Date ensures the LAS_Date/Read_Date is not earlier than tblDHColl.Date_Started             New CK_tblDHGeophysicsHeader_Depth_Started_Depth_Completed ensures Depth_Completed is not less than Depth_Started             New CK_tblDHGeophysicsHeader_Read_Date ensures Read_Date not great than current             New CK_tblDHGeophysicsHeader_LAS_Date esnures LAS_Date not great than current             New CK_tblDHGeophysicsHeader_Contractor_Machinery ensures both Contractor and Machinery entered             Changed Data_Source to NOT NULL             Updated FK_tblDHGeophysicsHeader_tblLIBInstrument_Instrument with cascade on             Updated FK_tblDHGeophysicsHeader_tblLIBMachinery_Contractor_Machinery with cascade on             Updated FK_tblDHGeophysicsHeader_tblLIBPerson_Witness with cascade on                   --tblDHGeotech             New column Priority/Matrix_Type             Change PK to include Prioirty                   --tblDHGeotechLoadStrength             New column Lab_SampleID/Poissons_Ratio_Secant/Poissons_Ratio_Tangent                   --tblDHGeotechRMR             New columns Priority/Alpha/Beta/Sub_Sampled/Total_Core_Recovery/Wall_Rock_Alt_Code/Wall_Rock_Alt_Int/Matrix_Depth/Jr/MRMR_Rating/RMR_RQD_Rating/Fabric_Type/Rock_Mass_Domain             Updated computation formula for RQD_Deere_pct             New CK_tblDHGeotechRMR_Total_Core_Recovery_pct ensures value is not greater than 100             New CK_tblDHGeotechRMR_RQD_Deere_pct ensures value is not greater than 100             New FK_tblDHGeotechRMR_tblLIBStructSpacing_Structure_Spacing             Updated TR_iutblDHGeotechRMR_UsingActiveLIBCode             TR_iutblDHGeotechRMR_Recovery_pct_RQD_pct_Solid_Recovery_pct fixed wrong reference to Recovery_Interval for RQD_pct calculation and added option to use either Interval or Recover_Interval to calculate RQD_pct             Change PK to include Priority                   --tblDHGeotechRQD             New columns Priority/Structure_Count             Changed PK to include Priority                   --tblDHGeotechLoadStrengthPT             New table             --tblDHGeotechRockStrengthBFA             New table             --tblDHGeotechRockStrengthSHJ             New table             --tblDHGeotechRockStrengthTCM             New table             --tblDHGeotechRockStrengthTCS             New table             --tblDHGeotechRockStrengthUCM             New table             --tblDHGeotechRockStrengthUCS             New table             --tblDHGeotechRockStrengthUTB             New table             --tblDHIntercepts             InterceptDescription column length changed from 50 to 150                   --tblDHLithology             Updated CK_tblDHLithology_Lith2_Code to also check on Lith_Texture/GrainSize instead of just Lith_Code             Comments column length changed from 1000 to 3000                   --tblDHMagSus             Updated TR_iutblDHMagSus_UsingActiveLIBCode to include Instrument_FactorCode                   --tblDHMagSusPT             Updated TR_iutblDHMagSusPT_UsingActiveLIBCode to include Instrument_FactorCode                   --tblDHMetaData             New TR_iutblDHMetaData_Date_Completed ensures the Date_Completed is not earlier than tblDHColl.Date_Started             New CK_tblDHMetaData_Drill_Contractor_Rig ensures both Drill_Contractor and Rig are entered                   --tblDHMetSamp             New TR_iutblDHMetSamp_Date_Analysed_Validated_Date ensures the Date_Analysed/Validated_Date is not earlier than tblDHColl.Date_Started             New column Logged_Date/Logged_By             Updated TR_iutblDHMetSamp_UsingActiveLIBCode         --tblDHMetSampQC             New TR_iutblDHMetSampQC_Validated_Date ensures the Validated_Date is not earlier than tblDHColl.Date_Started             New column Logged_Date/Logged_By             Updated TR_iutblDHMetSampQC_UsingActiveLIBCode         --tblDHModelComposite             New TR_iutblDHModelComposite_Validated_Date ensures the Validated_Date is not earlier than tblDHColl.Date_Started         --tblDHPetrology             New table                   --tblDHRadiometrics             Removed column Original_Data_Source         --tblDHSamp             New column Logged_Date/Logged_By             New FK_tblDHSamp_tblLIBPerson_Logged_By             Updated TR_iutblDHSamp_UsingActiveLIBCode         --tblDHSampQC             New column Logged_Date/Logged_By             New FK_tblDHSampQC_tblLIBPerson_Logged_By             Updated TR_iutblDHSampQC_UsingActiveLIBCode         --tblDHSampWater             New CK_tblDHSampWater_Depth_From_Depth_To             New column Logged_Date/Logged_By             New FK_tblDHSampWater_tblLIBPerson_Logged_By             Updated TR_iutblDHSampWater_UsingActiveLIBCode             --tblDHSampWaterQC             New CK_tblDHSampWaterQC_Depth_From_Depth_To             New column Logged_Date/Logged_By             New FK_tblDHSampWaterQC_tblLIBPerson_Logged_By             Updated TR_iutblDHSampWaterQC_UsingActiveLIBCode             --tblDHStructure             New TR_iutblDHStructure_Validated_Date ensures the Validated_Date is not earlier than tblDHColl.Date_Started             New FK_tblDHStructure_tblLIBPerson_Validated_By             Updated TR_iutblDHStructure_UsingActiveLIBCode                   --tblDHStructureOrient             Updated TR_iutblDHStructureOrient_Alpha_Beta_Gamma_Calculate to use tblSYSParam.StructOrient_AzimuthField for calculation                   --tblDHSurv             New column Survey_Reliability             New FK_tblDHSurv_tblLIBSurveyReliability_Survey_Reliability             Updated TR_iutblDHSurv_UsingActiveLIBCode             Updated TR_iudtblDHSurv_Dip_MAG_Azimuth_Depth_Priority_Calculate to use tblSYSParam.StructOrient_AzimuthField for calculation                   --tblDHWater             Updated TR_utblDHWater to reflect PK columns                   --tblLeases             New column Is_Active                   --tblLIBAutoAssayActionTypes             New TR_utblLIBAutoAssayActionTypes                   --tblLIBAutoAssayImportRuleTypes             New TR_utblLIBAutoAssayImportRuleTypes                   --tblLIBAutoAssayQAQCType             New TR_utblLIBAutoAssayQAQCType                   --tblLIBCountry             Changed Code column length from 10 to 25         --tblLIBGeotFabric             New table                   --tblLIBGeotFFRating             New table                   --tblLIBGeotRockMassDomain             New table                   --tblLIBGeotRockStrengthFailureMode             New table                   --tblLIBGeotRockStrengthPostTestCondition             New table                   --tblLIBGeotRockSupport             New table                   --tblLIBGeotStrength             New table                   --tblLIBLithCode             Change Image column data type from image to varbinary(max)                   --tblLIBMachinery             Removed Factor/Factor_Unit             --tblLIBMachineryStatus             New column StatusCategory                      --tblLIBMachineryStatusCategory             New table             --tblLIBMagSusFactor             New column Is_Active/Sort_Order                   --tblLIBMetamorphicGrade             New table                   --tblLIBProvenance             New table                   --tblLIBQCGradeRange             Added default values for Au                   --tblLIBRegion             Changed Code column length from 10 to 25                   --tblLIBSampleTestType             New table                   --tblLIBShift             New column Time_Start/Time_End                   --tblLIBStructSpacing             New table                   --tblLIBSurveyReliability             New table                   --tblLSGeology             New CK_tblLSGeology_Alt1_Int_Style             New CK_tblLSGeology_Alt2_Int_Style             New CK_tblLSGeology_Min1_pct_Style             New CK_tblLSGeology_Min2_pct_Style             New CK_tblLSGeology_Lith2_Texture_Structure_etc                   --tblLSMagSus             Updated TR_iutblLSMagSus_UsingActiveLIBCode to include Instrument_FactorCode             --tblLSMapping             Updated FK_tblLSMapping_tblLSSite_DataSet_Site_ID_Line_ID with cascade on             --tblLSMetaData             New TR_iutblLSMetaData_Date_Completed ensures the Date_Completed is not earlier than tblLSSite.Date_Started             New CK_tblLSMetaData_Machinery_Contractor_MachineryID                   --tblLSMetSamp             New TR_iutblLSMetSamp_Date_Analysed_Validated_Date ensures the Date_Analysed/Validated_Date is not earlier than tblLSSite.Date_Started             Updated TR_iudtblLSMetSamp_Validated with validation against the Validated column in the table on update as well             New column Logged_Date/Logged_By             New FK_tblLSMetSamp_tblLIBPerson_Logged_By             Updated TR_iutblDHSampWaterQC_UsingActiveLIBCode                   --tblLSMetSampQC             New TR_iutblLSMetSampQC_Validated_Date ensures the Validated_Date is not earlier than tblLSSite.Date_Started             Updated TR_iudtblLSMetSampQC_Validated with validation against the Validated column in the table on update as well             New column Logged_Date/Logged_By             New FK_tblLSMetSampQC_tblLIBPerson_Logged_By             Updated TR_iutblLSMetSampQC_UsingActiveLIBCode                   --tblLSPetrology             New table                   --tblLSSamp             New column Logged_Date/Logged_By             New FK_tblLSSamp_tblLIBPerson_Logged_By             Updated TR_iutblLSSamp_UsingActiveLIBCode                   --tblLSSampQC             New column Logged_Date/Logged_By             New FK_tblLSSampQC_tblLIBPerson_Logged_By             Updated TR_iutblLSSampQC_UsingActiveLIBCode                   --tblLSSampWater             New column Logged_Date/Logged_By             New FK_tblLSSampWater_tblLIBPerson_Logged_By             Updated TR_iutblLSSampWater_UsingActiveLIBCode                   --tblLSSampWaterQC             New column Logged_Date/Logged_By             New FK_tblLSSampWaterQC_tblLIBPerson_Logged_By             Updated TR_iutblLSSampWaterQC_UsingActiveLIBCode                   --tblLSSite             New TR_utblLSSite_Rename to update tblStandardSamp.SourceID/Secondary_Source_ID when DataSet/Site_ID/Line_ID renamed             New column LL_Geometry                   --tblLSWater             Updated TR_utblLSWater to reflect PK columns                   --tblPetrology             Removed table                   --tblPTGeology             New CK_tblPTGeology_Alt_Int_Style             New CK_tblPTGeology_Min_pct_Style             New CK_tblPTGeology_Vein_Style_pct             New CK_tblPTGeology_Lith_Texture_Structure_etc                   --tblPTMagSus             Updated TR_iutblPTMagSus_UsingActiveLIBCode to include Instrument_FactorCode                   --tblPTMetSamp             Updated TR_iudtblPTMetSamp_Validated with validation against the Validated column in the table on update as well             New column Logged_Date/Logged_By             New FK_tblPTMetSamp_tblLIBPerson_Logged_By             Updated TR_iutblPTMetSamp_UsingActiveLIBCode         --tblPTMetSampQC             Updated TR_iudtblPTMetSampQC_Validated with validation against the Validated column in the table on update as well             New column Logged_Date/Logged_By             New FK_tblPTMetSampQC_tblLIBPerson_Logged_By             Updated TR_iutblPTMetSampQC_UsingActiveLIBCode         --tblPTPetrology             New table                   --tblPTSamp             New column Logged_Date/Logged_By             New FK_tblPTSamp_tblLIBPerson_Logged_By             Updated TR_iutblPTSamp_UsingActiveLIBCode             --tblPTSampQC             New column Logged_Date/Logged_By             New FK_tblPTSampQC_tblLIBPerson_Logged_By             Updated TR_iutblPTSampQC_UsingActiveLIBCode             --tblPTSampWater             New column Logged_Date/Logged_By             New FK_tblPTSampWater_tblLIBPerson_Logged_By             Updated TR_iutblPTSampWater_UsingActiveLIBCode             --tblPTSampWaterQC             New column Logged_Date/Logged_By             New FK_tblPTSampWaterQC_tblLIBPerson_Logged_By             Updated TR_iutblPTSampWaterQC_UsingActiveLIBCode             --tblPTSite             New TR_utblPTSite_Rename to update tblStandardSamp.SourceID when DataSet/Site_ID renamed             New column Historic_Site_ID             New column LL_Geometry             New TR_utblPTSite_Site_Depth checks PT tables to ensure that their depth is not below the Site_Depth                   --tblPTWater             Updated TR_utblPTWater to reflect PK columns                   --tblStandardSamp             New column Logged_Date/Logged_By             New FK_tblStandardSamp_tblLIBPerson_Logged_By             Updated TR_iutblStandardSamp_UsingActiveLIBCode             --tblStandardSampQC             New column Logged_Date/Logged_By             New FK_tblStandardSampQC_tblLIBPerson_Logged_By             Updated TR_iutblStandardSampQC_UsingActiveLIBCode                   --tblSYSAssBatch             Updated CK_tblSYSAssBatch_Lab_Job_Date/CK_tblSYSAssBatch_Lab_Received_Date logic to only valid if [Lab_Prelim_Date] or [Lab_Received_Date] present             Changed Lab_Received_Date/Lab_Prelim_Date/Lab_Job_Date/Dispatched_Date data type from datetime to datetime                   --tblSYSAssDispatchHeader             Changed Dispatched_Date data type from datetime to date                   --tblSYSAssElement             Updated TR_utblSYSAssElement_SystemUnits logic to recalculate sysResult, also enhanced to handle all related assay tables configured in tblSYSConfigRelation not just tblAssay                   --tblSYSAssQCResultDetail             Added column description                   --tblSYSAutoAssayAlertSettings             Added column description                   --tblSYSAutoAssayAttachments             Added column description             Updated FK_tblSYSAutoAssayAttachments_tblSYSAutoAssayEmails with cascade on                   --tblSYSAutoAssayConfigurations             Added column description                   --tblSYSAutoAssayDirectorySettings             Added column description             Updated FK_tblSYSAutoAssayDirectorySettings_tblLIBAutoAssayActionTypes with cascade on                   --tblSYSAutoAssayEmails             Added column description                   --tblSYSAutoAssayImportRules             Added column description             Updated FK_tblSYSAutoAssayImportRules_tblLIBAutoAssayActionTypes with cascade on             Updated FK_tblSYSAutoAssayImportRules_tblLIBAutoAssayImportRuleTypes with cascade on             Updated FK_tblSYSAutoAssayImportRules_tblLIBAutoAssayQAQCType with cascade on                   --tblSYSConversionFactor             Updated conversion factor for MOLAR type             New TR_iutblSYSConversionFactor_CodeFrom_CodeTo to ensure valid unit code used                   --tblSYSDHAuditConfig             New table used by DH Audit SP                   --tblSYSDSConfig             New column ImagoAccess/ImagoParam                   --tblSYSFilter             Updated FK_tblSYSFilter_tblSYSFilterType with cascade on             --tblSYSFilterType             Updated config value for DownHole for DS5                   --tblSYSMapFilter             Updated FK_tblSYSMapFilter_tblSYSFilterType_FilterTypeID with cascade on             --tblSYSNormAttribute             Added configuration for GenericMethod/LabCode/Batch_No                   --tblSYSNormAttributeDef             Added configuration for GenericMethod/LabCode/Batch_No                   --tblSYSParam             Renamed paramter AssayMergeReslutPreferredValue to AssayMergeResultPreferredValue             New paramter StructOrient_AzimuthField/ RQDPct_UseRecoveryInterval                   --tblSYSProject             Change State column length from 10 to 25                   --tblSYSQCCategory             Added column Description                   --tblSYSQCConfig             Updated TR_utblSYSQCConfig_CreatedBy_Created to filter on Modified_Date/By to prevent dead loop caused by TR_utblSYSQCConfig                   --tblSYSQCReference             Changed Is_Active default from 0 to 1                   --tblSYSQCReferenceType             Added new codes                   --tblSYSQCSampleEvents             Changed SampleID length from 30 to 50                   --tblSYSReportData             Updated FK_tblSYSReportData_tblLIBReportingType_Report_Type with cascade on             --tblSYSReportDetail             Updated FK_tblSYSReportDetail_tblLIBReportingType_Reporting_Type with cascade on             Updated FK_tblSYSReportDetail_tblSYSReportSection_Report_ID_Section_ID with cascade on             --tblSYSSRSDatum             Changed ScaleCorrection to not null with default 0                   --tblSYSSRSEllipsoid             Changed SemiMajorAxis to not null with default 0                   --tblSYSSRSProjection             Changed ScaleFactor to not null with default 0             New CK_tblSYSSRSProjection_CentralMeridian             New CK_tblSYSSRSProjection_OriginalLatitude             New CK_tblSYSSRSProjection_FirstStandard             New CK_tblSYSSRSProjection_SecondStandard         --tblSYSTableDisplay             Added column description                   --tblSYSUnits             Added new code SI/CGS/MKS/MS/CM                   --tblSYSUnitType             Added new code MagSus                   --tblSYSXRFIncomingLabStandards             New column LabCode to filter IncomingDataDriver target data                   --tblVWDHAssays             Improved performance by using new ranking config for GenericMethod/Batch_No                   --tblVWDHAssaysElements             New view for DS5                   --tblVWDHAssaysQC             Improved performance by using new ranking config for GenericMethod/Batch_No                   --tblVWDHAssaysWater             Improved performance by using new ranking config for GenericMethod/Batch_No                   --tblVWDHAssaysWaterQC             Improved performance by using new ranking config for GenericMethod/Batch_No         --tblVWDHAuditView             Update view to remove ORDER BY                   --tblVWDHCollarAttributes             Modified view to handle both split/combined geology system             --tblVWDHGeotechRMR_Calc             Updated view to reflect PK change             --tblVWDHGeotechRMRLogging             Updated view to reflect PK change                   --tblVWDHLithology             New view for DS5         --tblVWLSAssays             Improved performance by using new ranking config for GenericMethod/Batch_No         --tblVWLSAssaysQC             Improved performance by using new ranking config for GenericMethod/Batch_No         --tblVWLSAssaysWater             Improved performance by using new ranking config for GenericMethod/Batch_No         --tblVWLSAssaysWaterQC             Improved performance by using new ranking config for GenericMethod/Batch_No         --tblVWPTAssays             Improved performance by using new ranking config for GenericMethod/Batch_No         --tblVWPTAssaysWater             Improved performance by using new ranking config for GenericMethod/Batch_No             --tblVWReportScreenTest             New view for DS5                   --tblVWSampleDispatchReport             Updated logic to use DATEDIFF to calculate date difference after columns data type changed from datetime to date             --tblVWStandardAssays             Improved performance by using new ranking config for GenericMethod/Batch_No         --tblVWStandardAssaysQC             Improved performance by using new ranking config for GenericMethod/Batch_No             --tblVWStandardAssaysWater             Improved performance by using new ranking config for GenericMethod/Batch_No         --tblVWStandardAssaysWaterQC             Improved performance by using new ranking config for GenericMethod/Batch_No             --tblVWXRFDHResultsQC             New view                   --tblVWXRFResultsQC             New View                   --tblVWXRFResultsStandard             New view                   --tblVWXRFResultsStandardQC             New view         --tblXRFDHGeology             New CK_tblXRFDHGeology_Depth_From_Depth_To             Changed default for Load_Date from getdate() to sysdatetimeoffset()             New TR_iutblXRFDHGeology_Valid_Intervals to ensure sample depth not greater than maxdepth of hole             New TR_iutblXRFDHGeology_Interval_Overlap prevent overlap interval             New TR_iutblXRFDHGeology_Depth_From_Depth_To prevent mixture of interval and depth data                   --tblXRFDHSamp             New column Logged_Date/Logged_By             New FK_tblXRFDHSamp_tblLIBPerson_Logged_By             Updated TR_iutblXRFDHSamp_UsingActiveLIBCode                   --tblXRFDHSampQC             New column Logged_Date/Logged_By             New FK_tblXRFDHSampQC_tblLIBPerson_Logged_By             Updated TR_iutblXRFDHSampQC_UsingActiveLIBCode                   --tblXRFGeology             Changed default for Load_Date from getdate() to sysdatetimeoffset()         --tblXRFSamp             Removed redundant FK_tblXRFSamp_tblSYSDataSet_DataSet             Added column description             New column Logged_Date/Logged_By             New FK_tblXRFSamp_tblLIBPerson_Logged_By             Updated TR_iutblXRFSamp_UsingActiveLIBCode         --tblXRFSampQC             Removed redundant FK_tblXRFSampQC_tblSYSDataSet_DataSet             Added column description             New column Logged_Date/Logged_By             New FK_tblXRFSampQC_tblLIBPerson_Logged_By             Updated TR_iutblXRFSampQC_UsingActiveLIBCode             Updated FK_tblXRFSampQC_tblPTSite_DataSet_Site_ID with cascade on         --tblXRFStandardSamp             New column Source_ID/Secondary_Source_ID/Source_Type/Logged_Date/Logged_By             New FK_tblXRFStandardSamp_tblLIBStandardSampSourceType_Source_Type             New FK_tblXRFStandardSamp_tblLIBPerson_Logged_By             New TR_iutblXRFStandardSamp_Source_ID to check the integrity of Source_ID/Secondary_Source_ID/Source_Type             Updated TR_iutblXRFStandardSamp_UsingActiveLIBCode                   --tblXRFStandardSampQC             New column Logged_Date/Logged_By             New FK_tblXRFStandardSamp_tblLIBPerson_Logged_By             Updated TR_iutblXRFStandardSampQC_UsingActiveLIBCode                   --usp_AdminBatchDelete             Fixed issue with delete standard sample                   --usp_AdminDataDictionary             Fixed col_lgth value                   --usp_DataAssayMergingProcess             Reflect tblSYSParam.AssayMergeReslutPreferredValue renamed to AssayMergeResultPreferredValue             Updated exception comments for NoSampleMatch             --usp_DataAssayQCRuleChecker             Enhanced logic to allow partial merge when no QC rule setup                   --usp_DataDrillHoleAudit             New SP can be used to replace the drill hole audit extension                   --usp_DataStructOrientDriver             Introduced tblSYSParam.StructOrient_AzimuthField so client can set the Azimuth field as appropriate                   --usp_DataXRFResultsMergingProcess             Fixed syntax error             For XRF data, only calculate sysResults for BDL if LimitLower is NOT NULL             Set Batch_Status to QC_NA after successful merge                   --usp_GridTransformation             Added @ExcludeValidated to exclude transform validated records.                   --usp_ProcessCombineMultipleTableColumns             Output more meaningful error messages             Removed @MergeTableName parameter to process all configured tables. For any table don't want to run against, just set Is_Active to 0                   --usp_ProcessInComingDataDriver             Enhanced logic to handle StandardSamp/QC table, in case where client might add Hole_ID into StandardSamp table             Igore config with no QC table mapped instead of error out.             Updated error message             Enhanced logic to avoid need to run the driver twice                   --usp_ProcessLabChecksInComingData             Enhanced logic to avoid need to run the driver twice                   --usp_ProcessStandardsInComingData             Enhanced logic to handle StandardSamp/QC table, in case where client might add Hole_ID into StandardSamp table             Enhanced logic to avoid need to run the driver twice             --usp_ProcessXRFLabChecksInComingData             Fixed syntax error                   --usp_ProcessXRFStandardsInComingData             Fixed syntax error                   --uspIC_InterceptCalculator             Enhanced logic to take into account missing/overlap interval when calculating weighted average grade. Missing interval will have 0 grade for averaging calc.         --Following SP/functions are DS5 2.3.1 changes             usp_RptDHLoggingStats              usp_RptDrillHoleandSampleTypeSummaryByDataSet             usp_RptDrillHoleandSampleTypeSummaryTotal             usp_RptDrillLogTableData             usp_RptMaximumDownholeAssayValues             usp_RptMaximumDownholeAssayValuesCt             usp_RptMaximumDownholeAssayValuesTenement             usp_RptQAQC_GradeRangeMeanStDevMinMax             usp_RptQAQC_GradeRangeQuartile             usp_RptQAQC_HorwitzTrumpetAverageSTD             usp_RptQAQC_HorwitzTrumpetBadRepeats             usp_RptQAQC_HorwitzTrumpetChart             usp_RptQAQC_HorwitzTrumpetGroup             usp_RptQAQC_HorwitzTrumpetSummary             usp_RptQAQC_LabTurnaround_Chart             usp_RptQAQC_LabTurnaround_MonthAvg             usp_RptQAQC_LabTurnaround_OverallAvg             usp_RptQAQC_MonthlyQQPlot_BadRepeats             usp_RptQAQC_MonthlyQQPlot_Grouping             usp_RptQAQC_MonthlyQQPlotChart             usp_RptQAQC_MonthlyQQPlotSummary             usp_RptQAQC_MonthlyReport             usp_RptQAQC_MonthlyReport_BadStandards             usp_RptQAQC_MonthlyReport_BatchSummary             usp_RptQAQC_MonthlyReport_Blank             usp_RptQAQC_MonthlyReport_CRMStandards             usp_RptQAQC_MonthlyReport_CrushChecks             usp_RptQAQC_MonthlyReport_Flushes             usp_RptQAQC_MonthlyReport_MultiStandardControlCharts             usp_RptQAQC_MonthlyReport_Repeatability             usp_RptQAQC_MonthlyReport_SingleStandardControl             usp_RptQAQC_MonthlyReport_SingleStandardControlCharts             usp_RptQAQC_MonthlyReport_SingleStandardStdPlotControlCharts             usp_RptQAQC_MonthlyReport_StandardsSubmittedSummary             usp_RptQAQC_MonthlyScatterPlot_BadRpts             usp_RptQAQC_MonthlyScatterPlotChart             usp_RptQAQC_MonthlyScatterPlotGrouping             usp_RptQAQC_MonthlyScatterPlotSummary             usp_RptQAQC_ScatterPlot_GetCharts             usp_RptQAQC_ScreenTest             usp_RptQAQC_ScreenTest_Chart             usp_RptQAQC_ScreenTest_Summary             usp_RptStripLog             usp_RptStripLogHeader             utf_RptQAQC_GradeRange             utf_RptQAQC_LabTurnaround                                   ************************************* Following changes are for v4.6.5 and model specific: ************************************* For Production models       --tblFSGeology             New CK_tblFSGeology_Alt1_Int_Style             New CK_tblFSGeology_Alt2_Int_Style             New CK_tblFSGeology_Min1_pct_Style             New CK_tblFSGeology_Min2_pct_Style             New CK_tblFSGeology_Lith2_Texture_Structure_etc             New TR_iutblFSGeology_Depth_From_Depth_To ensures no mixture of interval and depth data                   --tblFSMagSus             Updated TR_iutblFSMagSus_UsingActiveLIBCode             New TR_iutblFSMagSus_Depth_From_Depth_To ensures no mixture of interval and depth data                   --tblFSMapping             New CK_tblFSMapping_Depth_From_Depth_To             New TR_iutblFSMapping_Depth_From_Depth_To ensures no mixture of interval and depth data                   --tblFSMetaData             New TR_iutblFSMetaData_Date_Completed ensures the Date_Completed is not earlier than tblFSSite.Date_Started             New TR_iutblFSMetaData_Depth_From_Depth_To ensures no mixture of interval and depth data             New CK_tblFSMetaData_Machinery_Contractor_MachineryID                   --tblFSMetSamp             New TR_iutblFSMetSamp_Date_Analysed_Validated_Date ensures the Date_Analysed/Validated_Date is not earlier than tblFSSite.Date_Started             Updated TR_iudtblFSMetSamp_Validated validation against the Validated column in the table on update as well             New column Logged_Date/Logged_By             New FK_tblFSMetSamp_tblLIBPerson_Logged_By             Updated TR_iutblFSMetSamp_UsingActiveLIBCode             New TR_iutblFSMetSamp_Depth_From_Depth_To ensures no mixture of interval and depth data                   --tblFSMetSampQC             New TR_iutblFSMetSampQC_Validated_Date ensures the Validated_Date is not earlier than tblFSSite.Date_Started             Updated TR_iudtblFSMetSampQC_Validated validation against the Validated column in the table on update as well             New column Logged_Date/Logged_By             New FK_tblFSMetSampQC_tblLIBPerson_Logged_By             Updated TR_iutblFSMetSampQC_UsingActiveLIBCode             New TR_iutblFSMetSampQC_Depth_From_Depth_To ensures no mixture of interval and depth data             --tblFSPetrology             New table                   --tblFSSamp             New column Logged_Date/Logged_By             New FK_tblFSSamp_tblLIBPerson_Logged_By             Updated TR_iutblFSSamp_UsingActiveLIBCode             New TR_iutblFSSamp_Depth_From_Depth_To ensures no mixture of interval and depth data             New column Face_Composite                   --tblFSSampQC             New column Logged_Date/Logged_By             New FK_tblFSSampQC_tblLIBPerson_Logged_By             Updated TR_iutblFSSampQC_UsingActiveLIBCode             New TR_iutblFSSampQC_Depth_From_Depth_To ensures no mixture of interval and depth data                   --tblFSSampWater             New CK_tblFSSampWater_Depth_From_Depth_To             New column Logged_Date/Logged_By             New FK_tblFSSampWater_tblLIBPerson_Logged_By             Updated TR_iutblFSSampWater_UsingActiveLIBCode                   --tblFSSampWaterQC             New CK_tblFSSampWaterQC_Depth_From_Depth_To             New column Logged_Date/Logged_By             New FK_tblFSSampWaterQC_tblLIBPerson_Logged_By             Updated TR_iutblFSSampWaterQC_UsingActiveLIBCode                   --tblFSSite             New TR_utblFSSite_Rename to update tblStandardSamp.SourceID/Secondary_Source_ID when DataSet/Site_ID/Line_ID renamed             Updated TR_iutblFSSite_UsingActiveLIBCode to include Face_Type             New column LL_Geometry                   --tblFSWater             Updated TR_utblFSWater to reflect PK columns                   --tblLIBFaceType             New column Is_Active             --tblLIBMachineryFactor             New table             --tblLIBProdActivityStatus             New table                   --tblLIBProdCrew             New table                   --tblLIBProdDevelopmentStatus             New table             --tblProdActivity             New table             --tblProdBlasting             Removed BlockID             New columns ShiftDateCode/Blast_Cut_Advance/Blast_Cut_UnitCode/Blast_Operator/ReEntry_By/LG_SD             --tblProdBlastingBlock             New table             --tblProdBlastingBlockSurvey             New table                   --tblProdBlastingSurvey             New table                   --tblProdBlock             New trigger TR_iudtblProdBlock_BlockID                   --tblProdBlockMonthlySummary             Removed table                   --tblProdDailyUGDevelopment             Removed table             --tblProdEOMAdjustedActuals             Removed table             --tblProdEOMCommoditiesDetails             Removed table                   --tblProdEOMCommodities             Removed table                   --tblProdEOMCommoditiesPrice             Removed table                   --tblProdEOMActualsStockpiles             Renamed table to tblProdSurvey             Renamed LocationID to Site_ID             Change Surveyed_Tonnes to allow null             Changed Surveyed_Volume to not null             New column Shift/SiftDateCode/LG_sD             Changed PK             --tblProdEOMActualsStockpileCommodity             Renamed table to tblProdSurveyCommodity             New column ShiftDateCode/LG_SD             --tblProdLocations             New columns Material_Type/Is_Active             Updated FK_tblProdLocations_Material_Type with cascade on             --tblProdLocationsCommodity             New column Commodity_Grade_Category             --tblProdMaterialMovement             Renamed Movement_Code to Reporting_Type             Renamed LocationID_From to Prod_SourceID             Renamed LocationID_To to Prod_DestinationID             New columns Time_Loaded/ Time_Dumped/ Spotter_Name/ Weightometer_Reading/ Weightometer_Name/ Contractor_Movement_Value/ Contractor_Movement_Unit/ ShiftDateCode/LG_sD             Changed Movement_Value/Movement_SG to allow null             Removed columns Movement_Grade/Movement_Grade_Unit             Changed PK                   --tblProdEquipmentUtilisation             New table                   --tblProdReporting             Removed table                   --tblProdDailyTrucking             Merged into tblProdMaterialMovement                   --tblProdSamp             New column Logged_Date/Logged_By/LG_sD             New FK_tblProdSamp_tblLIBPerson_Logged_By             Updated TR_iutblProdSamp_UsingActiveLIBCode             Renamed LocationID to Site_ID             Added ShiftDateCode                   --tblProdSampQC             New column Logged_Date/Logged_By/LG_sD             New FK_tblProdSampQC_tblLIBPerson_Logged_By             Updated TR_iutblProdSampQC_UsingActiveLIBCode             Renamed LocationID to Site_ID             New columns Shift/ShiftDateCode                   --tblProdShiftRegister             New table         --tblProdSiteAssay             New table                   --tblProdSiteRegister             New table             --tblVWFSAssays             Improved performance by using new ranking config for GenericMethod/Batch_No         --tblVWFSAssaysQC             Improved performance by using new ranking config for GenericMethod/Batch_No         --tblVWFSAssaysWater             Improved performance by using new ranking config for GenericMethod/Batch_No         --tblVWFSAssaysWaterQC             Improved performance by using new ranking config for GenericMethod/Batch_No         --tblVWProdAssays             Improved performance by using new ranking config for GenericMethod/Batch_No         --tblVWProdAssaysQC             Improved performance by using new ranking config for GenericMethod/Batch_No         --tblVWProdDailyMaterial_From             Updated view to reflect table structure changed                   --tblVWProdDailyMaterial_To             Updated view to reflect table structure changed                   --tblVWProdDailyMovement             Updated view to reflect table structure changed             --tblVWProdEOMActualsStockpilesMerged             Updated view to reflect table structure changed             --tblVWProdEquipmentUtilisation             New view             --tblVWProdLocationBalanceVolume             Updated view to reflect table structure changed             --tblVWProdLocationTrucking             Updated view to reflect table structure changed                   --tblVWProdMaterialMovement             Updated view to reflect table structure changed                   --tblVWProdMovementBalConditioned             Updated view to remvoed ORDER BY                   --tblVWProdReconTrucktoResource             Updated view to reflect table structure changed                   --tblVWProdSamp             Updated view to reflect table structure changed                         --tblVWProdStockpileBal_EOMDate             Updated view to reflect table structure changed             --tblVWProdStockpileBalMeasured             Updated view to reflect table structure changed                   --tblVWProdTruckingCalculated             Updated view to reflect table structure changed                   --tblVWProdTruckingClaimed             Updated view to reflect table structure changed                   --tblVWProdTruckingMonthly             Updated view to remvoed ORDER BY and reflect table structure changed         --tblVWProdTruckingRpt             Updated view to remvoed ORDER BY                   --usp_ProdLocationBalanceReportingTroubleshooter             New logic to reflect table structure change                   --usp_PopulateProdLocationBalance             New logic to reflect table structure change and move away from CLR                   --usp_PopulateProdSiteAssay             New SP to work out Prod sample assays to be used by material movements   For Diamond models       --tblDHCaliper             New TR_iudtblDHCaliper_Validated to prevent data modification (I/U/D) if parent table has Validated = 1             Changed Data_Source column length from 100 to 255             --tblDHGeologyInterpLog             Changed Data_Source column length from 100 to 255                   --tblDHGeologySubUnits             Changed Data_Source column length from 100 to 255             Updated FK_tblDHGeologySubUnits_tblLIBLithGrainPacking_Grain_Packing with cascade on             --tblDHGroundmass             Changed Data_Source column length from 100 to 255             --tblDHKimberlite             Changed Data_Source column length from 100 to 255             Updated FK_tblDHKimberlite_tblLIBLithContrast_Cognitive_Olivine_Grain_Contrast with cascade on             Updated FK_tblDHKimberlite_tblLIBLithGrainsize_Cognitive_Olivine_GrainSize with cascade on             --tblDHMinerals             Changed Data_Source column length from 100 to 255                   --tblDHSamp             Updated FK_tblDHSamp_tblLIBDMDAnalysisMethod_Analysis_Method with cascade on             --tblDMDBackGroundMineral             Updated FK_tblDMDBackGroundMineral_tblLIBDMDMineralAbundance_Abundance with cascade on             Updated FK_tblDMDBackGroundMineral_tblLIBDMDMinerals_Mineral with cascade on             --tblDMDDiamond             Updated FK_tblDMDDiamond_tblLIBDMDDiamondClarity_Clarity with cascade on             Updated FK_tblDMDDiamond_tblLIBDMDDiamondColour_Colour with cascade on             Updated FK_tblDMDDiamond_tblLIBDMDDiamondEdges_Edges with cascade on             Updated FK_tblDMDDiamond_tblLIBDMDDiamondForm_Diamond_Form with cascade on             Updated FK_tblDMDDiamond_tblLIBDMDDiamondFrosting_Frosting with cascade on             Updated FK_tblDMDDiamond_tblLIBDMDDiamondInclusions_Inclusions with cascade on             Updated FK_tblDMDDiamond_tblLIBDMDDiamondType_Type with cascade on             Updated FK_tblDMDDiamond_tblLIBDMDSizeFraction_Size_Fraction with cascade on             --tblDMDDiamondRecovery             Updated FK_tblDMDDiamondRecovery_tblLIBDMDSeries_Series with cascade on             Updated FK_tblDMDDiamondRecovery_tblLIBDMDSizeFraction_Size_Fraction with cascade on             --tblDMDIndicator             Updated FK_tblDMDIndicator_tblLIBDMDIndicatorAmount_Count_Or_Estimate with cascade on             Updated FK_tblDMDIndicator_tblLIBDMDMinerals_Indicator_Code with cascade on             Updated FK_tblDMDIndicator_tblLIBDMDSizeFraction_Size_Fraction with cascade on             --tblDMDIndicatorDesc             Updated FK_tblDMDIndicatorDesc_tblLIBDMDIndicatorDesc_Desc_Code with cascade on                   --tblDMDMineralGrain             Updated FK_tblDMDMineralGrain_tblLIBDMDMinerals_Mineral_As_Observed with cascade on             Updated FK_tblDMDMineralGrain_tblLIBDMDProbeClassification_Classification with cascade on             Updated FK_tblDMDMineralGrain_tblLIBDMDProbeMethod_LabMethod with cascade on             Updated FK_tblDMDMineralGrain_tblLIBDMDSizeFraction_Size_Fraction with cascade on             Updated FK_tblDMDMineralGrain_tblSYSASSLab_LabCode with cascade on             --tblDMDMineralGrainChemistry             Updated FK_tblDMDMineralGrainChemistry_tblLIBDMDAnalysisPosition_Analysis_Position with cascade on             Updated FK_tblDMDMineralGrainChemistry_tblLIBDMDAnalyte_Analyte with cascade on             Updated FK_tblDMDMineralGrainChemistry_tblLIBDMDProbeResultCategory_Result_Category with cascade on             Updated FK_tblDMDMineralGrainChemistry_tblSYSUnits_UnitCode with cascade on             --tblDMDSamp             Updated FK_tblDMDSamp_tblSampleRegister_DataSet_SampleID with cascade on             Updated FK_tblDMDSamp_tblSYSASSLab_LabCode with cascade on             Updated FK_tblDMDSamp_tblSYSUnits_Weight_Received_UnitCode with cascade on             --tblDMDSampObservationWeights             Updated FK_tblDMDSampObservationWeights_tblLIBDMDSizeFraction_Size_Fraction with cascade on             --tblDMDSampProcessing             Updated FK_tblDMDSampProcessing_tblDMDSamp_DataSet_SampleID with cascade on             Updated FK_tblDMDSampProcessing_tblLIBDMDProcesses_Parent_Process with cascade on             Updated FK_tblDMDSampProcessing_tblLIBDMDProcessFraction_Process_Fraction with cascade on             --tblGeophysAnomaly             Updated FK_tblGeophysAnomaly_tblGeophysSurvey_Survey_ID with cascade on             --tblGeophysSurvey             Updated FK_tblGeophysSurvey_tblLIBGeophysSurveyMethod_Survey_Method with cascade on             Updated FK_tblGeophysSurvey_tblLIBInstrument_Instrument with cascade on             --tblLIBDominCode             Removed table as it's duplicated with tblLIBDomainCode         --tblLSSampBulk             New TR_iudtblLSSampBulk_Validated to prevent data modification (I/U/D) if parent table has Validated = 1             Updated FK_tblLSSampBulk_tblLIBDMDSizeFraction_Size_Fraction with cascade on             Updated FK_tblLSSampBulk_tblLIBPerson_Sampled_By with cascade on             Updated FK_tblLSSampBulk_tblLIBSampleCondition_Sample_Condition with cascade on             Updated FK_tblLSSampBulk_tblLIBSampleMethod_Sample_Method with cascade on             Updated FK_tblLSSampBulk_tblSYSDataSet_DataSet with cascade on                   --tblPTSamp             Updated FK_tblPTSamp_tblGeophysAnomaly_DataSet_AnomalyID with cascade on             Updated FK_tblPTSamp_tblLIBDMDAnalysisMethod_Analysis_Method with cascade on          For Coal models       --tblDHBulkFractionProximates             Updated FK_tblDHBulkFractionProximates_tblDHColl_DataSet_Hole_ID with cascade on             --tblDHColl             New column Local_Grid_ID/Local_East/Local_North/Local_RL/Local_Survey_Method/Local_Survey_Date/Local_Survey_By/Local_Survey_Company             Updated FK_tblDHColl_tblLIBHolePurpose_Hole_Purpose with cascade on                   --tblDHCompositeAshAnalyses             Updated FK_tblDHCompositeAshAnalyses_tblDHColl_DataSet_Hole_ID with cascade on             --tblDHCompositeAshFusion             Updated FK_tblDHCompositeAshFusion_tblDHColl_DataSet_Hole_ID with cascade on             --tblDHCompositeDilPlastGrind             Updated FK_tblDHCompositeDilPlastGrind_tblDHColl_DataSet_Hole_ID with cascade on             --tblDHCompositePetrography             Updated FK_tblDHCompositePetrography_tblDHColl_DataSet_Hole_ID with cascade on             --tblDHCompositePetroMinMatter             Updated FK_tblDHCompositePetroMinMatter_tblDHColl_DataSet_Hole_ID with cascade on             --tblDHCompositePetroVitrinite             Updated FK_tblDHCompositePetroVitrinite_tblDHColl_DataSet_Hole_ID with cascade on             --tblDHCompositeProximates             Updated FK_tblDHCompositeProximates_tblDHColl_DataSet_Hole_ID with cascade on             --tblDHCompositeSpectrometer             Updated FK_tblDHCompositeSpectrometer_tblDHColl_DataSet_Hole_ID with cascade on             --tblDHCompositeSulfur             Updated FK_tblDHCompositeSulfur_tblDHColl_DataSet_Hole_ID with cascade on             --tblDHCompositeUltimates             Updated FK_tblDHCompositeUltimates_tblDHColl_DataSet_Hole_ID with cascade on             --tblDHGeophysics_SONIC             Updated column description             Added standard default permission             Updated FK_tblDHGeophysics_SONIC_tblSYSUnits_Sonic_UnitCode with cascade on             --tblDHH2S             New TR_iutblDHH2S_Depth_From_Depth_To ensures no mixture of interval and depth data                   --tblDHIncrementalProximates             Updated FK_tblDHIncrementalProximates_tblDHColl_DataSet_Hole_ID with cascade on             --tblDHRMU             New TR_iutblDHRMU_Depth_From_Depth_To ensures no mixture of interval and depth data                   --tblDHSeam             New TR_iutblDHSeam_Depth_From_Depth_To ensures no mixture of interval and depth data                   --tblDHSeamHistory             New TR_iutblDHSeamHistory_Depth_From_Depth_To ensures no mixture of interval and depth data                               --tblDHSlake             New TR_iutblDHSlake_Depth_From_Depth_To ensures no mixture of interval and depth data                   --tblDHTDGas             New TR_iutblDHTDGas_Depth_From_Depth_To ensures no mixture of interval and depth data                   --tblDHUCS             New TR_iutblDHUCS_Depth_From_Depth_To ensures no mixture of interval and depth data                   --tblVWSites             Updated view to include FS site
v4.6.4 ************************************* Following changes are for v4.6.4 ALL models *************************************       --All base audit triggers enhanced to try do updtaes only once with nested calls and to accept specify Modified_By by specific software       --All base UsingActiveLIBCode triggers updated to allow updates via MxSync       --Added Validated trigger on all downhole tables             --tblAssay             TR_iudtblAssay_Validated reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblAssay_AssayResultNum_UnitCode_LimitLower_sysAssayStatus_Element reflects new tblSYSNormProcessStack.LabCode/Batch_No columns             TR_dtblAssay reflects new tblSYSNormProcessStack.LabCode/Batch_No columns                   --tblAssayFlatWater             TR_iudtblAssay_Validated reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code       TR_utblAssayWater_AssayResultNum_UnitCode_LimitLower_sysAssayStatus_Element_Repeat_Preferred reflects new tblSYSNormProcessStack.LabCode/Batch_No columns             TR_dtblAssayWater reflects new tblSYSNormProcessStack.LabCode/Batch_No columns                   --tblDHColl             Enhanced trigger TR_utblDHColl_Max_Depth to only do check when Max_Depth decrease                   --tblDHCollPlanned             New trigger TR_iutblDHCollPlanned_DHColl_LCH. This trigger is disabled in MDS master database and will be enabled in LogChief database.                   --tblDHCoreRecoveryRun             Enhanced trigger TR_iutblDHCoreRecoveryRun_RQDPct_RecoveryPct to handle Turkish I issue             --tblDHGeotechRMR             Updated computed column RQD_Deere_pct to be persisted             Updated TR_iutblDHGeotechRMR_Recovery_pct_RQD_pct_Solid_Recovery_pct to allow MxSync do bulk update                   --tblDHGeotechRQD             Updated TR_iutblDHGeotechRQD_RQD_pct to allow MxSync do bulk update                   --tblDHMetSamp             TR_itblDHMetSamp reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblDHMetSamp_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblDHMetSampQC             TR_itblDHMetSampQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblDHMetSampQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblDHSamp             TR_itblDHSamp reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblDHSamp_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblDHSampQC             TR_itblDHSampQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblDHSampQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblDHSampWater             TR_itblDHSampWater reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblDHSampWater_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblDHSampWaterQC             TR_itblDHSampWaterQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblDHSampWaterQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblDHSurv             TR_iudtblDHSurv_Priority_Recalculate reflects rename tblSYSParam.HeighestPriorityValue to HighestPriorityValue                   --tblLIBAutoAssayActionTypes             New table             --tblLIBAutoAssayImportRuleTypes             New table                   --tblLIBAutoAssayQAQCType             New table                   --tblLIBCountry             New table                   --tblLIBMachineryStatus             New table                   --tblLIBRegion             New table                   --tblLIBSynchStatus             New table         --tblLSMapping             Changed PK to include Length_From                   --tblLSMetSamp             TR_itblLSMetSamp reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblLSMetSamp_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblLSMetSampQC             TR_itblLSMetSampQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblLSMetSampQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_iutblLSMetSampQC_Orig_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblLSSamp             TR_itblLSSamp reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblLSSamp_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblLSSampQC             TR_itblLSSampQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblLSSampQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblLSSampBulk             TR_itblLSSampBulk reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblLSSampBulk_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblLSSampWater             TR_itblLSSampWater reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblLSSampWater_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblLSSampWaterQC             TR_itblLSSampWaterQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblLSSampWaterQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblPetrology             TR_itblPetrology reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblPetrology_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblProdSamp             TR_itblProdSamp reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblProdSamp_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblProdSampQC             TR_itblProdSampQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblProdSampQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblPTMetSamp             TR_itblPTMetSamp reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblPTMetSamp_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblPTMetSampQC             TR_itblPTMetSampQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblPTMetSampQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblPTSamp             TR_itblPTSamp reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblPTSamp_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblPTSampQC             TR_itblPTSampQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblPTSampQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblPTSampWater             TR_itblPTSampWater reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblPTSampWater_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblPTSampWaterQC             TR_itblPTSampWaterQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblPTSampWaterQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             --tblSampleRegister             TR_iutblSampleRegister_SourceTable reflects change to SourceTable now capture the actual table name instead of a code                   --tblStandardSamp             TR_itblStandardSamp reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblStandardSamp_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblStandardSampQC             TR_itblStandardSampQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblStandardSampQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             --tblSYSAssBatch             New column Batch_Status             New trigger TR_utblSYSAssBatch_Audit to capture change to Batch_Status             Removed FK_tblSYSAssBatch_tblLIBPerson_Validated_By                   --tblSYSAssBatchStatus             New table                   --tblSYSAssBatchStatusLog             New table                   --tblSYSAssQCPolicy             New table                   --tblSYSAssQCPolicyLayout             New table                   --tblSYSAssQCPolicyRule             New table                   --tblSYSAssQCResult             New table                   --tblSYSAssQCResultDetail             New table                   --tblSYSAutoAssayAttachments             New table for AAL                   --tblSYSAutoAssayConfigurations             New table for AAL                   --tblSYSAutoAssayDirectorySettings             New table for AAL                   --tblSYSAutoAssayEmails             New table for AAL             --tblSYSAutoAssayImportRules             New table for AAL                   --tblSYSConfigRelation             Removed column SourceTable/DisplaySampleType             New column Depth_From_Field/Dataset_Parent_Table                   --tblSYSEmailNotifications             New table                   --tblSYSFilter             New column Is_Active/Filter_DefinitionSQL/Filter_CascadeTypeID/DS4_Updated             New trigger TR_utblSYSFilter_DS4_Updated             --tblSYSFilterList             New table                   --tblSYSFilterType             New table                   --tblSYSImportLayoutEmail             New table                   --tblSYSMapFilter             New table                   --tblSYSMapFilterItem             New table                   --tblSYSNormProcessStack             New column LabCode/Batch_No                   --tblSYSObject             Extended column Name length to 255             --tblSYSProject             Change Region/Country to no allow null             --tblSYSQCGroup             Net table                   --tblSYSQCRule             New table                   --tblSYSQCType             New table                   --tblSYSReportData             New table                   --tblSYSReportDetail             New table                   --tblSYSReportHeader             New table                   --tblSYSReportSection             New table                   --tblSYSSPConfig             Removed table                   --tblSYSTableDisplay             New table                   --tblSYSUserDataset             Changed Dataset column length from 30 to 32         --tblVWAALMonitor             New view                   --tblVWAMBatchApproval             New view                   --tblVWAMFilter             New view             --tblVWContractActivitySummary             Updated view             --tblVWDASHContractCosts             New view             --tblVWDASHFilter             New view             --tblVWReportActivityContractDetails             New view             --tblVWReportCollar             New view             --tblVWReportContractActivityLogMetres             New view             --tblVWReportDrillingStatus             New view             --tblVWReportProd             New view             --tblVWReportProdBalance             New view             --tblVWRPTActivityLog             New view             --tblVWSYSAssQCResult             New view             --tblVWSYSAssQCResult_BLK             New view             --tblVWSYSAssQCResult_CRM             New view             --tblVWSYSAssQCResult_DUP             New view             --tblVWSYSAssQCResult_Screen             New view             --tblVWSYSAssQCResult_STD             New view             --tblVWWSDHColl             New view             --tblVWWSDHIntercepts             New view             --tblVWWSDHMaxAu_Current             New view             --tblVWWSPTMaxAssays_Current             New view             --tblVWWSPTSite             New view             --tblVWWSXRFResults             New view             --tblXRFDHSamp             TR_itblXRFDHSamp reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblXRFDHSamp_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblXRFDHSampQC             TR_itblXRFDHSampQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblXRFDHSampQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblXRFSamp             TR_itblXRFSamp reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblXRFSamp_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblXRFSampQC             TR_itblXRFSampQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblXRFSampQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblXRFStandardSamp             TR_itblXRFStandardSamp reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblXRFStandardSamp_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblXRFStandardSampQC             TR_itblXRFStandardSampQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblXRFStandardSampQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --New data type LabCodeBatchNo             --New function udf_GetViewOrderByList             --Removed function udf_RptGetColourCode             --New function udf_RptGetFieldConvert             --New SP usp_AdminBatchDelete             --New SP usp_CreateTableLastModifyDateView             --Enhanced SP usp_AdminCleanUpDataShedObjects             --Enhanced SP usp_DataAssayMergingProcess             --New SP usp_DataAssayQCRuleChecker             --Enhanced SP usp_DataAssayRankingProcess             --New SP usp_DataAssayUpdateBatchStatus             --Enhanced SP usp_DataXRFResultsMergingProcess             --New SP usp_GetFilter             --New SP usp_NDS_CostPMForYearToDate             --New SP usp_NDS_DrillEfficiencyPeriodToDate         --New SP usp_NDS_DrillHolesInProgress             --New SP usp_NDS_DrillingCostsYearToDate             --New SP usp_NDS_DrillingMetresMonthToDate             --New SP usp_NDS_DrillingMetresYearToDate             --New SP usp_NDS_LoggingStatistics             --New SP usp_NDS_SignificantDrillResults             --Enhanced SP usp_PopulateProdLocationBalance             --New SP usp_PopulateSYSReportData             --Enhanced SP usp_ProcessInComingDataDriver             --Enhanced SP usp_ProcessLabChecksInComingData             --Enhanced SP usp_ProcessStandardsInComingData             --Enhanced SP usp_ProcessXRFInComingDataDriver             --Enhanced SP usp_ProcessXRFLabChecksInComingData             --Enhanced SP usp_ProcessXRFStandardsInComingData             --New SP usp_RptActivityContractDetails             --New SP usp_RptBatchSummary             --New SP usp_RptCollars             --New SP usp_RptDHDrillLogAudit             --New SP usp_RptDHLoggingStats             --New SP usp_RptDrillLogTableData             --New SP usp_RptDrillStatus             --New SP usp_RptIncident             --New SP usp_RptProdReco             --New SP usp_RptProduction             --New SP usp_ValidateTableColumnExists             --New SP usp_WS_GetICFilters             --Enhanced SP uspIC_InterceptCalculator             --New SP uspIC_InterceptCalculator_Wrapper             --New function utf_MXAuditExceptionAppList             --New function utf_StringSpliter             --Change the database compatibility level to be the latest if not already       ************************************* Following changes are for v4.6.4 and model specific: ************************************* For Production model       --tblFSMapping             Changed PK to include Depth_From                   --tblFSMetSamp             TR_itblFSMetSamp reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblFSMetSamp_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblFSMetSampQC             TR_itblFSMetSampQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblFSMetSampQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_iutblFSMetSampQC_Orig_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             --tblFSSamp             New column Face_Composite             TR_itblFSSamp reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblFSSamp_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblFSSamp_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code                   --tblFSSampQC             TR_itblFSSampQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblFSSampQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblFSSampQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblFSSampWater             TR_itblFSSampWater reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblFSSampWater_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblFSSampWater_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         --tblFSSampWaterQC             TR_itblFSSampWaterQC reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblFSSampWaterQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             TR_utblFSSampWaterQC_DataSet_SampleID reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code             --tblLIBProdMaterialType             New column Default_SG                         For Coal model       --Added Validated trigger on all downhole tables                   --tblDHWater             TR_itblDHWater reflects change to tblSampleRegister.SourceTable now capture the actual table name instead of a code         For Diamond model       --Added Validated trigger on all downhole tables                   For Uranium model       --Added Validated trigger on all downhole tables
v4.6.3 SP1 ************************************* Following changes are for v4.6.3 SP1 ALL models *************************************       --tblAssay             Enhanced TR_iudtblAssay_Validated trigger to check for DH Samp data             Enhanced TR_utblAssay_AssayResultNum_UnitCode_LimitLower_sysAssayStatus_Element to handle Turkish collation                   --tblAssayWater             Enhanced TR_utblAssayWater_AssayResultNum_UnitCode_LimitLower_sysAssayStatus_Element_Repeat_Preferred to handle Turkish collation                   --tblBulkSamp             Renamed tblBulkSamp to tblLSSampBulk             Moved coordinates information into tblLSSite             Added Site_ID/Sample_Analysis_Method/Anomaly_ID/Bulk_Density_UnitCode                   --tblContractActivityLog             Enhanced trigger TR_utblContractActivityLog_Client_Validated_Reset             Enhanced trigger TR_iutblContractActivityLog_UsingActiveLIBCode                   --tblContractActivityLogDetails             Enhanced trigger TR_utblContractActivityLogDetails_Client_Validated_Reset             Enhanced trigger TR_iutblContractActivityLogDetails_UsingActiveLIBCode                   --tblContractActivityLogLSMetres             Enhanced trigger TR_utblContractActivityLogLSMetres_Client_Validated_Reset                   --tblContractActivityLogMetres             Enhanced trigger TR_utblContractActivityLogMetres_Client_Validated_Reset                   --tblContractDetailsRate             Enhanced trigger TR_iutblContractDetailsRate_UsingActiveLIBCode                   --tblDHWeathering             New trigger TR_iudtblDHWeathering_Validated             --tblDHColl             Enhanced trigger TR_utblDHColl_Max_Depth             New trigger TR_iutblDHColl_Validated                   --tblDHCollHistory             New trigger TR_iudtblDHCollHistory_Validated                   --tblDHCoreRecoveryRun             New trigger TR_iudtblDHCoreRecoveryRun_Validated             Enhanced trigger TR_iutblDHCoreRecoveryRun_RQDPct_RecoveryPct             Enhanced trigger TR_iutblDHCoreRecoveryRun_Depth_From_Depth_To_Interval_Core_COR_Recovery_Measured_Recovery_Estimated_REC_Lock_Bottom_Of_Run                   --tblDHCoreStorage             New columns Validated/ Validated_Date/ Validated_By             New trigger TR_iutblDHCoreStorage_Validated             Enhanced trigger TR_iutblDHCoreStorage_UsingActiveLIBCode                   --tblDHCoreStorageDetails             New columns Validated/ Validated_Date/ Validated_By             New trigger TR_iutblDHCoreStorageDetails_Validated             Enhanced trigger TR_iutblDHCoreStorageDetails_UsingActiveLIBCode                   --tblDHDrillRigMetaData             Enhanced trigger TR_iutblDHDrillRigMetaData_UsingActiveLIBCode             New FK FK_tblDHDrillRigMetaData_tblSYSUnits_Rotation_Torque_UnitCode                   --tblDHEvents             New trigger TR_iudtblDHEvents_Validated                   --tblDHGammaRaw             Enhanced trigger TR_iutblDHGammaRaw_Valid_Depth                   --tblDHGeophysics             New trigger TR_iudtblDHGeophysics_Validated             Updated Depth_From/Depth_To from DECIMAL(18,2) to DECIMAL(18,3)                   --tblDHGeophysics_DENS             New trigger TR_iudtblDHGeophysics_DENS_Validated                   --tblDHGeophysics_IP             New trigger TR_iudtblDHGeophysics_IP_Validated                   --tblDHGeophysics_RES             New trigger TR_iudtblDHGeophysics_RES_Validated                   --tblDHGeophysics_SGAMMASUS             New trigger TR_iudtblDHGeophysics_SGAMMASUS_Validated                   --tblDHGeophysics_SP             New trigger TR_iudtblDHGeophysics_SP_Validated                   --tblDHGeophysicsHeader             New trigger TR_iudtblDHGeophysicsHeader_Validated             Enhanced trigger TR_iutblDHGeophysicsHeader_UsingActiveLIBCode             Updated Depth_From/Depth_To from DECIMAL(18,2) to DECIMAL(18,3)                   --tblDHGeophysicsPT             New trigger TR_iudtblDHGeophysicsPT_Validated             Updated Depth from DECIMAL(18,2) to DECIMAL(18,3)                   --tblDHGeotech             New trigger TR_iudtblDHGeotech_Validated                   --tblDHGeotechRMR             Changed Relative_Block_Size from computed column to a standard column             New trigger TR_iutblDHGeotechRMR_Relative_Block_Size             New column OJ_Count/CJ_Count/Structure_Int/Structure_Spacing/Core_Quality/Solid_Recovery_Interval/Solid_Recovery_pct/Lith_Code/Matrix_Interval/Matrix_Type/Persistence/IRS_Strong/IRS_Weak/RC_Weak_pct/IRS_Rating/IRS_Mpa/Wall_Contact_Type/Q_Jn/Q_Jr/Q_Ja/Q_Jw/Q_SRF/Total_Core_Recovery/RQD_Deere_pct/Struct_Freq_Per_Unit_Adj/Weath_Code_Strong/Weath_Code_Weak             New trigger TR_iutblDHGeotechRMR_Structure_Int             New trigger TR_iutblDHGeotechRMR_Wall_Contact_Type_Q_Ja             New trigger TR_iudtblDHGeotechRMR_Validated             Enhanced trigger TR_iutblDHGeotechRMR_UsingActiveLIBCode             Enhanced trigger TR_iutblDHGeotechRMR_Recovery_pct_RQD_pct             New trigger TR_iutblDHGeotechRMR_Recovery_pct_RQD_pct_Solid_Recovery_pct                   --tblDHGeotechRQD             New trigger TR_iudtblDHGeotechRQD_Validated             Enhanced trigger TR_iutblDHGeotechRQD_RQD_pct                   --tblDHGrouting             New trigger TR_iudtblDHGrouting_Validated                   --tblDHLithology             New trigger TR_iudtblDHLithology_Validated                   --tblDHMagSus             New trigger TR_iudtblDHMagSus_Validated             Enhanced trigger TR_iutblDHMagSus_AveReading                   --tblDHMagSusPT             New trigger TR_iudtblDHMagSusPT_Validated             Enhanced trigger TR_iutblDHMagSusPT_AveReading             --tblDHMetaData             New trigger TR_iudtblDHMetaData_Validated             Enhanced trigger TR_iutblDHMetaData_UsingActiveLIBCode                   --tblDHMetSamp             New columns Validated/Validated_Date/Validated_By             New trigger TR_iutblDHMetSamp_Validated             Enhanced trigger TR_iutblDHMetSamp_UsingActiveLIBCode             Enhanced trigger TR_iutblDHMetSamp_Interval_Overlap             Enhanced trigger TR_utblDHMetSamp_DataSet_SampleID                   --tblDHMetSampQC             New columns Validated/Validated_Date/Validated_By             New trigger TR_iutblDHMetSampQC_Validated             Enhanced trigger TR_iutblDHMetSampQC_UsingActiveLIBCode                   --tblDHModelComposite             New columns Validated/Validated_Date/Validated_By             New trigger TR_iutblDHModelComposite_Validated             Enhanced trigger TR_iutblDHModelComposite_UsingActiveLIBCode             --tblDHOxidation             New trigger TR_iudtblDHOxidation_Validated                   --tblDHPhoto             New trigger TR_iudtblDHPhoto_Validated                   --tblDHRadiometrics             New trigger TR_iudtblDHRadiometrics_Validated             New column Priority and added as part of PK             Enhanced trigger TR_iutblDHRadiometrics_Interval_Overlap             Enhanced trigger TR_utblDHRadiometrics             Enhanced trigger TR_iutblDHRadiometrics_UsingActiveLIBCode             Updated column Depth_From/To to DECIMAL(18,3) from DECIMAL(18,2)                   --tblDHSamp             New columns Sample_Group/Sample_From/Sample_Origin                   --tblDHSamp             New trigger TR_iudtblDHSamp_Validated             Enhanced trigger TR_iutblDHSamp_Interval_Overlap             Enhanced trigger TR_utblDHSamp_DataSet_SampleID                   --tblDHSampQC             New trigger TR_iudtblDHSampQC_Validated                   --tblDHSampWater             New trigger TR_iudtblDHSampWater_Validated             Enhanced trigger TR_iutblDHSampWater_Interval_Overlap             Enhanced trigger TR_utblDHSampWater_DataSet_SampleID                   --tblDHSampWaterQC             New trigger TR_iudtblDHSampWaterQC_Validated                   --tblDHSpecGrav             New trigger TR_iudtblDHSpecGrav_Validated             Enhanced trigger TR_iutblDHSpecGrav_Interval_Overlap                   --tblDHStructure             New trigger TR_iudtblDHStructure_Validated                   --tblDHSulphides             New trigger TR_iudtblDHSulphides_Validated                   --tblDHSurv             New trigger TR_iudtblDHSurv_Validated             Enhanced trigger TR_iutblDHSurv_Valid_Depth             Enhanced trigger TR_iutblDHSurv_Deviation             Enhanced trigger TR_iutblDHStructure_Interval_Overlap                   --tblDHVeins             New trigger TR_iudtblDHVeins_Validated                   --tblDHWater             New trigger TR_iudtblDHWater_Validated                   --tblDHWeathering             New trigger TR_iudtblDHWeathering_Validated                   --tblLIBCoreQuality             New table                   --tblLIBGeotFFRating             New table                   --tblLIBGeotIRS             New table                   --tblLIBGeotIRSRating             New table                   --tblLIBGeotJa             New table                   --tblLIBGeotJn             New column Jn_Rating             New trigger TR_iutblDHGeotechRMR_Relative_Block_Size                   --tblLIBGeotJr             New table             --tblLIBGeotJr             New table                   --tblLIBGeotJw             New column Jw_Rating                   --tblLIBGeotMacroRoughness             New column Jr_Rating                   --tblLIBGeotMatrix             New table                   --tblLIBGeotMicroRoughness             New column Jr_Rating_Dry                   --tblLIBGeotPersistence             New table                   --tblLIBGeotSRF             New table                   --tblLIBLithCode             New columns Mean_IRS_MPa/Mean_IRS_MPa_All                   --tblLIBStandardSampSourceType             Added new base codes values                   --tblLIBStructFillTexture             New columns Ja_Rating_Thin/Ja_Rating_Med/Ja_Rating_Thick                   --tblLIBStructWallContactType             New table             --tblLIBStructWallRockCompetency             New column Ja_Rating                   --tblLSGeology             Enhanced trigger TR_iudtblLSGeology_Validated                   --tblLSMagSus             Enhanced trigger TR_iudtblLSMagSus_Validated                   --tblLSMapping             Enhanced trigger TR_iudtblLSMapping_Validated                   --tblLSMetaData             Enhanced trigger TR_iudtblLSMetaData_Validated             Enhanced trigger TR_iutblLSMetaData_UsingActiveLIBCode                   --tblLSMetSamp             New columns Validated/Validate_Date/Validate_By             New trigger TR_iutblLSMetSamp_Validated             Enhanced trigger TR_iutblLSMetSamp_UsingActiveLIBCode             Enhanced trigger TR_iutblLSMetSamp_Interval_Overlap             Enhanced trigger TR_utblLSMetSamp_DataSet_SampleID                   --tblLSMetSampQC             New columns Validated/Validate_Date/Validate_By             New trigger TR_iutblLSMetSampQC_Validated             Enhanced trigger TR_iutblLSMetSampQC_UsingActiveLIBCode                   --tblLSPhoto             Enhanced trigger TR_iudtblLSPhoto_Validated                   --tblLSSamp             Enhanced trigger TR_iudtblLSSamp_Validated             Enhanced trigger TR_iutblLSSamp_Interval_Overlap             Enhanced trigger TR_utblLSSamp_DataSet_SampleID                               --tblLSSampBulk             Enhanced trigger TR_utblLSSampBulk_DataSet_SampleID                   --tblLSSampQC             Enhanced trigger TR_iudtblLSSampQC_Validated                   --tblLSSampWater             Enhanced trigger TR_iudtblLSSampWater_Validated             Enhanced trigger TR_iutblLSSampWater_Interval_Overlap             Enhanced trigger TR_utblLSSampWater_DataSet_SampleID             --tblLSSampWaterQC             Enhanced trigger TR_iudtblLSSampWaterQC_Validated                   --tblLSSite             Enhanced trigger TR_iutblLSSite_Validated                   --tblLSSiteHistory             New trigger TR_iudtblLSSiteHistory_Validated                   -tblLSSurv             Enhanced trigger TR_iudtblLSSurv_Validated             Enhanced trigger TR_iutblLSSurv_Valid_Length                   --tblLSWater             Enhanced trigger TR_iudtblLSWater_Validated                   --tblPetrology             Enhanced trigger TR_utblPetrology_DataSet_SampleID                               --tblPTGeology             Enhanced trigger TR_iudtblPTGeology_Validated                   --tblPTMagSus             Enhanced trigger TR_iudtblPTMagSus_Validated                   --tblPTMapping             Enhanced trigger TR_iudtblPTMapping_Validated                   --tblPTMetSamp             New columns Validated/Validated_Date/Validated_By             New trigger TR_iutblPTMetSamp_Validated             Enhanced trigger TR_iutblPTMetSamp_UsingActiveLIBCode             Enhanced trigger TR_utblPTMetSamp_DataSet_SampleID                   --tblPTMetSampQC             New columns Validated/Validated_Date/Validated_By             New trigger TR_iutblPTMetSampQC_Validated             Enhanced trigger TR_iutblPTMetSampQC_UsingActiveLIBCode                   --tblPTPhoto             Enhanced trigger TR_iudtblPTPhoto_Validated                   --tblPTSamp             Enhanced trigger TR_iudtblPTSamp_Validated             Enhanced trigger TR_utblPTSamp_DataSet_SampleID                   --tblPTSampQC             Enhanced trigger TR_iudtblPTSampQC_Validated                   --tblPTSampWater             Enhanced trigger TR_iudtblPTSampWater_Validated             Enhanced trigger TR_utblPTSampWater_DataSet_SampleID                   --tblPTSampWaterQC             Enhanced trigger TR_iudtblPTSampWaterQC_Validated                   --tblPTSite             Enhanced trigger TR_iutblPTSite_Validated                   --tblPTSiteHistory             New trigger TR_iudtblPTSiteHistory_Validated                   --tblPTWater             Enhanced trigger TR_iudtblPTWater_Validated                   --tblRehabDH             New columns Validated/Validated_Date/Validated_By             New trigger TR_iutblRehabDH_Validated             Enhanced trigger TR_iutblRehabDH_UsingActiveLIBCode                   --tblRehabLS             New columns Validated/Validated_Date/Validated_By             New trigger TR_iutblRehabLS_Validated             Enhanced trigger TR_iutblRehabLS_UsingActiveLIBCode                   --tblRehabPT             New columns Validated/Validated_Date/Validated_By             New trigger TR_iutblRehabPT_Validated             Enhanced trigger TR_iutblRehabPT_UsingActiveLIBCode                   --tblStandardSamp             Enhanced trigger TR_iudtblStandardSamp_Validated                   --tblSYSAssDispatchGroupDetail             Enhanced trigger TR_iutblSYSAssDispatchGroupDetail_UsingActiveLIBCode                   --tblSYSAssMethodPriority             Added new element group codes                   --tblSYSExtSQLStatement             Updated standard extension SQL statement                   --tblSYSImportFlistFiles             Enhanced trigger TR_utblSYSImportFlistFiles                   --tblSYSImportLayoutFields             Enhanced trigger tblSYSImportLayoutFields                   --tblSYSImportSubst             Enhanced trigger TR_utblSYSImportSubst                   --tblSYSMergeTableAttributes             Enhanced trigger TR_utblSYSMergeTableAttributes                   --tblSYSMergeTableProcessStack             Enhanced trigger TR_utblSYSMergeTableProcessStack                   --tblSYSNormAttribute             Added atrribute setting for S_pct                   --tblSYSNormAttributeDef             Added atrribute setting for S_pct                   --tblSYSQCReference             Enhanced trigger TR_utblSYSQCReference                   --tblSYSQCReferenceValue             Enhanced trigger TR_utblSYSQCReferenceValue                   --tblSYSXRFIncomingData             Enhanced trigger TR_iutblSYSXRFIncomingData_AssayResult_SysAssayStatus                   --tblSYSSurpacStyles             New default constraint for column Code                   --tblSYSSurpacTranslation             Updated column Num_Equiv definition to DECIMAL(18,9)                   --tblSYSXRFIncomingData             Enhanced trigger TR_iutblSYSXRFIncomingData_AssayResult_SysAssayStatus                   --tblVWDHAssays             Enhanced view                   --tblVWDHAssaysQC             Enhanced view             --tblVWDHAssaysWater             Enhanced view             --tblVWDHAssaysWaterQC             Enhanced view             --tblVWDHAuditView             Enhanced view             --tblVWDHCollarAttributes             Enhanced view             --tblVWDHGeotechRMR_Calc             Enhanced view             --tblVWDHGeotechRMRLogging             New view             --tblVWFSAssays             Enhanced view             --tblVWFSAssaysQC             Enhanced view             --tblVWFSAssaysWater             Enhanced view             --tblVWFSAssaysWaterQC             Enhanced view             --tblVWLSAssays             Enhanced view             --tblVWLSAssaysQC             Enhanced view             --tblVWLSAssaysWater             Enhanced view             --tblVWLSAssaysWaterQC             Enhanced view             --tblVWProdAssays             Enhanced view             --tblVWProdAssaysQC             Enhanced view             --tblVWProdSurveyTrucking             Enhanced view             --tblVWProdTruckingRpt             Enhanced view             --tblVWPTAssays             Enhanced view             --tblVWPTAssaysWater             Enhanced view             --tblVWStandardAssays             Enhanced view             --tblVWStandardAssaysQC             Enhanced view             --tblVWStandardAssaysWater             Enhanced view             --tblVWStandardAssaysWaterQC             Enhanced view             --tblVWSYSAssDispatchSampleStatus             Enhanced view             --tblXRFDHSamp             Enhanced trigger TR_iutblXRFDHSamp_Interval_Overlap             Enhanced trigger TR_utblXRFDHSamp_DataSet_SampleID                         --tblXRFResults             Enhanced trigger TR_utblXRFResults_AssayResultNum_UnitCode_LimitLower_sysAssayStatus_Element_Repeat_Preferred             --tblXRFSamp             Enhanced trigger TR_utblXRFSamp_DataSet_SampleID                         --tblXRFStandardSamp             Enhanced trigger TR_utblXRFStandardSamp_DataSet_SampleID                   --Enhanced following stored procedures:             usp_AdminDataShedTableAssigned             usp_DataStructOrientDriver             usp_ProcessCombineMultipleTableColumns             usp_ProcessXRFStandardsInComingData       ************************************* Following changes are for v4.6.3 SP1 and model specific: ************************************* For Production model       --tblFSGeology             Enhanced trigger TR_iudtblFSGeology_Validated                   --tblFSMagSus             Enhanced trigger TR_iudtblFSMagSus_Validated                   --tblFSMapping             Enhanced trigger TR_iudtblFSMapping_Validated                   --tblFSMetaData             Enahnced trigger TR_iudtblFSMetaData_Validated             Enhanced trigger TR_iutblFSMetaData_UsingActiveLIBCode                               --tblFSMetSamp             New column Validated/Validated_Date/Validated_By             New trigger TR_iutblFSMetSamp_Validated             Enhanced trigger TR_iutblFSMetSamp_UsingActiveLIBCode             Enhanced trigger TR_iutblFSMetSamp_Interval_Overlap             Enhanced trigger TR_utblFSMetSamp_DataSet_SampleID             --tblFSMetSampQC             New column Validated/Validated_Date/Validated_By             New trigger TR_iutblFSMetSampQC_Validated             Enhanced trigger TR_iutblFSMetSampQC_UsingActiveLIBCode                   --tblFSPhoto             Enhanced trigger TR_iudtblFSPhoto_Validated                   --tblFSSamp             Enhanced trigger TR_iudtblFSSamp_Validated             Enhanced trigger TR_iutblFSSamp_Interval_Overlap             Enhanced trigger TR_utblFSSamp_DataSet_SampleID                   --tblFSSampQC             Enhanced trigger TR_iudtblFSSampQC_Validated                   --tblFSSampWater             Enhanced trigger TR_iudtblFSSampWater_Validated             Enhanced trigger TR_iutblFSSampWater_Interval_Overlap             Enhanced trigger TR_utblFSSampWater_DataSet_SampleID             --tblFSSampWaterQC             Enhanced trigger TR_iudtblFSSampWaterQC_Validated                   --tblFSSite             Enhanced trigger TR_iutblFSSite_Validated                   --tblFSSiteHistory             New trigger TR_iudtblFSSiteHistory_Validated                   --tblFSSurv             Enhanced trigger TR_iudtblFSSurv_Validated                   --tblFSWater             Enhanced trigger TR_iudtblFSWater_Validated                   --tblProdDailyTrucking             Enhanced trigger TR_iutblProdDailyTrucking_UsingActiveLIBCode                   --tblProdMaterialMovement             Enhanced trigger TR_iutblProdMaterialMovement_UsingActiveLIBCode                   --tblProdSamp             Enhanced trigger TR_utblProdSamp_LocationID_SampleID     For Diamond model       --New table tblDeposit             --tblDHAlteration             New column Alt1/5_Colour/Alt_Distribution/Alt_Rock_Strength             New trigger TR_iutblDHAlteration_UsingActiveLIBCode_Diamond             New trigger TR_iudtblDHAlteration_Validated                   --New table tblDHCaliper             --New table tblDHCaliperHeader             --tblDHCoreRecoveryRun             New columns Solid_Recovery_Interval/Solid_Recovery_pct                   --tblDHCountryRockXenoliths             Restructured table                   --tblDHDilution             Restructured table                   --tblDHGeology             Restructured table                   --tblDHGeologyInterpLog             New table                   --tblDHGeologySubUnits             New table                   --tblGeophysAnomaly             Renamed column AnomalyID to Anomaly_ID             Renamed column SurveyID to Survey_ID             Updated default value for Load_Date to mach column definition             Enhanced trigger TR_utblGeophysAnomaly                               --tblGeophysSurvey             Renamed column SurveyID to Survey_ID             Renamed column Start_Date (or StartDAte) to Date_Started             Renamed column End_Date (or EndDate) to Date_Completed             Renamed column SurveyMethod to Survey_Method             Renamed column Equipment to Instrument and changed data type to be NVARCHAR(25)             Updated default value for Load_Date to mach column definition             Enhanced trigger TR_iutblGeophysSurvey_UsingActiveLIBCode             New trigger TR_iutblGeophysSurvey_UsingActiveLIBCode             Enhanced trigger TR_utblGeophysSurvey         --tblDHGeotechLoadStrength             New columns Specimen_Height/Height_Unit/Diameter_Height_Ratio/Area/Area_Unit/Mass_Sat/Volme/Volume_UnitCode             New trigger TR_iudtblDHGeotechLoadStrength_Validated                   --tblDHGroundmass             New table                   --tblDHKimberlite             New table                   --tblDHMantleXenoliths             Restructured table                   --tblDHMineralCounts             New table                   --tblDHMinerals             Restructured table                   --tblDHOlivine             New table                   --tblDHSamp             New columns Sample_Group/Sample_From/Sample_Origin             New trigger TR_iutblDHSamp_UsingActiveLIBCode_Diamond         --tblDHStructureOrient             New column Structure_Confidence             New trigger TR_iutblDHStructureOrient_UsingActiveLIBCode_Diamond             New trigger TR_iudtblDHStructureOrient_Validated                   --tblDMDBackGroundMineral             Updated default value for Load_Date to mach column definition                   --tblDMDDiamond             Updated default value for Load_Date to mach column definition             Renamed column DiamondNo to Diamond_No             Renamed column SizeFraction_mm to Size_Fraction             Renamed column DimX_mm to DimX             Renamed column DimY_mm to DimY             Renamed column DimZ_mm to DimZ             New column Dim_UnitCode             Renamed column Form to Diamond_Form             Renamed column EtchPits to Etch_Pits             Renamed column StepLayering to Step_Layering             Renamed column GlidePlanes to Glide_Planes             Updated default value for Load_Date to mach column definition                   --tblDMDDiamondGrade             Updated default value for Load_Date to mach column definition             Added check constraint for column Value_Date             --tblDMDDiamondRecovery             Updated default value for Load_Date to mach column definition                   --tblDMDIndicator             Renamed column IndicatorCode to Indicator_Code             Renamed column SizeFraction_mm to Size_Fraction             Renamed column AmountGrains to Amount_Grains             Renamed column CountOrEstimate to Count_Or_Estimate             Renamed column SourceDistance to Source_Distance             Renamed column AmountSubmitted to Amount_Submitted             Updated default value for Load_Date to mach column definition                   --tblDMDIndicatorDesc             Updated default value for Load_Date to mach column definition             Renamed column IndicatorCode to Indicator_Code             Renamed column SizeFraction_mm to Size_Fraction             Renamed column DescCode to Desc_Code             Renamed column DescValue to Desc_Value                   --tblDMDMineralGrain             Updated default value for Load_Date to mach column definition             Renamed column GrainNo to Grain_No             Renamed column SizeFraction_mm to Size_Fraction             Renamed column MineralAsObserved to Mineral_As_Observed             Renamed column MineralAsProbed to Mineral_As_Probed                   --tblDMDMineralGrainChemistry             Renamed column GrainNo to Grain_No             Renamed column AnalysisPosition to Analysis_Position             Renamed column ResultCategory to Result_Category             Renamed column Units to UnitCode             Updated default value for Load_Date to mach column definition                   --tblDMDSamp             New check constraints for column Processing_Completed and Observation_Completed             Updated default value for Load_Date to mach column definition                   --tblDMDSampObservation             New column Observed_Time_UnitCode             Renamed column Observed_Time_Hrs to Observed_Time             Renamed column Weight_UnitCode to Weight_To_Observation_UnitCode             Updated default value for Load_Date to mach column definition                   --tblDMDSampObservationWeights             New column Weight_UnitCode             Renamed column FractionWeight_gms to Fraction_Weight             Renamed column SizeFraction_mm to Size_Fraction             Renamed column FractionWeightObserved_gms to Fraction_Weight_Observed             Renamed column Wight_UnitCode to Fraction_Weight_UnitCode             Updated default value for Load_Date to mach column definition             --tblDMDSampProcessing             Renamed column ProcessOrder to Process_Order             Renamed column ProcessFraction to Process_Fraction             Renamed column ParentProcess to Parent_Process             New check contratins for columns Weight_Processed/Weight/Date_Commenced/Date_Completed             Updated default value for Load_Date to mach column definition             --tblLIBAbundance             New table                   --tblLIBAccuracyStatus             New table                   --tblLIBAltDistribution             New table                   --tblLIBAutolithCode             New table                   --tblLIBCaliperConfig             New table                   --tblLIBCrystalForm             New table                   --tblLIBCrystalShape             New table                               --tblLIBDilStyle             Removed table                   --tblLIBDMDAnalysisMethod             Renamed tblLIBDMDAnalysisMethod to tblLIBSampleAnalysisMethod                   --tblLIBDominCode             New table                   --tblLIBGammaSonde             Enhanced trigger TR_utblLIBGammaSonde                   --tblLIBGeophysMethod             Renamed table tblLIBGeophysMethod to tblLIBGeophysSurveyMethod                   --tblLIBInterpBasis             New table                   --tblLIBInterpLithCode             New table                   --tblLIBInterpMethod             New table                   --tblLIBKimberliteFacies             New table                   --tblLIBLithContactCode             New table                   --tblLIBLithContactCondition             New table                   --tblLIBLithContactRelation             New table                   --tblLIBLithContactShape             New table                   --tblLIBLithContrast             New table                   --tblLIBLithCrystallinity             New table                   --tblLIBLithFabric             New table                   --tblLIBLithGrainOri             New table                   --tblLIBLithGrainPacking             New table                   --tblLIBLithHabit             New table                   --tblLIBLithHabitat             New table                   --tblLIBLithPreservation             New table                   --tblLIBLithSorting             New table                   --tblLIBLithState             New table                   --tblLIBLithSubUnit             New table                   --tblLIBLithSupport             New table                   --tblLIBMagmaCoherence             New table                   --tblLIBMatrixAppearance             New table                   --tblLIBMatrixType             New table                   --tblLIBMinDistribution             New table                   --tblLIBMinGroup             New table                   --tblLIBSampleForm             New table                   --tblLIBSampleGroup             New table                   --tblLIBSampleOrigin             New table                               --tblLIBStructConfidence             New table                   --tblLIBXenAlt             Removed table                   --tblLIBXenCode             Removed table                   --tblLIBLithRoundness             New table             --tblLSSite             New column Company             New trigger TR_iutblLSSite_UsingActiveLIBCode_Diamond                   --tblPTSamp             New trigger TR_iutblPTSamp_UsingActiveLIBCode_Diamond             For Coal Model       --tblDHSeam             Enhanced trigger TR_iutblDHSeam_DataSet_Hole_ID_Depth_From_Depth_To_Priority_Interval_Overlap             Enhanced trigger TR_udtblDHSeam_Depth_From_Depth_To_Seam_Class_Seam_Thickness
v4.6.3 ************************************* Following changes are for v4.6.3 ALL models *************************************       --tblAssay             Removed trigger TR_utblAssay_AssayResultNum_UnitCode_LimitLower_sysAssayStatus_Element_Repeat_Preferred             New trigger TR_utblAssay_AssayResultNum_UnitCode_LimitLower_sysAssayStatus_Element             New trigger TR_iudtblAssay_Validated             New index IX_tblAssay_BatchNo_DataSet_SampleID_Element_Preferred             Removed index IX_tblAssay_DataSet_SampleID_GenericMethod_Element_Repeat_Preferred             Removed index IX_tblAssay_Element         --tblAssayFlatWater             New table                   --tblAssayWater             New table                               --tblCATPlanIndex             Removed index IX_tblCATPlanIndex_DataSet                   --tblCATReportIndex             Removed index IX_tblCATReportIndex_DataSet                   --tblContractActivityLog             Changed Comments column length from 2000 to 4000             New FK FK_tblContractActivityLog_tblLIBCompany_Client                   --tblContractActivityLogDetails             New columns Line_ID, Site_ID                   --tblContractActivityLogLSMetres             New table                   --tblContractDetails             New columns Depth_From,Depth_To                   --tblDHAlteration             New trigger TR_iutblDHAlteration_Intensity                   --tblDHAudit             New columns:                   DHAlt_MaxInterval                   DHAlt_IntervalCount                   DHLith_MaxInterval                   DHLith_IntervalCount                   DHMin_MaxInterval                   DHMin_IntervalCount                   DHVein_MaxInterval                   DHVein_IntervalCount                   Load_Date                   Loaded_By                   Modified_Date                   Modified_By                         --tblDHColl             Changed Parent_Hole_ID column length from 20 to 100             Changed Historic_Hole_ID length from 20 to 100             Removed index IX_tblDHColl_DataSet             New column POW_ID,LL_Survey_Company,Local_Survey_Company,NAT_Survey_Company,Orig_Survey_Company                   --tblDHCollHistory             Removed FK FK_tblDHCollHistory_tblDHColl_DataSet_Hole_ID             New column Is_Deleted,Survey_Company                   --tblDHCollPlanned             Removed index IX_tblDHCollPlanned_DataSet                   --tblDHCoreRecoveryRun             New column Core_Block_From,Core_Block_To,Core_Block_Interval,Core_Loss_Gain_Interval             Enhanced trigger TR_iutblDHCoreRecoveryRun_RQDPct_RecoveryPct                   --tblDHGeology             Enhanced CK_tblDHGeology_Alt2_Code             Enhanced CK_tblDHGeology_Min2_Code             Enhanced CK_tblDHGeology_Vein2_Code             Enhanced CK_tblDHGeology_Lith1_pct             Enhanced CK_tblDHGeology_Lith2_pct             Enhanced CK_tblDHGeology_Min1_pct             Enhanced CK_tblDHGeology_Min2_pct             Enhanced CK_tblDHGeology_Vein1_pct             Enhanced CK_tblDHGeology_Vein2_pct             New CK CK_tblDHGeology_Lith1_Colour1_Lith1_Colour2             New CK CK_tblDHGeology_Lith2_Colour1_Lith2_Colour2             New CK CK_tblDHGeology_Lith1_pct_Lith2_pct             New CK CK_tblDHGeology_Min1_pct_Min2_pct             New CK CK_tblDHGeology_Vein1_pct_Vein2_pct             New trigger TR_iutblDHGeology_Intensity             New columns Sulph1_Code, Sulph1_pct, Sulph1_Style, Sulph2_Code, Sulph2_pct, Sulph2_Style                   --tblDHGeophysics_DENS             Changed Depth from DECIMAL(18,2) to DECIMAL(18,3)                   --tblDHGeophysics_IP             Changed Depth from DECIMAL(18,2) to DECIMAL(18,3)                   --tblDHGeophysics_RES             Changed Depth from DECIMAL(18,2) to DECIMAL(18,3)                   --tblDHGeophysics_SGAMMASUS             Changed Depth from DECIMAL(18,2) to DECIMAL(18,3)         --tblDHGeophysics_SP             Changed Depth from DECIMAL(18,2) to DECIMAL(18,3)         --tblDHGeotech             New trigger TR_iutblDHGeotech_Intensity             Changed Dip_Direction from DECIMAL(18,3) to DECIMAL(18,4)             New CK CK_tblDHGeotech_Fill_Min1_Fill_Min2             --tblDHGeotechRMR             Enhanced trigger TR_iutblDHGeotechRMR_Recovery_pct_RQD_pct             New CK CK_tblDHGeotechRMR_Fill_Min1_Fill_Min2             Removed column Longest_Piece_Length_UnitCode             Enhanced Relative_Block_Size calculation formula             --tblDHGeotechRQD             Enhanced trigger TR_iutblDHGeotechRQD_RQD_pct                   --tblDHIntercepts             Modified columns Grade, CoElement1Grade, CoElement2Grade, CoElement3Grade, CoElement4Grade, CoElement5Grade from DECIMAL(18,3) TO DECIMAL(18,9)                   --tblDHLithology             New CK CK_tblDHLithology_Lith1_Colour1_Lith1_Colour2             New CK CK_tblDHLithology_Lith2_Colour1_Lith2_Colour2             New CK CK_tblDHLithology_Lith1_pct_Lith2_pct             Enhanced CK_tblDHLithology_Lith1_pct definition from >=0 to >0             Enhanced CK_tblDHLithology_Lith2_pct definition from >=0 to >0                   --tblDHMagSus             Dropped index IX_tblDHMagSus_DataSet_Hole_ID             New CK CK_tblDHMagSus_Reading1_SI_Reading2_SI_Reading3_SI                   --tblDHMagSusPT             Dropped index IX_tblDHMagSusPT_DataSet_Hole_ID             New CK CK_tblDHMagSusPT_Reading1_SI_Reading2_SI_Reading3_SI                   --tblDHMetaData             Dropped index IX_tblDHMetaData_DataSet_Hole_ID                   --tblDHMetSamp             New trigger TR_utblDHMetSamp_Hole_ID_Depth_From_Depth_To             Enhanced trigger TR_dtblDHMetSamp             Dropped index IX_tblDHMetSamp_DataSet             Dropped index IX_tblDHMetSamp_DataSet_Hole_ID                   --tblDHMetSampQC             Enhanced trigger TR_iutblDHMetSampQC_Orig_SampleID_HasDuplicate             Enhanced trigger TR_iutblDHMetSampQC_Orig_SampleID             Enhanced trigger TR_iutblDHMetSampQC_DataSet_Orig_SampleID_SampleID             Enhanced trigger TR_dtblDHMetSampQC             Dropped index IX_tblDHMetSampQC_DataSet_Hole_ID                   --tblDHMinerals             Dropped index IX_tblDHMinerals_DataSet             Dropped index IX_tblDHMinerals_DataSet_Hole_ID             New CK CK_tblDHMinerals_Min1_pct_Min2_pct_Min3_pct_Min4_pct_Min5_pct             Enhanced CK_tblDHMinerals_Min1_pct definition from >=0 to >0             Enhanced CK_tblDHMinerals_Min2_pct definition from >=0 to >0             Enhanced CK_tblDHMinerals_Min3_pct definition from >=0 to >0             Enhanced Changed CK_tblDHMinerals_Min4_pct definition from >=0 to >0             Enhanced CK_tblDHMinerals_Min5_pct definition from >=0 to >0                   --tblDHOxidation             New trigger TR_iutblDHOxidation_Intensity                   --tblDHRadiometrics             New CK CK_tblDHRadiometrics_Reading1_Reading2_Reading3                   --tblDHSamp             New trigger TR_utblDHSamp_Hole_ID_Depth_From_Depth_To             Enhanced trigger TR_dtblDHSamp             Dropped index IX_tblDHSamp_DataSet             Dropped index IX_tblDHSamp_DataSet_Hole_ID                   --tblDHSampQC             Enhanced trigger TR_iutblDHSampQC_Orig_SampleID_HasDuplicate             Enhanced trigger TR_iutblDHSampQC_Orig_SampleID             Enhanced trigger TR_iutblDHSampQC_DataSet_Orig_SampleID_SampleID             Enhanced trigger TR_dtblDHSampQC             Dropped index IX_tblDHSampQC_DataSet_Hole_ID                   --tblDHSampWater             New table                   --tblDHSampWaterQC             New table                   --tblDHSpecGrav             Dropped index IX_tblDHSpecGrav_DataSet             Dropped index IX_tblDHSpecGrav_DataSet_Hole_ID             New trigger TR_iutblDHSpecGrav_UsingActiveLIBCode                   --tblDHStructure             Removed FK_tblDHStructure_tblLIBValidation_Validation             New column Validated, Validated_Date, Validated_By             Renamed column Validation (replaced by Validated)             New trigger TR_iutblDHStructure_Intensity                   --tblDHStructureOrient             Enhanced trigger TR_iutblDHStructureOrient_Alpha_Beta_Gamma_Calculate             New trigger TR_iutblDHStructureOrient_Intensity             Change column Dip_Direction from DECIMAL(18,3) to DECIMAL(18,4)             Change column Alpha/Beta/Gama/LCA from DECIMAL(18,3) to DECIMAL(18,4)             New CK CK_tblDHStructureOrient_Fill_Min1_Fill_Min2                   --tblDHSulphides             New table                   --tblDHSurv             New trigger TR_iudtblDHSurv_Priority_Recalculate             Enhanced trigger TR_iudtblDHSurv_Dip_MAG_Azimuth_Depth_Priority_Calculate             Enhanced trigger TR_iutblDHSurv_Deviation             Dropped index IX_tblDHSurv_DataSet             Dropped index IX_tblDHSurv_DataSet_Hole_ID             New column MagField_Reading, MagField_Reading_UnitCode,Temp, Temp_UnitCode                   --tblDHVeins             New CK CK_tblDHVeins_Vein1_pct_Vein2_pct             Enhanced CK_tblDHVeins_Vein1_pct definition from >=0 to >0             Enhanced CK_tblDHVeins_Vein2_pct definition from >=0 to >0                   --tblDHWater             New column Water_Flow_UnitCode             Change column Measured_Date to NOT NULL and added as part of PK                   --tblDHWeathering             New trigger TR_iutblDHWeathering_Intensity                   --tblLeases             Changed data type from NVARCHAR(50) to Date/Time for column Start_Date, Start_Time, End_Date, End_Time, Grant_Date, Grant_Time                   --tblLIBCasingSize             New column Casing_Diameter_UnitCode                   --tblLIBIntensity             New column Alteration, Oxidation, Structure, Plane, Weathering                   --tblLIBMachineryCategory             New record for RIG                   --tblLIBMagSusFactor             Enhanced trigger TR_iutblLIBMagSusFactor_Multiplication_Factor                   --tblLIBMinCode             New column Is_Sulphide                   --tblLSGeology             Enhanced CK CK_tblLSGeology_Alt2_Code             Enhanced CK CK_tblLSGeology_Min2_Code             Enhanced CK CK_tblLSGeology_Vein2_Code             Enhanced CK CK_tblLSGeology_Lith1_pct             Enhanced CK CK_tblLSGeology_Lith2_pct             Enhanced CK CK_tblLSGeology_Min1_pct             Enhanced CK CK_tblLSGeology_Min2_pct             Enhanced CK CK_tblLSGeology_Vein1_pct             Enhanced CK CK_tblLSGeology_Vein2_pct             New CK CK_tblLSGeology_Lith1_Colour1_Lith1_Colour2             New CK CK_tblLSGeology_Lith2_Colour1_Lith2_Colour2             New CK_tblLSGeology_Lith1_pct_Lith2_pct             New CK_tblLSGeology_Min1_pct_Min2_pct             New CK_tblLSGeology_Vein1_pct_Vein2_pct             New trigger TR_iutblLSGeology_Intensity             New trigger TR_iudtblLSGeology_Validated             New columns Sulph1_Code, Sulph1_pct, Sulph1_Style, Sulph2_Code, Sulph2_pct, Sulph2_Style             --tblLSMagSus             New CK CK_tblLSMagSus_Reading1_SI_Reading2_SI_Reading3_SI             New trigger TR_iudtblLSMagSus_Validated                   --tblLSMapping             Removed duplicate FK FK_tblLSMapping_tblSYSDataSet_DataSet             Removed column Location             Change column Dip_Direction from DECIMAL(18,3) to DECIMAL(18,4)             New trigger TR_iudtblLSMapping_Validated                   --tblLSMetaData             New trigger TR_iudtblLSMetaData_Validated                   --tblLSMetSamp             New trigger TR_utblLSMetSamp_Line_ID_Site_ID_Length_From_Length_To             New trigger TR_iudtblLSMetSamp_Validated             Enhanced trigger TR_dtblLSMetSamp                   --tblLSMetSampQC             Enhanced trigger TR_iutblLSMetSampQC_HasDuplicate             Enhanced trigger TR_iutblLSMetSampQC_Orig_SampleID             Enhanced trigger TR_iutblLSMetSampQC_DataSet_Orig_SampleID_SampleID             Enhanced trigger TR_dtblLSMetSampQC             New trigger TR_iudtblLSMetSampQC_Validated                   --tblLSPhoto             New trigger TR_iudtblLSPhoto_Validated                   --tblLSSamp             New trigger TR_utblLSSamp_Line_ID_Site_ID_Length_From_Length_To             New trigger TR_iudtblLSSamp_Validated             Enhanced trigger TR_dtblLSSamp             Dropped index IX_tblLSSamp_DataSet             Dropped index IX_tblLSSamp_DataSet_Site_ID_Line_ID                   --tblLSSampQC             Enhanced trigger TR_iutblLSSampQC_Orig_SampleID_HasDuplicate             Enhanced trigger TR_iutblLSSampQC_Orig_SampleID             Enhanced trigger TR_iutblLSSampQC_DataSet_Orig_SampleID_SampleID             Enhanced trigger TR_dtblLSSampQC             Removed trigger TR_utblLSSampQC_DataSet_Orig_SampleID_SampleID             New trigger TR_iudtblLSSampQC_Validated             Dropped index IX_tblLSSampQC_DataSet_Site_ID_Line_ID                   --tblLSSampWater             New table                   --tblLSSampWaterQC             New table                   --tblLSSite             Enhanced trigger TR_utblLSSite_Orig_Grid_Audit             New trigger TR_itblLSSite_Rehab             New trigger TR_iutblLSSite_Validated             Dropped index IX_tblLSSite_DataSet             New column POW_ID, LL_Survey_Company, Local_Survey_Company, NAT_Survey_Company, Orig_Survey_Company                   --tblLSSiteHistory             Removed FK FK_tblLSSiteHistory_tblLSSite_DataSet_Line_ID_Site_ID             New column Is_Deleted, Survey_Company         --tblLSSurv             Dropped index IX_tblLSSurv_DataSet             New column MagField_Reading, MagField_Reading_UnitCode, Temp, Temp_UnitCode             New trigger TR_iudtblLSSurv_Validated                   --tblLSWater             New column Water_Flow_UnitCode             Change column Measured_Date to NOT NULL and added as part of PK             New trigger TR_iudtblLSWater_Validated                   --tblMeetings             New trigger TR_iutblMeetings_UsingActiveLIBCode                   --tblPetrology             Dropped index IX_tblPetrology_DataSet             Enhanced CK CK_tblPetrology_Min1_pct             Enhanced CK CK_tblPetrology_Min2_pct             Enhanced CK CK_tblPetrology_Min3_pct             Enhanced CK CK_tblPetrology_Min4_pct             Enhanced CK CK_tblPetrology_Min5_pct             Enhanced CK CK_tblPetrology_Min6_pct             Enhanced CK CK_tblPetrology_Min7_pct             Enhanced CK CK_tblPetrology_Min8_pct             Enhanced CK CK_tblPetrology_Min9_pct             Enhanced CK CK_tblPetrology_Min10_pct             --tblPTGeology             New column Depth, Sulph1_Code, Sulph1_pct, Sulph1_Style, Sulph2_Code, Sulph2_pct, Sulph2_Style                   --tblPTSamp             New column Depth                   --tblPTSampWater             New table                   --tblPTSampWaterQC             New table                   --tblPTSite             Enhanced trigger TR_utblPTSite_Orig_Grid_Audit             New trigger TR_iutblPTSite_Validated             New column POW_ID, LL_Survey_Company, Local_Survey_Company, NAT_Survey_Company, Orig_Survey_Company, Program_Type, Geologist, Validated, Validated_Date, Validated_By                   --tblPTSiteHistory             Removed FK FK_tblPTSiteHistory_tblPTSite_DataSet_Site_ID             New column Is_Deleted, Survey_Company             Enhanced trigger TR_utblPTSite_Orig_Grid_Audit                   --tblPTWater             New column Water_Flow_UnitCode             Change column Measured_Date to NOT NULL and added as part of PK             New trigger TR_iudtblPTWater_Validated                   --tblRehabDH             New column Data_Source             Enhanced CK CK_tblRehabDH_Date_RehabCompleted                   --tblRehabLS             New column Data_Source             Enhanced CK CK_tblRehabLS_Date_RehabCompleted                   --tblRehabPT             New column Data_Source             Enhanced CK CK_tblRehabPT_Date_RehabCompleted                   --tblStandardSamp             New column Sampled_By, Depth             Enhanced trigger TR_dtblStandardSamp             Enhanced trigger TR_iutblStandardSamp_Source_ID             New trigger TR_iudtblStandardSamp_Validated             Dropped index IX_tblStandardSamp_DataSet                   --tblStandardSampQC             Enhanced trigger TR_iutblStandardSampQC_HasDuplicate             Enhanced trigger TR_iutblStandardSampQC_Orig_SampleID             Enhanced trigger TR_dtblStandardSampQC             New trigger TR_iudtblStandardSampQC_Validated                   --tblSYSAssDispatchGroupDetail             Change Data_Source length from 100 to 255                   --tblSYSAssElement             Removed element "M;" from the table             Enhanced trigger TR_utblSYSAssElement_SystemUnits                   --tblSYSAssLabElementAlias             Removed element "M;" from the table                   --tblSYSAssMethodPriority             Enhanced trigger TR_iutblSYSAssMethodPriority_Rerank_Method                   --tblSYSConfigRelation             Enhanced trigger TR_itblSYSConfigRelation                   --tblSYSConversionFactor             Changed ConversionFactor data type from DECIMAL(18,9) TO DECIMAL(18,10)             --tblSYSSRSCoordinateSystemTx             Changed data type from DECIMAL(18,7) to DECIMAL(38,18) for column Theta, SF, TrlX, TrlY, TrlZ                   --tblSYSXRFIncomingCalibration             New table                   --tblSYSXRFIncomingData             Changed ActionDate from DateTime to Date             Changed ActionTime from DateTime to Time             New column Elapsed_Time_Total, Live_Time_Total             Renamed column Res to Resolution                   --tblSYSXRFTemplateColumns             New table                   --tblVWDHAssays             Enhanced logic for performance                   --tblVWDHAssaysQC             Enhanced logic for performance         --tblVWDHAssaysWater             New view             --tblVWDHAssaysWaterQC             New view                   --tblVWLSAssays             Enhanced logic for performance                   --tblVWLSAssaysQC             Enhanced logic for performance         --tblVWLSAssaysWater             New view             --tblVWLSAssaysWaterQC             New view                   --tblVWLSLogging             New view                   --tblVWPTAssays             Enhanced logic for performance         --tblVWPTAssaysWater             New view                   --tblVWPTAssaysWaterQC             New view                   --tblVWPTLogging             Enhanced trigger TR_utblVWPTLogging                   --tblVWStandardAssays             Enhanced logic for performance             --tblVWStandardAssaysQC             Enhanced logic for performance                   --tblVWStandardAssaysWater             New view                   --tblVWStandardAssaysWaterQC             New view                   --tblVWXRFIncomingResults             Enhanced logic to reflect change to tblXRFSamp FK to tblPTSite                   --tblVWXRFResults             Enhanced logic to reflect change to tblXRFSamp FK to tblPTSite                   --tblXRFCalibration             New table                   --tblXRFDHGeology             New table                   --tblXRFDHSamp             Enhanced trigger TR_iutblXRFDHSamp_Sample_Type             Enhanced trigger TR_utblXRFDHSamp_Hole_ID_Depth_From_Depth_To             Enhanced trigger TR_dtblXRFDHSamp             Dropped index IX_tblXRFDHSamp_DataSet             Dropped index IX_tblXRFDHSamp_DataSet_Hole_ID                   --tblXRFDHSampQC             Enhanced trigger TR_iutblXRFDHSampQC_Sample_Type             Enhanced trigger TR_iutblXRFDHSampQC_Orig_SampleID_HasDuplicate             Renamed trigger TR_iutblXRFDHSampQC to TR_iutblXRFDHSampQC_Orig_SampleID and enhanced logic             Renamed trigger TR_utblXRFDHSampQC_DataSet_Orig_SampleID_SampleID to TR_iutblXRFDHSampQC_DataSet_Orig_SampleID_SampleID and enhanced logic             Enhanced trigger TR_dtblXRFDHSampQC             Dropped index IX_tblXRFDHSampQC_DataSet_Hole_ID                   --tblXRFGeology             New table                   --tblXRFResults             Dropped index IX_tblXRFResults_DataSet_SampleID_GenericMethod_Element_Repeat_Preferred             Dropped index IX_tblXRFResults_Element                   --tblXRFResultsHeader             New column Elapsed_Time_Total, Live_Time_Total             Renamed column Res to Resolution                   --tblXRFSamp             Enhanced trigger TR_iutblXRFSamp_Sample_Type             Enhanced trigger TR_dtblXRFSamp             Removed Orig/NAT/LL/Local columns and Map_Sheet,Lease_ID,Company,Prospect,Terrian,Slop_Dip,Geologist onto tblPTSite                   --tblXRFSampQC             Enhanced trigger TR_iutblXRFSampQC_Sample_Type             Enhanced trigger TR_dtblXRFSampQC             Renamed trigger TR_iutblXRFSampQC_Orig_SampleID to TR_iutblXRFSampQC_Orig_SampleID_HasDuplicate and enhanced logic             Renamed trigger TR_iutblXRFSampQC to TR_iutblXRFSampQC_Orig_SampleID and enhanced logic                   --tblXRFStandardSamp             Enhanced trigger TR_dtblXRFStandardSamp             Enhanced trigger TR_itblXRFStandardSamp             Dropped index IX_tblXRFStandardSamp_DataSet                   --tblXRFStandardSampQC             Renamed trigger TR_iutblXRFStandardSampQC_Orig_SampleID to TR_iutblXRFStandardSampQC_Orig_SampleID_HasDuplicate and enhanced logic             Renamed trigger TR_iutblXRFStandardSampQC to TR_iutblXRFStandardSampQC_Orig_SampleID and enhanced logic             Enhanced trigger TR_dtblXRFStandardSampQC             Enhanced trigger TR_iutblXRFStandardSampQC_UsingActiveLIBCode             --Added Load_Date/Loaded_By/Modified_Date/Modified_By to all base tables       --Changed Load_Date/Modified_Date on all base tables from DateTime to DatetimeOffset       --Utilise Is_Active field in LIB tables to only allow active codes to be used             New trigger on all tables where applicable TR_iu*_UsingActiveLIBCode       --Enhanced Alt/Lith/Min/Vein_pct check constraint on the following tables to be >0 and <=100             tblDHGeology             tblDHLithology             tblDHMinerals             tblDHVeins             tblFSGeology             tblLSGeology             tblPetrology             tblPTGeology       --Change LS table PK column order from Line_ID/Site_ID to Site_ID/Line_ID       --Enhanced DAL tables       --Enhanced Desurvey functions       --Enhanced udf_GetViewOrderByList       --Enhanced udf_OrientDipDirection       --New function utf_GetGenericAndOrigMethodBatchNo       --Enhanced usp_AdminShowTableRelationships       --New stored procedure usp_AdminTestViewsCanCompile       --Enhanced usp_DataAssayMergingProcess       --Enhanced usp_DataAssayRankingProcess       --Enhanced usp_DataTestAssayFlatPopulated       --Enhanced usp_DataXRFResultsMergingProcess       --Enhanced usp_GridTransformation       --Enhanced usp_ProcessCombineMultipleTableColumns       --Enhanced usp_ProcessInComingDataDriver       --Enhanced usp_ProcessStandardsInComingData       --Enhanced usp_TableReferenceLevel       --Enhanced uspIC_InterceptCalculator             ************************************* Following changes are for v4.6.3 and model specific: ************************************* For Production model       --tblFSGeology             Enhanced CK CK_tblFSGeology_Alt2_Code             Enhanced CK CK_tblFSGeology_Min2_Code             Enhanced CK CK_tblFSGeology_Vein2_Code             New CK CK_tblFSGeology_Lith1_Colour1_Lith1_Colour2             New CK CK_tblFSGeology_Lith2_Colour1_Lith2_Colour2             New CK_tblFSGeology_Lith1_pct_Lith2_pct             New CK_tblFSGeology_Min1_pct_Min2_pct             New CK_tblFSGeology_Vein1_pct_Vein2_pct             Changed CK_tblFSGeology_Lith1_pct definition from >=0 to >0             Changed CK_tblFSGeology_Lith2_pct definition from >=0 to >0             Changed CK_tblFSGeology_Min1_pct definition from >=0 to >0             Changed CK_tblFSGeology_Min2_pct definition from >=0 to >0             Changed CK_tblFSGeology_Vein1_pct definition from >=0 to >0             Changed CK_tblFSGeology_Vein2_pct definition from >=0 to >0             New trigger TR_iutblFSGeology_Intensity             New trigger TR_iudtblFSGeology_Validated             New columns Sulph1_Code, Sulph1_pct, Sulph1_Style, Sulph2_Code, Sulph2_pct, Sulph2_Style                   --tblFSMagSus             Dropped index IX_tblFSMagSus_DataSet_Site_ID_Line_ID             New CK CK_tblFSMagSus_Reading1_SI_Reading2_SI_Reading3_SI             New trigger TR_iudtblFSMagSus_Validated                   --tblFSMapping             Removed duplicate FK FK_tblFSMapping_tblSYSDataSet_DataSet             Removed column Location             Change column Dip_Direction from DECIMAL(18,3) to DECIMAL(18,4)             New trigger TR_iudtblFSMapping_Validated                   --tblFSMetaData             Dropped index IX_tblFSMetaData_DataSet_Site_ID_Line_ID             New trigger TR_iudtblFSMetaData_Validated                   --tblFSMetSamp             New trigger TR_utblFSMetSamp_Line_ID_Site_ID_Depth_From_Depth_To             New trigger TR_iudtblFSMetSamp_Validated             Enhanced trigger TR_dtblFSMetSamp             Change column Depth_From/Depth_To length from DECIMAL(18,3) TO DECIMAL(18,2)             --tblFSMetSampQC             Enhanced trigger TR_iutblFSMetSampQC_HasDuplicate             Enhanced trigger TR_iutblFSMetSampQC_Orig_SampleID             Enhanced trigger TR_dtblFSMetSampQC             New trigger TR_iutblFSMetSampQC_DataSet_Orig_SampleID_SampleID             New trigger TR_iudtblFSMetSampQC_Validated             Change column Depth_From/Depth_To length from DECIMAL(18,3) TO DECIMAL(18,2)                   --tblFSPhoto             New trigger TR_iudtblFSPhoto_Validated                   --tblFSSamp             New trigger TR_utblFSSamp_Line_ID_Site_ID_Depth_From_Depth_To             New trigger TR_iudtblFSSamp_Validated             Enhanced trigger TR_dtblFSSamp             Dropped index IX_tblFSSamp_DataSet             Dropped index IX_tblFSSamp_DataSet_Site_ID_Line_ID                   --tblFSSampQC             Enhanced trigger TR_iutblFSSampQC_Orig_SampleID_HasDuplicate             Enhanced trigger TR_iutblFSSampQC_Orig_SampleID             Enhanced trigger TR_iutblFSSampQC_DataSet_Orig_SampleID_SampleID             Enhanced trigger TR_dtblFSSampQC             New trigger TR_iudtblFSSampQC_Validated             Removed trigger TR_utblFSSampQC_DataSet_Orig_SampleID_SampleID             Dropped index IX_tblFSSampQC_DataSet_Site_ID_Line_ID                   --tblFSSampWater             New table                   --tblFSSampWaterQC             New table                   --tblFSSite             Enhanced trigger TR_utblFSSite_Orig_Grid_Audit             New trigger TR_iutblFSSite_Validated             Dropped index IX_tblFSSite_DataSet             New column POW_ID, LL_Survey_Company, Local_Survey_Company, NAT_Survey_Company, Orig_Survey_Company                   --tblFSSiteHistory             Removed FK FK_tblFSSiteHistory_tblFSSite_DataSet_Site_ID_Line_ID             New column Is_Deleted, Survey_Company                   --tblFSSurv             Dropped index IX_tblFSSurv_DataSet             New column MagField_Reading, MagField_Reading_UnitCode, Temp, Temp_UnitCode             New trigger TR_iudtblFSSurv_Validated                   --tblFSWater             New column Water_Flow_UnitCode             Change column Measured_Date to NOT NULL and added as part of PK             New trigger TR_iudtblFSWater_Validated         --tblProdBlasting             New trigger TR_iutblProdBlasting_UsingActiveLIBCode             Enhanced CK CK_tblProdBlasting_Dilution_pct                   --tblProdBlock             New column Insitu_SG, Blast_SG, Calc_Type_SG, Swell_Factor             Changed column SG to be computed column                   --tblProdBlockCommodities             New CK_tblProdBlockCommodities_Mined_Grade                   --tblProdBlockMonthlySummary             Enhanced CK CK_tblProdBlockMonthlySummary_Month_Start                   --tblProdBlockPlannedCommodities             New CK_tblProdBlockPlannedCommodities_Planned_Grade                   --tblProdBlockRegister             Removed trigger TR_iutblProdBlockRegister_RootParent_HKey             New trigger TR_iudtblProdBlockRegister_RootParent_HKey                   --tblProdBlockReserveCommodities             New CK_tblProdBlockReserveCommodities_Reserve_Grade             New DF_tblProdBlockReserveCommodities_Priority                   --tblProdBlockResource             Enhanced trigger TR_dtblProdBlockResource_BlockRegister                   --tblProdBlockResourceCommodities             New CK_tblProdBlockResourceCommodities_Resource_Grade             New DF_tblProdBlockResourceCommodities_Priority                   --tblProdBottleRollResults             Enhanced CK CK_tblProdBottleRollResults_Grind_pct             Enhanced CK CK_tblProdBottleRollResults_Leach_Recovery_Pct             Enhanced CK CK_tblProdBottleRollResults_Leach_Recovery_Pct_BCH                   --tblProdDailyTrucking             New FK_tblProdDailyTrucking_tblLIBMachinery_Contractor_Digger_No             Dropped index IX_tblProdDailyTrucking_Trucking_Date_To_LocationID_Contractor_TruckID_Digger_No_Count_Spotter                   --tblProdMaterialMovement             Removed Tonnage_Calculated             New column Material_Type                   --tblProdSamp             New trigger TR_utblProdSamp_DataSet             Enhanced trigger TR_dtblProdSamp                   --tblProdSampQC             Enhanced trigger TR_iutblProdSampQC_Orig_SampleID_HasDuplicate             Enhanced trigger TR_iutblProdSampQC_Orig_SampleID             Enhanced trigger TR_iutblProdSampQC_DataSet_Orig_SampleID_SampleID             Enhanced trigger TR_dtblProdSampQC         --tblVWFSAssays             Enhanced logic for performance                   --tblVWFSAssaysQC             Enhanced logic for performance         --tblVWFSAssaysWater             New view                   --tblVWFSAssaysWaterQC             New view                   --tblVWProdAssays             Enhanced logic for performance                   --tblVWProdAssaysQC             Enhanced logic for performance                   --tblVWProdDailyCrushedTotal             Enhanced logic with Tonnage_Calculated                   --tblVWProdDailyMaterial_From             Enhanced logic with Tonnage_Calculated                   --tblVWProdDailyMaterial_To             Enhanced logic with Tonnage_Calculated                   --tblVWProdLocationBalance             Removed view         --tblVWProdMaterialMovement             New view                   --tblVWProdStandardSamp             New view                   --Enhanced udf_ProdLocationRunningBalance       --Enhanced udf_ProdLocationRunningBalance_MovementCode       --Enhanced usp_PopulateProdLocationBalance       --Enhanced utf_ProdLocationDailyBalance       --Removed function udf_ProdLocationCurrentBalance       --Removed function udf_ProdLocationCurrentBalance_MovementCode       --Removed function udf_ProdLocationRunningBalance       --Removed function udf_ProdLocationRunningBalance_MovementCode       --Removed function utf_ProdReporting
v4.6.2 --- Following changes are for v4.6.2 ALL models --- -- tblAssay New FK constraint FK_tblAssay_tblSYSAssLabElementAlias_LabCode_LabElement_Element New FK constraint FK_tblAssay_tblSYSAssLabMethod_LabCode_OrigMethod_GenericMethod Removed redundant FK constraint FK_tblAssay_tblSYSAssElement_Element Removed redundant FK constraint FK_tblAssay_tblSYSAssLabElementAlias_LabCode_LabElement Removed redundant FK constraint FK_tblAssay_tblSYSAssLabMethod_OrigMethod_LabCode Removed redundant FK constraint FK_tblAssay_tblSYSAssMethodGeneric_GenericMethod New index IX_tblAssay_DataSet_SampleID_GenericMethod_Element_Repeat_Preferred_LabCode_Batch_No_LabSequence Removed index IX_tblAssay_DataSet_SampleID_GenericMethod_Element_Repeat_Preferred_LabCode_Batch_No -- tblBudgets New column Reporting_Type -- tblBulkSamp Enhanced trigger TR_utblBulkSamp_DataSet_SampleID -- tblContractActivityCostCode New table -- tblDHAlteration Enhanced CK constraint CK_tblDHAlteration_Alt2_Code Enhanced CK constraint CK_tblDHAlteration_Alt3_Code Enhanced CK constraint CK_tblDHAlteration_Alt4_Code Enhanced CK constraint CK_tblDHAlteration_Alt5_Code -- tblDHSurv Enhanced trigger TR_iutblDHSurv_Dip_MAG_Azimuth_Depth_Priority_Calculate -- tblDHStructureOrient Enhanced trigger TR_iutblDHStructureOrient_Alpha_Beta_Gamma_Calculate -- tblDHMetSamp Enhanced trigger TR_utblDHMetSamp_DataSet_SampleID -- tblDHMetSampQC Enhanced trigger TR_utblDHMetSampQC_DataSet_SampleID -- tblDHMinerals Enhanced CK constraint CK_tblDHMinerals_Min2_Code Enhanced CK constraint CK_tblDHMinerals_Min3_Code Enhanced CK constraint CK_tblDHMinerals_Min4_Code Enhanced CK constraint CK_tblDHMinerals_Min5_Code -- tblDHSamp Enhanced trigger TR_utblDHSamp_DataSet_SampleID -- tblDHSampQC Enhanced trigger TR_utblDHSampQC_DataSet_SampleID -- tblDHVeins Enhanced CK constraint CK_tblDHVeins_Vein2_Code -- tblLeases Enhanced CK constraint CK_tblLeases_Start_Date_End_Date -- tblLIBCostCodeReportType New table -- tblLIBMagSusFactor Enhanced trigger TR_iutblLIBMagSusFactor_Multiplication_Factor -- tblLIBProdBench New column Sort_Order -- tblLIBProdBlockClassification New table -- tblLIBProdBlockClassificationCategory New table -- tblLIBProdModelName New column Model_Type New column Model_Date New column Model_By -- tblLIBProdModelType New table -- tblLIBStandardSampSourceType New column SampTable New trigger TR_utblLIBStandardSampSourceType -- tblLSMetSamp Enhanced trigger TR_utblLSMetSamp_DataSet_SampleID -- tblLSMetSampQC Enhanced trigger TR_utblLSMetSampQC_DataSet_SampleID -- tblLSSamp Enhanced trigger TR_utblLSSamp_DataSet_SampleID -- tblLSSampQC Enhanced trigger TR_utblLSSampQC_DataSet_SampleID -- tblLSSite Removed trigger TR_udtblLSSite_Orig_Grid_Audit New trigger TR_utblLSSite_Orig_Grid_Audit -- tblPetrology New trigger TR_dtblPetrology New trigger TR_itblPetrology New trigger TR_utblPetrology_DataSet_SampleID -- tblPTMetSamp Enhanced trigger TR_utblPTMetSamp_DataSet_SampleID -- tblPTMetSampQC Enhanced trigger TR_iutblPTMetSampQC_Orig_SampleID Enhanced trigger TR_utblPTMetSampQC_DataSet_SampleID Changed Site_ID to allow null Added TR_iutblPTMetSampQC_DataSet_Orig_SampleID_SampleID -- tblPTSamp Enhanced trigger TR_utblPTSamp_DataSet_SampleID -- tblPTSampQC Enhanced trigger TR_utblPTSampQC_DataSet_SampleID Changed Site_ID to allow null Added TR_iutblPTSampQC_DataSet_Orig_SampleID_SampleID -- tblPTSite Removed trigger TR_udtblPTSite_Orig_Grid_Audit New trigger TR_utblPTSite_Orig_Grid_Audit -- tblRehabDH Enhanced CK constraint CK_tblRehabDH_Date_RehabCompleted -- tblSampleRegister Enhanced trigger TR_dtblSampleRegister_SampleCheck -- tblStandardSamp Enhanced trigger TR_utblStandardSamp_DataSet_SampleID -- tblStandardSampQC Enhanced trigger TR_utblStandardSampQC_DataSet_SampleID -- tblSYSAssDispatchHeader New DF constraint DF_tblSYSAssDispatchHeader_Invoiced -- tblSYSAssDispatchSampleRegister Enhanced trigger TR_utblSYSAssDispatchSampleRegister -- tblSYSAssElement Enhanced trigger TR_utblSYSAssElement_SystemUnits -- tblSYSAssLabElementAlias New index IX_tblSYSAssLabElementAlias_LabCode_LabElement_Element New FK constraint FK_tblAssay_tblSYSAssLabElementAlias_LabCode_LabElement_Element Removed FK constraint FK_tblAssay_tblSYSAssElement_Element Removed FK constraint FK_tblAssay_tblSYSAssLabElementAlias_LabCode_LabElement -- tblSYSAssLabMethod New index IX_tblSYSAssLabMethod_LabMethod_LabCode_GenericMethod New FK constraint FK_tblAssay_tblSYSAssLabMethod_OrigMethod_LabCode_GenericMethod Removed FK constraint FK_tblAssay_tblSYSAssLabMethod_OrigMethod_LabCode Removed FK constraint FK_tblAssay_tblSYSAssMethodGeneric_GenericMethod -- tblSYSAssMethodPriority Enhanced trigger TR_iutblSYSAssMethodPriority_Rerank_Method -- tblSYSConfigRelation Enhanced trigger TR_itblSYSConfigRelation -- tblXRFDHSamp Enhanced trigger TR_utblXRFDHSamp_DataSet_SampleID -- tblXRFDHSampQC Enhanced trigger TR_utblXRFDHSampQC_DataSet_SampleID -- tblXRFSamp Enhanced trigger TR_utblXRFSamp_DataSet_SampleID -- tblXRFSampQC Enhanced trigger TR_utblXRFSampQC_DataSet_SampleID -- tblXRFStandardSamp Enhanced trigger TR_utblXRFStandardSamp_DataSet_SampleID -- tblXRFStandardSampQC Enhanced trigger TR_utblXRFStandardSampQC_DataSet_SampleID -- tblVWActivityCostvsBudget New view -- tblVWBudgetsDaily New view -- tblVWContractActivityLogCosts Enhanced view -- tblVWIncidentbyDepartment New view -- tblVWIncidentbyReportingType New view -- tblVWInvoicevsBudget New view -- tblVWPTLogging Enhanced view and triggers -- tblVWXRFDHResults Enhanced view -- tblVWXRFResults Enhanced view -- Changed all Azimuth/RL/Z column to be DECIMAL(18,4) -- Enhanced update audit triggers for Loaded_By/Load_Date on all tables -- Enhanced udf_CheckAzimuthDeviation -- Enhanced udf_DistanceWAveDipAzi -- Enhanced udf_OrientDipAzi -- Enhanced udf_OrientDipDirection -- Enhanced usp_AdminDataDictionary -- Enhanced usp_DataStructOrientDriver -- Enhanced usp_DataTestAssayFlatPopulated -- Removed usp_DataTestAssayFlatPopulatedDetail -- Enhanced usp_DataUpdateStandardSampSourceID -- Removed usp_DataUpdateStandardSampHoleID -- Enhanced usp_ListMissingIntervals -- Enhanced usp_AdminConfigMDSAssembly -- New usp_TableReferenceLevel -- New utf_GetReportDays -- Removed udf_GetDataSetForProdLocation from non-Production models --- Following changes are for v4.6.2 and model specific: --- For Production model -- tblFSMetSamp Enhanced trigger TR_utblFSMetSamp_DataSet_SampleID -- tblFSMetSampQC Enhanced trigger TR_utblFSMetSampQC_DataSet_SampleID -- tblFSSamp Enhanced trigger TR_utblFSSamp_DataSet_SampleID -- tblFSSampQC Enhanced trigger TR_utblFSSampQC_DataSet_SampleID -- tblFSSite New column Advance_Length Changed PK column order to be DataSet/Site_ID/Line_ID (and same on other related FS tables) Removed trigger TR_udtblFSSite_Orig_Grid_Audit New trigger TR_utblFSSite_Orig_Grid_Audit -- tblProdBlasting New column Survey_Type New column Surveyed_Date New column Surveyed_By New column Dilution_pct New column Planned_Blast_Type New column Planned_Blast_Quantity New column Blast_Quantity_Variance New column Planned_Explosive_Type New column Planned_Explosive_Mass New column Planned_Explosive_Mass_Unit New column Level New column BenchID New column RL_To Renamed Explosive_Mass_UnitCode to Mass_UnitCode New FK constraint FK_tblProdBlasting_tblSYSUnits_Mass_UnitCode -- tblProdBlock Renamed Parent_Stope to Parent_BlockID and changed to NOT NULL Changed DataSet to NOT NULL New column Reporting_Type New column RL_From New column RL_To Changed Level to NOT NULL Changed Block_Status to NOT NULL New FK FK_tblProdBlock_tblSYSUnits_Mined_Unit New trigger TR_iutblProdBlock_BlockID_DataSet New trigger TR_itblProdBlock_BlockRegister New trigger TR_utblProdBlock_BlockID_Parent_BlockID_DataSet New trigger TR_dtblProdBlock_BlockRegister -- tblProdBlockCommodities Removed column Mined_Grade_Quantity Removed column Mined_Grade_Quantity_Unit Removed column FC_Grade Removed column FC_Grade_Unit New column Nominal_Grade New column Mined_Value New column Mined_Value_Unit Renamed Mined_Grade_Unit to Grade_Unit -- tblProdBlockPlanned Redesigned tblProdBlockPlanned -- tblProdBlockPlannedCommodities New table -- tblProdBlockRegister New table -- tblProdBlockReserve New table -- tblProdBlockReserveCommodities New table -- tblProdBlockResource New table -- tblProdBlockResourceCommodities New table -- tblProdBlockTreeView New table -- tblPRodDailyTrucking Changed Contractor to NOT NULL New column Movement_Grade_Category Changed Count_Spotter to NOT NULL -- tblProdEOMActualsStockpileCommodity New table -- tblProdLocationBalance New table -- tblProdLocationsCommodity Renamed Commodity_Unit to Commodity_Grade_Unit -- tblProdMaterialMovement Changed EquipmentID to NOT NULL Changed Contractor to NOT NULL Changed PK to PK_tblProdMaterialMovement_Movement_Date_EquipmentID_Shift_LocationID_From_LocationID_To_Movement_Type_Tonnage_Type Enhanced trigger TR_utblProdMaterialMovement -- tblProdSamp Changed column DataSet from computed column to a standard column New trigger TR_iutblProdSamp_DataSet Enhanced trigger TR_utblProdSamp_LocationID_SampleID -- tblProdSampQC Changed column DataSet from computed column to a standard column New trigger TR_iutblProdSampQC_DataSet Enhanced trigger TR_utblProdSampQC_LocationID_SampleID -- tblProdWeightometer New FK constraint FK_tblProdWeightometer_tblLIBReportingType_Movement_Code -- tblVWProdAssays Enhanced view -- tblVWProdAssaysQC Enhanced view -- tblVWProdReconMinedvsPlanned New view -- tblVWProdReconPlannedvsReserve New view -- tblVWProdReconReservevsResource New view -- tblVWProdReconTrucktoResource New view -- tblVWProdTruckingClaimed Enhanced view -- tblVWProdReconTruckvsProdMined New view -- tblVWProdTruckingCalculated Enhanced view -- tblVWProdTruckingClaimed Enhanced view -- tblVWProdTruckingRpt New view -- Enhanced usp_ProdLocationBalanceReportingTroubleshooter -- Enhanced udf_ProdLocationDailyBalance -- New usp_PopulateProdLocationBalance -- Enhanced utf_ProdReporting -- New usp_PopulateProdBlockTreeView -- Enhanced udf_ProdLocationCurrentBalance
v4.6.1 SP1 --- Following changes are for v4.6.1 SP1 ALL models --- -- tblAssay Enhanced trigger TR_utblAssay_AssayResultNum_UnitCode_LimitLower_sysAssayStatus_Element_Repeat_Preferred to populate tblSYSNormProcessStack when DataSet/SampleID renamed -- tblDHColl Removed trigger TR_udtblDHColl_Orig_Grid_Audit New trigger TR_utblDHColl_Orig_Grid_Audit -- tblDHGeotech Removed trigger TR_iutblDHGeotech_Interval_Overlap -- tblDHGrouting Removed column Contractor -- tblDHPhoto New column PhotoCatID New column LocTypeID -- tblDHSamp Enhanced trigger TR_dtblDHSamp to check QC table before delete -- tblDHSampQC Enhanced trigger TR_dtblDHSampQC to check QC table before delete -- tblLIBGeotShape Renamed table to tblLIBStructShape -- tblLIBPerson New column Company -- tblLIBPTPhotoCat Renamed table to tblLIBPhotoCat -- tblLIBPTPhotoLocType Renamed table to tblLIBPhotoLocType -- tblLIBStructPlaneIntensity Merged into tblLIBIntensity -- Removed table tblLIBSurveyPoint -- tblLSMapping Renamed Depth_From to Length_From Renamed Depth_To to Length_To Dropped column Lith1_Code Dropped column Lith_Description Enhanced trigger TR_utblLSMapping join conditions -- tblLSMagSus Enhanced trigger TR_iutblLSMagSus_Valid_Intervals condition to include Line_ID -- tblLSMetaData Renamed column LS_Type to Linear_Type Renamed column LS_Width to Linear_Width Renamed column LS_Height to Linear_Height -- tblLSMetSamp Enhanced trigger TR_dtblLSMetSamp to check QC table before delete -- tblLSMetSampQC Enhanced trigger TR_dtblLSMetSampQC to check QC table before delete Enhanced trigger TR_dtblLSMetSampQC_HasDuplicate with correct table name -- tblLSSamp Enhanced trigger TR_dtblLSSamp to check QC table before delete -- tblLSSampQC Enhanced trigger TR_dtblLSSampQC to check QC table before delete Enhanced trigger TR_dtblLSSampQC_HasDuplicate with correct table name Enhanced trigger TR_iutblLSSampQC_Orig_SampleID_HasDuplicate with correct table name -- tblPTGeology Removed column Depth -- tblPTMagSus Enhanced trigger TR_iutblPTMagSus_Sample_Type to check for correct sample type -- tblPTMapping Enhanced trigger TR_utblPTMapping with update conditions -- tblPTMetSamp Enhanced trigger TR_dtblPTMetSamp to check QC table before delete -- tblPTMetSampQC Enhanced trigger TR_dtblPTMetSampQC to check QC table before delete Enhanced trigger TR_dtblPTMetSampQC_HasDuplicate with correct table name Enhanced trigger TR_iutblPTMetSampQC_HasDuplicate with correct table name -- tblPTSamp Removed column Sample_Depth Enhanced trigger TR_dtblPTSamp to check QC table before delete -- tblPTSampQC Enhanced trigger TR_dtblPTSampQC to check QC table before delete -- tblPTSite Removed column Site_Photo_Path -- tblSampleRegister New trigger TR_iutblSampleRegister_SourceTable -- tblStandardSamp Enhanced trigger TR_dtblStandardSamp to check QC table before delete -- tblStandardSampQC Enhanced trigger TR_dtblStandardSampQC to check QC table before delete -- tblSYSMergeTableAttributes TR_iutblSYSMergeTableAttributes -- tblVWPTGeoChemLogging Updated view and triggers -- tblVWPTSampLogging Updated view and triggers -- New view tblVWPTLogging -- tblVWXRFResults Added GenericMethod, Repeat, Preferred -- tblXRFDHSamp Renamed trigger TR_iutblXRFDHSamp_DataSet_Hole_ID_Depth_From_Depth_To_Valid_Intervals to TR_iutblXRFDHSamp_Valid_Intervals Enhanced trigger TR_itblXRFDHSamp Enhanced trigger TR_dtblXRFDHSamp to check QC table before delete -- tblXRFDHSampQC Enhanced trigger TR_itblXRFDHSampQC Enhanced trigger TR_dtblXRFDHSampQC to check QC table before delete -- tblXRFSamp Enhanced trigger TR_itblXRFSamp Enhanced trigger TR_dtblXRFSamp to check QC table before delete -- tblXRFSampQC Enhanced trigger TR_itblXRFSampQC Enhanced trigger TR_dtblXRFSampQC to check QC table before delete -- tblXRFStandardSamp Enhanced trigger TR_dtblXRFStandardSamp to check QC table before delete -- tblXRFStandardSampQC Enhanced trigger TR_dtblXRFStandardSampQC to check QC table before delete -- Enhanced usp_DataAssayMergingProcess Modified logic to work for both normal assay tables and XRF tables -- Enhanced usp_DataAssayRankingProcess Removes data from static table for samples in stack before ranking (Bug#3280) -- Enhanced usp_DataDesurvey and related SPs Modified logic to work with LS/FS tables (Bug#3202,3235) -- Enhanced usp_DataSurveyDeviationChecker Removed hardcoded only check on Mag_Azimuth (Bug#2978) Modified logic to work with LS/FS survey tables (Bug#3204) -- Enhanced usp_DataXRFResultsMergingProcess Modified to call usp_DataAssayMergingProcess -- Enhanced usp_ProcessInComingDataDriver and related SPs Modified logic to handle both tblAssay and tblXRFResults -- Enhanced usp_ProcessXRFInComingDataDriver Modified to call usp_ProcessInComingDataDriver --- Following changes are for v4.6.1 SP1 and model specific: --- For Production model -- tblFSGeology Enhanced TR_iutblFSGeology_Valid_Intervals with correct join conditions -- tblFSMagSus Enhanced TR_iutblFSMagSus_Sample_Type to check for correct sample type -- tblFSMetaData Removed column Shift Removed column Face_Type Updated trigger TR_iutblFSMetaData_Valid_Intervals error message -- tblFSMetSamp Updated trigger TR_iutblFSMetSamp_Valid_Intervals error message Enhanced trigger TR_dtblFSMetSamp to check QC table before delete -- tblFSMetSampQC Updated trigger TR_iutblFSMetSampQC_Valid_Intervals error message Enhanced trigger TR_dtblFSMetSampQC to check QC table before delete Enhanced trigger TR_dtblFSMetSampQC_HasDuplicate to action on correct table Enhanced trigger TR_iutblFSMetSampQC_HasDuplicate to action on correct table -- tblFSPhoto Updated trigger TR_iutblFSPhoto_Valid_Intervals error message -- tblFSSamp Updated trigger TR_iutblFSamp_Valid_Intervals error message Enhanced trigger TR_dtblFSSamp to check QC table before delete -- tblFSSampQC Updated trigger TR_iutblFSampQC_Valid_Intervals error message Enhanced trigger TR_dtblFSSampQC to check QC table before delete -- tblFSSite Updated trigger TR_utblFSSite_Max_Width error message Changed Survey_Point to FK tblPTSite -- tblFSSurv Updated trigger TR_iutblFSSurv_Valid_Depth error message -- tblProdBottleRollResults Enhanced trigger TR_uttblProdBottleRollResults with update conditions -- tblProdEOMCommodities Enhanced trigger TR_utblProdEOMCommodities with update conditions -- tblProdEOMCommoditiesPrice Enhanced trigger TR_utblProdEOMCommoditiesPrice with update conditions -- tblProdReporting Enhanced trigger TR_iutblProdReporting_Source_ID_Source_Type with trigger conditions -- tblProdSamp Enhanced trigger TR_dtblProdSamp to check QC table before delete -- tblProdSampQC Enhanced trigger TR_dtblProdSampQC to check QC table before delete -- tblProdSlopeHazardDetails Enhanced trigger TR_utblProdSlopeHazardDetails on update conditions -- tblProdWeightometer Enhanced trigger TR_utblProdWeightometer on update conditions Following changes are for v4.6.2 ALL models --- -- tblAssay New FK constraint FK_tblAssay_tblSYSAssLabElementAlias_LabCode_LabElement_Element New FK constraint FK_tblAssay_tblSYSAssLabMethod_LabCode_OrigMethod_GenericMethod Removed redundant FK constraint FK_tblAssay_tblSYSAssElement_Element Removed redundant FK constraint FK_tblAssay_tblSYSAssLabElementAlias_LabCode_LabElement Removed redundant FK constraint FK_tblAssay_tblSYSAssLabMethod_OrigMethod_LabCode Removed redundant FK constraint FK_tblAssay_tblSYSAssMethodGeneric_GenericMethod New index IX_tblAssay_DataSet_SampleID_GenericMethod_Element_Repeat_Preferred_LabCode_Batch_No_LabSequence Removed index IX_tblAssay_DataSet_SampleID_GenericMethod_Element_Repeat_Preferred_LabCode_Batch_No -- tblBudgets New column Reporting_Type -- tblBulkSamp Enhanced trigger TR_utblBulkSamp_DataSet_SampleID -- tblContractActivityCostCode New table -- tblDHAlteration Enhanced CK constraint CK_tblDHAlteration_Alt2_Code Enhanced CK constraint CK_tblDHAlteration_Alt3_Code Enhanced CK constraint CK_tblDHAlteration_Alt4_Code Enhanced CK constraint CK_tblDHAlteration_Alt5_Code -- tblDHSurv Enhanced trigger TR_iutblDHSurv_Dip_MAG_Azimuth_Depth_Priority_Calculate -- tblDHStructureOrient Enhanced trigger TR_iutblDHStructureOrient_Alpha_Beta_Gamma_Calculate -- tblDHMetSamp Enhanced trigger TR_utblDHMetSamp_DataSet_SampleID -- tblDHMetSampQC Enhanced trigger TR_utblDHMetSampQC_DataSet_SampleID -- tblDHMinerals Enhanced CK constraint CK_tblDHMinerals_Min2_Code Enhanced CK constraint CK_tblDHMinerals_Min3_Code Enhanced CK constraint CK_tblDHMinerals_Min4_Code Enhanced CK constraint CK_tblDHMinerals_Min5_Code -- tblDHSamp Enhanced trigger TR_utblDHSamp_DataSet_SampleID -- tblDHSampQC Enhanced trigger TR_utblDHSampQC_DataSet_SampleID -- tblDHVeins Enhanced CK constraint CK_tblDHVeins_Vein2_Code -- tblLeases Enhanced CK constraint CK_tblLeases_Start_Date_End_Date -- tblLIBCostCodeReportType New table -- tblLIBMagSusFactor Enhanced trigger TR_iutblLIBMagSusFactor_Multiplication_Factor -- tblLIBProdBench New column Sort_Order -- tblLIBProdBlockClassification New table -- tblLIBProdBlockClassificationCategory New table -- tblLIBProdModelName New column Model_Type New column Model_Date New column Model_By -- tblLIBProdModelType New table -- tblLIBStandardSampSourceType New column SampTable New trigger TR_utblLIBStandardSampSourceType -- tblLSMetSamp Enhanced trigger TR_utblLSMetSamp_DataSet_SampleID -- tblLSMetSampQC Enhanced trigger TR_utblLSMetSampQC_DataSet_SampleID -- tblLSSamp Enhanced trigger TR_utblLSSamp_DataSet_SampleID -- tblLSSampQC Enhanced trigger TR_utblLSSampQC_DataSet_SampleID -- tblLSSite Removed trigger TR_udtblLSSite_Orig_Grid_Audit New trigger TR_utblLSSite_Orig_Grid_Audit -- tblPetrology New trigger TR_dtblPetrology New trigger TR_itblPetrology New trigger TR_utblPetrology_DataSet_SampleID -- tblPTMetSamp Enhanced trigger TR_utblPTMetSamp_DataSet_SampleID -- tblPTMetSampQC Enhanced trigger TR_iutblPTMetSampQC_Orig_SampleID Enhanced trigger TR_utblPTMetSampQC_DataSet_SampleID Changed Site_ID to allow null Added TR_iutblPTMetSampQC_DataSet_Orig_SampleID_SampleID -- tblPTSamp Enhanced trigger TR_utblPTSamp_DataSet_SampleID -- tblPTSampQC Enhanced trigger TR_utblPTSampQC_DataSet_SampleID Changed Site_ID to allow null Added TR_iutblPTSampQC_DataSet_Orig_SampleID_SampleID -- tblPTSite Removed trigger TR_udtblPTSite_Orig_Grid_Audit New trigger TR_utblPTSite_Orig_Grid_Audit -- tblRehabDH Enhanced CK constraint CK_tblRehabDH_Date_RehabCompleted -- tblSampleRegister Enhanced trigger TR_dtblSampleRegister_SampleCheck -- tblStandardSamp Enhanced trigger TR_utblStandardSamp_DataSet_SampleID -- tblStandardSampQC Enhanced trigger TR_utblStandardSampQC_DataSet_SampleID -- tblSYSAssDispatchHeader New DF constraint DF_tblSYSAssDispatchHeader_Invoiced -- tblSYSAssDispatchSampleRegister Enhanced trigger TR_utblSYSAssDispatchSampleRegister -- tblSYSAssElement Enhanced trigger TR_utblSYSAssElement_SystemUnits -- tblSYSAssLabElementAlias New index IX_tblSYSAssLabElementAlias_LabCode_LabElement_Element New FK constraint FK_tblAssay_tblSYSAssLabElementAlias_LabCode_LabElement_Element Removed FK constraint FK_tblAssay_tblSYSAssElement_Element Removed FK constraint FK_tblAssay_tblSYSAssLabElementAlias_LabCode_LabElement -- tblSYSAssLabMethod New index IX_tblSYSAssLabMethod_LabMethod_LabCode_GenericMethod New FK constraint FK_tblAssay_tblSYSAssLabMethod_OrigMethod_LabCode_GenericMethod Removed FK constraint FK_tblAssay_tblSYSAssLabMethod_OrigMethod_LabCode Removed FK constraint FK_tblAssay_tblSYSAssMethodGeneric_GenericMethod -- tblSYSAssMethodPriority Enhanced trigger TR_iutblSYSAssMethodPriority_Rerank_Method -- tblSYSConfigRelation Enhanced trigger TR_itblSYSConfigRelation -- tblXRFDHSamp Enhanced trigger TR_utblXRFDHSamp_DataSet_SampleID -- tblXRFDHSampQC Enhanced trigger TR_utblXRFDHSampQC_DataSet_SampleID -- tblXRFSamp Enhanced trigger TR_utblXRFSamp_DataSet_SampleID -- tblXRFSampQC Enhanced trigger TR_utblXRFSampQC_DataSet_SampleID -- tblXRFStandardSamp Enhanced trigger TR_utblXRFStandardSamp_DataSet_SampleID -- tblXRFStandardSampQC Enhanced trigger TR_utblXRFStandardSampQC_DataSet_SampleID -- tblVWActivityCostvsBudget New view -- tblVWBudgetsDaily New view -- tblVWContractActivityLogCosts Enhanced view -- tblVWIncidentbyDepartment New view -- tblVWIncidentbyReportingType New view -- tblVWInvoicevsBudget New view -- tblVWPTLogging Enhanced view and triggers -- tblVWXRFDHResults Enhanced view -- tblVWXRFResults Enhanced view -- Changed all Azimuth/RL/Z column to be DECIMAL(18,4) -- Enhanced update audit triggers for Loaded_By/Load_Date on all tables -- Enhanced udf_CheckAzimuthDeviation -- Enhanced udf_DistanceWAveDipAzi -- Enhanced udf_OrientDipAzi -- Enhanced udf_OrientDipDirection -- Enhanced usp_AdminDataDictionary -- Enhanced usp_DataStructOrientDriver -- Enhanced usp_DataTestAssayFlatPopulated -- Removed usp_DataTestAssayFlatPopulatedDetail -- Enhanced usp_DataUpdateStandardSampSourceID -- Removed usp_DataUpdateStandardSampHoleID -- Enhanced usp_ListMissingIntervals -- Enhanced usp_AdminConfigMDSAssembly -- New usp_TableReferenceLevel -- New utf_GetReportDays -- Removed udf_GetDataSetForProdLocation from non-Production models --- Following changes are for v4.6.2 and model specific: --- For Production model -- tblFSMetSamp Enhanced trigger TR_utblFSMetSamp_DataSet_SampleID -- tblFSMetSampQC Enhanced trigger TR_utblFSMetSampQC_DataSet_SampleID -- tblFSSamp Enhanced trigger TR_utblFSSamp_DataSet_SampleID -- tblFSSampQC Enhanced trigger TR_utblFSSampQC_DataSet_SampleID -- tblFSSite New column Advance_Length Changed PK column order to be DataSet/Site_ID/Line_ID (and same on other related FS tables) Removed trigger TR_udtblFSSite_Orig_Grid_Audit New trigger TR_utblFSSite_Orig_Grid_Audit -- tblProdBlasting New column Survey_Type New column Surveyed_Date New column Surveyed_By New column Dilution_pct New column Planned_Blast_Type New column Planned_Blast_Quantity New column Blast_Quantity_Variance New column Planned_Explosive_Type New column Planned_Explosive_Mass New column Planned_Explosive_Mass_Unit New column Level New column BenchID New column RL_To Renamed Explosive_Mass_UnitCode to Mass_UnitCode New FK constraint FK_tblProdBlasting_tblSYSUnits_Mass_UnitCode -- tblProdBlock Renamed Parent_Stope to Parent_BlockID and changed to NOT NULL Changed DataSet to NOT NULL New column Reporting_Type New column RL_From New column RL_To Changed Level to NOT NULL Changed Block_Status to NOT NULL New FK FK_tblProdBlock_tblSYSUnits_Mined_Unit New trigger TR_iutblProdBlock_BlockID_DataSet New trigger TR_itblProdBlock_BlockRegister New trigger TR_utblProdBlock_BlockID_Parent_BlockID_DataSet New trigger TR_dtblProdBlock_BlockRegister -- tblProdBlockCommodities Removed column Mined_Grade_Quantity Removed column Mined_Grade_Quantity_Unit Removed column FC_Grade Removed column FC_Grade_Unit New column Nominal_Grade New column Mined_Value New column Mined_Value_Unit Renamed Mined_Grade_Unit to Grade_Unit -- tblProdBlockPlanned Redesigned tblProdBlockPlanned -- tblProdBlockPlannedCommodities New table -- tblProdBlockRegister New table -- tblProdBlockReserve New table -- tblProdBlockReserveCommodities New table -- tblProdBlockResource New table -- tblProdBlockResourceCommodities New table -- tblProdBlockTreeView New table -- tblPRodDailyTrucking Changed Contractor to NOT NULL New column Movement_Grade_Category Changed Count_Spotter to NOT NULL -- tblProdEOMActualsStockpileCommodity New table -- tblProdLocationBalance New table -- tblProdLocationsCommodity Renamed Commodity_Unit to Commodity_Grade_Unit -- tblProdMaterialMovement Changed EquipmentID to NOT NULL Changed Contractor to NOT NULL Changed PK to PK_tblProdMaterialMovement_Movement_Date_EquipmentID_Shift_LocationID_From_LocationID_To_Movement_Type_Tonnage_Type Enhanced trigger TR_utblProdMaterialMovement -- tblProdSamp Changed column DataSet from computed column to a standard column New trigger TR_iutblProdSamp_DataSet Enhanced trigger TR_utblProdSamp_LocationID_SampleID -- tblProdSampQC Changed column DataSet from computed column to a standard column New trigger TR_iutblProdSampQC_DataSet Enhanced trigger TR_utblProdSampQC_LocationID_SampleID -- tblProdWeightometer New FK constraint FK_tblProdWeightometer_tblLIBReportingType_Movement_Code -- tblVWProdAssays Enhanced view -- tblVWProdAssaysQC Enhanced view -- tblVWProdReconMinedvsPlanned New view -- tblVWProdReconPlannedvsReserve New view -- tblVWProdReconReservevsResource New view -- tblVWProdReconTrucktoResource New view -- tblVWProdTruckingClaimed Enhanced view -- tblVWProdReconTruckvsProdMined New view -- tblVWProdTruckingCalculated Enhanced view -- tblVWProdTruckingClaimed Enhanced view -- tblVWProdTruckingRpt New view -- Enhanced usp_ProdLocationBalanceReportingTroubleshooter -- Enhanced udf_ProdLocationDailyBalance -- New usp_PopulateProdLocationBalance -- Enhanced utf_ProdReporting -- New usp_PopulateProdBlockTreeView -- Enhanced udf_ProdLocationCurrentBalance
v4.6.1 -- Update tblSYSConversionFactor values (20 Mar 2014) -- Update QAQCR configuration settings (20 Mar 2014) -- Enhanced usp_ProcessIncomingDataDriver (27 Mar 2014) -- Enhanced insert/update triggers for tblVWPTGeoChemLogging (31 Mar 2014) -- Enhanced insert/update triggers for tblVWPTSampLogging (31 Mar 2014) -- Enhanced usp_DataAssayMergingProcess (31 Mar 2014) -- Update tblDHPhoto.Depth_From/Depth_To to allow NULL (4 Apr 2014) Update TR_iutblDHPhoto_Valid_Intervals (4 Apr 2014) -- Update tblLSPhoto.Length_From/Length_To to allow NULL (4 Apr 2014) Update TR_iutblLSPhoto_Valid_Intervals (4 Apr 2014) -- Add element 'BaO' into tblSYSAssElement (4 Apr 2014) -- Update tblSYSNormAttributeDef set Param1 = 'Ind' for AttributeName = 'IN_PPM' (4 Apr 2014) -- Enhanced usp_AdminCleanUpDataShedObjects (9 Apr 2014) -- Enhanced system DAL structure (9 Apr 2014) -- Enhanced insert/update triggers on the following tables to better handle situation when PK column values updated (14 Apr 2014) tblDHCoreRecoveryRun tblDHGeotechRMR tblDHGeotechRQD tblDHMetSamp tblDHMetSampQC tblDHSamp tblDHSampQC tblLIBContractType tblLSMetSamp tblLSMetSampQC tblLSSamp tblLSSampQC tblPTMetSamp tblPTMetSampQC tblPTSamp tblPTSampQC tblStandardSamp tblStandardSampQC tblVWPTGeoChemLogging tblVWPTSamp tblVWPTSampLogging tblXRFDHSamp tblXRFDHSampQC tblXRFSamp tblXRFSampQC tblXRFStandardSamp tblXRFStandardSampQC -- New column tblDHMetaData.Bit_Type (30 Apr 2014) -- New view tblVWSites (30 Apr 2014) -- New trigger TR_iutblSYSQCReferenceValue_Preferred to check Preferred 0 record exists (30 Apr 2014) -- Enhancements on tblLSSurv (30 Apr 2014) Renamed column DHSurvey_Method to Survey_Method (30 Apr 2014) Renamed column DHSurvey_Company to Survey_Company (30 Apr 2014) Renamed column DHSurvey_Operator to Survey_Operator (30 Apr 2014) Renamed column DHSurvey_Instrument to Survey_Instrument (30 Apr 2014) Dropped constraint FK_tblLSSurv_tblLIBDHSurveyMethod_DHSurvey_Method (30 Apr 2014) New constraint FK_tblLSSurv_tblLIBSurveyMethod_Survey_Method (30 Apr 2014) -- New constraints on tblIncident (30 Apr 2014) DF_tblIncident_Report_Internally DF_tblIncident_Report_Externally -- tblDHWeathering column Logged_By, Logged_Date changed to allow NULL and Weath_Code to not allow NULL (6 May 2014) -- Updated FK_tblPTGeology_tblLIBOxidation_Weathering on table tblPTGeology (8 May 2014) -- Enhanced TR_utblPTSamp_DataSet_SampleID (8 May 2014) -- Enhanced insert/update/delete trigger on tblVWPTSampLogging (8 May 2014) -- Enhanced insert/update/delete trigger on tblVWPTGeoChemLogging (8 May 2014) -- Enhancements on tblLIBPerson changed Email fiedl to be nvarchar(1000) (11 Jun 2014) -- Enhancements on tblLIBDriveID added DataSet field (11 Jun 2014) -- Enhancements on tblSYSAssDispatchDetails (11 Jun 2014) Dropped FK on Email_Copy_to and changed the field to be nvarchar(1000) Dropped FK on Email_Job_to and changed the field to be nvarchar(1000) -- Enhancements on tblStandardSamp (11 Jun 2014) Renamed Hole_ID to Source_ID Added Secondary_Source_ID Added Source_Type Added trigger TR_iutblStandardSamp_Source_ID -- enhanced usp_DataUpdateStandardSampHoleID (27 Jun 2014) -- removed usp_RenameDataSetHoleSample -- Add FK to tblLIBSampleType for all sample and sample QC tables (This is required by LogChief filtering function) -- Enhancement on StriplogDataTables Add defaults for Adjustable & GroupAdjustment -- tblContractActivityLog New DF_tblContractActivityLog_Contractor_Reference New DF_tblContractActivityLog_Operator Changed Operator to not null Changed Start_Time/Finish_Time/Responsible_Person to allow null Renamed Machinery to MachineryID Changed ActivityID from NVARCHAR(20) TO NVARCHAR(50) -- tblContractActivityLogMetres Enhanced TR_iutblContractActivityLogMetres_Interval_Overlap Enhanced TR_iutblContractActivityLogMetres_Valid_Intervals Changed ActivityID from NVARCHAR(20) TO NVARCHAR(50) -- tblContractActivityLogDetails Changed ActivityID from NVARCHAR(20) TO NVARCHAR(50) -- tblContractHeader Updated Contract_Currency default value to match with the column data type -- New table tblContractInvoiceCostCode -- tblDHAlteration Added check constraints for Alt*_Code/Alt*_Style Enhanced TR_iutblDHAlteration_Interval_Overlap Enhanced TR_iutblDHAlteration_Valid_Intervals -- tblDHColl Removed Collar_Azimuth_Grid_ID/Collar_Azimuth/Collar_Dip/BOCO_Depth/TOFR_Depth and associated FK/CK constraints (only if no data already exists) Enhanced TR_udtblDHColl_Orig_Grid_Audit Enhanced TR_utblDHColl_Max_Depth -- tblDHCoreRecoveryRun Enhanced TR_iutblDHCoreRecoveryRun_RQDPct_RecoveryPct Use Recovery_Interval instead of Depth_To-Depth_From in the calculation Better handle updates on manually entered pct values Enhanced TR_iutblDHCoreRecoveryRun_Interval_Overlap Enhanced TR_iutblDHCoreRecoveryRun_Valid_Intervals -- tblDHCoreStorage Enhanced TR_iutblDHCoreStorage_Interval_Overlap Enhanced TR_iutblDHCoreStorage_Valid_Intervals -- tblDHCoreStorageDetails Removed FK_tblDHCoreStorageDetails_tblDHColl_DataSet_Hole_ID Added FK_tblDHCoreStorageDetails_tblDHCoreStorage_DataSet_Hole_ID_Depth_From Enhanced TR_iutblDHCoreStorageDetails_Interval_Overlap Enhanced TR_iutblDHCoreStorageDetails_Valid_Intervals -- tblDHEvents Enhanced TR_iutblDHEvents_Valid_Intervals -- tblDHGeology Renamed Vein1_Comp to Vein1_Code Renamed Vein2_Comp to Vein2_Code Changed Min1_pct/Min2_pct to DECIMAL(18,2) Added FK for Grid_ID Enhanced TR_iutblDHGeology_Interval_Overlap Enhanced TR_iutblDHGeology_Valid_Intervals Added CK constraints for Lith2/Alt2/Min2/Vein2 codes -- tblDHGeophysics Enhanced TR_iutblDHGeophysics_Interval_Overlap Enhanced TR_iutblDHGeophysics_Valid_Intervals -- tblDHGeophysicsPT Enhanced TR_iutblDHGeophysicsPt_Valid_Intervals -- tblDHGeotech Enhanced TR_iutblDHGeotech_Interval_Overlap Enhanced TR_iutblDHGeotech_Valid_Intervals -- tblDHGeotechLoadStrength Enhanced TR_iutblDHGeotechLoadStrength_Interval_Overlap Enhanced TR_iutblDHGeotechLoadStrength_Valid_Intervals -- tblDHGeotechRMR Enhanced TR_iutblDHGeotechRMR_Interval_Overlap Enhanced TR_iutblDHGeotechRMR_Valid_Intervals Enhanced TR_iutblDHGeotechRMR_Recovery_pct_RQD_pct Changed Structure_Count to allow null -- tblDHGeotechRQD Enhanced TR_iutblDHGeotechRQD_Interval_Overlap Enhanced TR_iutblDHGeotechRQD_Valid_Intervals Enhanced TR_iutblDHGeotechRQD_RQD_pct -- tblDHGrouting Enhanced TR_iutblDHGrouting_Interval_Overlap Enhanced TR_iutblDHGrouting_Valid_Intervals -- tblDHIntercepts Added FK for Grid_ID -- tblDHLithology Added check constraints for Lith1_Code/Lith2_Code Added check constraint for Lith2 attributes Added FK for Grid_ID Enhanced TR_iutblDHLithology_Interval_Overlap Enhanced TR_iutblDHLithology_Valid_Intervals -- tblDHMagSus Enhanced TR_iutblDHMagSus_AveReading Enhanced TR_iutblDHMagSus_Interval_Overlap Enhanced TR_iutblDHMagSus_Valid_Intervals -- tblDHMagSusPT Updated Instrument/Instrument_FactorCode default values to match with the column data type Enhanced TR_iutblDHMagSusPT_AveReading Enhanced TR_iutblDHMagSusPT_Valid_Intervals -- tblDHMetaData Enhanced TR_iutblDHMetaData_Interval_Overlap Enhanced TR_iutblDHMetaData_Valid_Intervals -- tblDHMetSamp Enhanced TR_iutblDHMetSamp_Interval_Overlap Enhanced TR_iutblDHMetSamp_Valid_Intervals -- tblDHMetSampQC Removed TR_utblDHMetSampQC_DataSet_Orig_SampleID_SampleID Added TR_iutblDHMetSampQC_DataSet_Orig_SampleID_SampleID Enhanced TR_iutblDHMetSampQC_Valid_Intervals -- tblDHMinerals Changed Min*_pct data type from 3 decimal point to 2 decimal point Added check constraints on Min*_Code/Min*_pct/Min*_Style Enhanced TR_iutblDHMinerals_Interval_Overlap Enhanced TR_iutblDHMinerals_Valid_Intervals -- tblDHModelComposite Added new column Comments Enhanced TR_iutblDHModelComposite_Interval_Overlap Enhanced TR_iutblDHModelComposite_Valid_Intervals -- tblDHOxidation Enhanced TR_iutblDHOxidation_Interval_Overlap Enhanced TR_iutblDHOxidation_Valid_Intervals -- tblDHPhoto Changed Interval_Length to be persisted Enhanced TR_iutblDHPhoto_Valid_Intervals -- tblDHRadiometrics Added FK for Grid_ID Enhanced TR_iutblDHRadiometrics_Interval_Overlap Enhanced TR_iutblDHRadiometrics_Valid_Intervals Changed Ave_Reading to be computed column -- tblDHSamp Added FK for Grid_ID Enhanced TR_iutblDHSamp_Interval_Overlap Enhanced TR_iutblDHSamp_Valid_Intervals -- tblDHSampQC Removed TR_utblDHSampQC_DataSet_Orig_SampleID_SampleID Added TR_iutblDHSampQC_DataSet_Orig_SampleID_SampleID Enhanced TR_iutblDHSampQC_Valid_Intervals -- tblDHSpecGrav Enhanced TR_iutblDHSpecGrav_Interval_Overlap Enhanced TR_iutblDHSpecGrav_Valid_Intervals Renamed Sampled_By/Date_Sampled to Measured_By/Measured_Date -- tblDHStructure Renamed CK_tblDHStructureInterval_Depth_From_Depth_To to CK_tblDHStructure_Depth_From_Depth_To Enhanced TR_iutblDHStructure_Interval_Overlap Enhanced TR_iutblDHStructure_Valid_Intervals -- tblDHStructureOrient Enhanced TR_iutblDHStructureOrient_Valid_Intervals -- tblDHSurv Added FK for Grid_ID Enhanced TR_iutblDHSurv_Valid_Depth New trigger TR_iutblDHSurv_Deviation -- tblDHVeins Renamed Vein1_Comp to Vein1_Code and added check constraint Renamed Vein2_Comp to Vein2_Code and added check constraint Added check constraint for Vein2_pct/Vein2_Style Enhanced TR_iutblDHVeins_Interval_Overlap Enhanced TR_iutblDHVeins_Valid_Intervals -- tblDHWeathering Enhanced TR_iutblDHWeathering_Interval_Overlap Enhanced TR_iutblDHWeathering_Valid_Intervals -- tblLeases Changed Lease_Status not allow null and added default constraint -- tblLIBCompany Updated Company_Type default values to match with the column data type -- tblLIBContractType Enhanced TR_udtblLIBContractType_ReservedCodes -- Removed table tblLIBDispatchSubmissionType -- tblLIBInstrument Updated Instrument_Type default values to match with the column data type -- tblLIBMachinery Added CK constraint for Factor_Unit -- Removed TR_utblLIBMagSusFactor_Multiplication_Factor -- tblLIBPerson Added code 'NR' if not already exists Updated Person_Type default values to match with the column data type -- tblLIBReportingType Added Is_Grade -- tblLIBSampleType Added new trigger TR_udtblLIBSampleType_Code -- tblLIBStructLineationType Removed TR_utblLIBGeologyLineationType -- tblLIBStructPlaneIntensity Removed TR_utblLIBGeologyPlaneIntensity -- tblLIBStructPlaneType Removed TR_utblLIBGeologyPlaneType -- Renamed tblLIBVeinComp to tblLIBVeinCode -- Changed Site_ID length on all LS tables from 20 to 100 -- tblLSGeology Renamed Vein1_Comp to Vein1_Code and added check constraint Renamed Vein2_Comp to Vein2_Code and added check constraint Added check constraint for Vein2_pct/Vein2_Style Changed Min1_pct/Min2_pct to DECIMAL(18,2) Enhanced TR_iutblLSGeology_Interval_Overlap Enhanced TR_iutblLSGeology_Valid_Intervals Enhanced TR_utblLSGeology -- tblLSMagSus Enhanced TR_iutblLSMagSus_AveReading Enhanced TR_iutblLSMagSus_Interval_Overlap Enhanced TR_iutblLSMagSus_Valid_Intervals Enhanced TR_utblLSMagSus -- tblLSMapping Change Site_ID length from 50 to 100 Removed TR_iutblLSMapping_DataSet_Site_ID Enhanced TR_utblLSMapping -- tblLSMetaData Added FK_tblLSMetaData_tblLIBCompany_Machinery_Contractor Enhanced TR_iutblLSMetaData_Interval_Overlap Enhanced TR_iutblLSMetaData_Valid_Intervals Enhanced TR_utblLSMetaData -- tblLSMetSamp Enhanced TR_iutblLSMetSamp_Interval_Overlap Enhanced TR_iutblLSMetSamp_Valid_Intervals -- tblLSMetSampQC Changed Site_ID/Line_ID/Depth_From/Depth_To to allow null Added TR_iutblLSMetSampQC_DataSet_Orig_SampleID_SampleID Enhanced TR_iutblLSMetSampQC_Valid_Intervals -- tblLSPhoto Changed Interval_Length to be persisted Enhanced TR_iutblLSPhoto_Valid_Intervals -- tblLSSamp Enhanced TR_iutblLSSamp_Interval_Overlap Enhanced TR_iutblLSSamp_Valid_Intervals -- tblLSSampQC Changed Site_ID/Line_ID/Depth_From/Depth_To to allow null Added TR_iutblLSSampQC_DataSet_Orig_SampleID_SampleID Enhanced TR_utblLSSampQC_DataSet_Orig_SampleID_SampleID Enhanced TR_iutblLSSampQC_Valid_Intervals -- tblLSSsite Enhanced TR_udtblLSSite_Orig_Grid_Audit Enhanced TR_utblLSSite Enhanced TR_utblLSSite_Max_Length -- tblLSSiteHistory Enhanced TR_utblLSSiteHistory Changed Line_ID length from 20 to 25 Added FK_tblLSSiteHistory_tblLSSite_DataSet_Line_ID_Site_ID -- tblLSSurv Enhanced TR_iutblLSSurv_Valid_Length Added FK_tblLSSiteHistory_tblLSSite_DataSet_Line_ID_Site_ID -- New table tblLSWater -- tblPetrology Changed Min*_pct to be DECIMAL(18,2) -- Changes Site_ID length on all PT tables from 50 to 100 -- tblPTGeology Moved Terrain/Slope_Dip/Vegetation onto tblPTSite Moved Soil_Horizon onto tblPTSamp Added Vein_Code/Vein_Style/Vein_pct Added FK_tblPTGeology_tblLIBVeinCode_Vein_Code Added FK_tblPTGeology_tblLIBVeinStyle_Vein_Style Added CK_tblPTGeology_Vein_pct Changed Min_pct to DECIMAL(18,2) -- New table tblPTMagSus -- tblPTMetSamp Enhanced TR_itblPTMetSamp Enhanced TR_utblPTMetSamp_DataSet_SampleID -- tblPTMetSampQC Changed Site_ID to allow null Added TR_iutblPTMetSampQC_DataSet_Orig_SampleID_SampleID Enhanced TR_itblPTMetSampQC Enhanced TR_iutblPTMetSampQC_Orig_SampleID Enhanced TR_utblPTMetSampQC_DataSet_SampleID -- tblPTSamp Added Soil_Horizon (moved in from tblPTGeology) Enhanced TR_itblPTSamp Enhanced TR_utblPTSamp_DataSet_SampleID -- tblPTSampQC Changed Site_ID to allow null Added TR_iutblPTSampQC_DataSet_Orig_SampleID_SampleID Enhanced TR_iutblPTSampQC_Orig_SampleID Enhanced TR_itblPTSampQC Enhanced TR_utblPTSampQC_DataSet_SampleID -- tblPTSite Added Terrain/Slope_Dip/Vegetation (moved in from tblPTGeology) Enhanced TR_udtblPTSite_Orig_Grid_Audit -- New table tblPTWater -- tblRehabLS Enhanced TR_utblRehabLS -- tblSampleRegister Enhanced TR_dtblSampleRegister_SampleCheck -- tblStandardSamp Added Historic_SampleID Updated TR_iutblStandardSamp_Source_ID Enhanced TR_iutblStandardSamp_Source_ID -- tblStandardSampQC Added Historic_SampleID -- tblSYSAssDispatchDetails Updated Dispatch_Status default values to match with the column data type -- tblSYSAssDispatchGroupDetail Added Data_Source -- tblSYSAssIncomingData Updated Repeat default values to match with the column data type -- tblSYSConfigRelation Enhanced TR_itblSYSConfigRelation -- tblSYSConfigRelationField Updated FieldType default values to match with the column data type Enhanced TR_itblSYSConfigRelation -- tblSYSDSConfig Updated HasDataSet default value from 1 to 0 -- tblSYSExportLayoutField Updated TypeExt default values to match with the column data type -- tblSYSIncomingDataMasks New trigger TR_iutblSYSIncomingDataMasks_Identifier -- tblSYSParam Updated UserName default values to match with the column data type -- tblSYSQCAnalysisType Added SortOrder -- tblSYSQCReport Added IncludeLegend -- tblSYSQCSampleEvents Updated Repeat default values to match with the column data type -- tblSYSSRSCoordinateSystem Added Is_Active -- tblSYSSurpacStyles Changed From_Value to allow null -- Removed tblSYSVWAssIncomingData -- tblSYSXRFIncomingData Updated Repeat default values to match with the column data type Changed UserDefined1/UserDefined2 length from 25 to 256 Added UserDefined3/UserDefined4/UserDefined5/UserDefined6/Data_Source -- New view tblVWContractActivityLogCosts -- New view tblVWContractInvoiceCosts -- Renamed tblVWDHGeotechRMR to tblVWDHGeotechRMR_Calc -- New view tblVWDHMetStandardSamp -- New view tblVWDHStandardSamp -- New view tblVWFSMetStandardSamp -- New view tblVWFSStandardSamp -- New view tblVWLSMetStandardSamp -- New view tblVWLSStandardSamp -- New view tblVWPTStandardSamp -- New view tblVWDHMetStandardSamp -- New view tblVWPTMetStandardSamp -- Enhanced view tblVWPTGeoChemLogging -- New view tblVWPTMetStandardSamp -- Enhanced view tblVWPTSampLogging -- New view tblVWPTStandardSamp -- tblVWSites Added SourceTable column -- New view tblVWSYSAssDispatchSampleCounts -- New view tblVWSYSAssDispatchSampleStatus -- Enhanced view tblVWXRFDHResults -- New view tblVWXRFIncomingResults -- New view tblVWXRFResults -- Updated view tblVWXRFDHResults -- tblXRFDHSamp Updated TR_utblXRFDHSamp_DataSet_SampleID Added FK for Grid_ID Changed Sample_Recovery_pct to DECIMAL(18,2) Enhanced TR_iutblXRFDHSamp_Interval_Overlap -- tblXRFDHSampQC Enhanced TR_utblXRFDHSampQC_DataSet_SampleID -- tblXRFSamp Renamed Date_Sampled to Sampled_Date Added Site_ID column Removed columns already exist in tblPTSite -- tblXRFResults Changed UserDefined1/UserDefined2 length from 25 to 256 Added UserDefined3/UserDefined4/UserDefined5/UserDefined6 -- Changed Hole_ID field length from 20 to 100 -- Enhanced udf_OrientDipDirection to reflect the Hole_ID field length changed from 20 to 100 -- Enhanced usp_DepthAdjustRollBack to reflect the Hole_ID field length changed from 20 to 100 -- Enhanced usp_ProcessCombineMultipleTableColumns Reflect the Hole_ID field length changed from 20 to 100 Fixed bug with CalculatedField -- Enhanced uspIC_InterceptCalculator to reflect the Hole_ID field length changed from 20 to 100 -- Enhanced usp_DataAssayMergingProcess for better error handling -- Enhanced usp_RenameDataSetHoleSample -- Enhanced usp_ListMissingIntervals -- Enhanced usp_ProcessXRFLabChecksInComingData -- Enhancement on DAL system objects -- New SP usp_AdminConfigMDSAssembly -- Enhance usp_DataDesurvey -- Enhanced usp_RenameDataSetHoleSample -- Enhanced uspIC_RecordErrorMessage -- Enhanced DataSetHoleID data type -- New usp_DSGetColumnScale -- Added Code 'NR' to following LIB tables tblLIBAltStyle tblLIBBitType tblLIBColourCode tblLIBColourTone tblLIBContractItemCategory tblLIBContractItemCode tblLIBContractType tblLIBCurrencyCode tblLIBDepartment tblLIBDispatchStatus tblLIBDomainCode tblLIBEventCode tblLIBGeotHardness tblLIBGeotMacroRoughness tblLIBGeotShape tblLIBGeotStrength tblLIBGeotStrengthFailureMode tblLIBGeotStrengthTestType tblLIBGroutType tblLIBIncidentAction tblLIBIncidentSeverity tblLIBIncidentType tblLIBInstrument tblLIBIntensity tblLIBKinematicIndicator tblLIBLithGrainsize tblLIBLithTexture tblLIBLodeCode tblLIBMachineryCategory tblLIBMapSurface tblLIBMeetingType tblLIBMinStyle tblLIBMovementSense tblLIBOrientationPosition tblLIBOrientationQuality tblLIBOrientationType tblLIBOxidationStyle tblLIBParentCode tblLIBPetrologyType tblLIBPhotoType tblLIBPlugMaterial tblLIBPTPhotoCat tblLIBPTPhotoLocType tblLIBPTSiteType tblLIBReportingCategory tblLIBReportingDatePeriod tblLIBReportingType tblLIBShift tblLIBSiteMonitoringType tblLIBStorageActivity tblLIBStructAngleSet tblLIBStructClass tblLIBStructFillThickness tblLIBStructLineationType tblLIBStructPlaneIntensity tblLIBStructPlaneType tblLIBStructRoughness tblLIBStructType tblLIBStructWallRockCompetency tblLIBValidation tblLIBVegetation tblLIBVeinStyle tblLIBWeathCode tblLIBWeathStyle tblLIBYoungingIndicator tblLIBZoneCode --Added Image/Pattern/Colour columns to the following LIB tables tblLIBAltCode tblLIBAltStyle tblLIBColourCode tblLIBColourTone tblLIBGeotHardness tblLIBLithCode tblLIBLithGrainsize tblLIBLithTexture tblLIBMinCode tblLIBMinStyle tblLIBOxidation tblLIBOxidationStyle tblLIBParentCode tblLIBStructFillTexture tblLIBStructFillThickness tblLIBStructType tblLIBVeinStyle tblLIBWeathCode tblLIBWeathStyle --Turned update cascade on for all FKs where permitted --Changed RL columns to be DECIMAL(18,2) on following tables tblDHColl tblDHCollHistory tblDHCollPlanned tblDHModelComposite tblLSSite tblLSSiteHistory tblPTSite tblPTSiteHistory tblXRFSamp --Renamed all Date_Sampled columns to be Sampled_Date -- Lease_ID columns changed from NVARCHAR(15) to NVARCHAR(50) on following tables tblLeases.Lease_ID tblDHColl.Lease_ID tblLSSite.Lease_ID tblPTSite.Lease_ID tblSYSAssDispatchHeader.Lease_ID tblCATReportIndex.Lease tblCATPlanIndex.Lease tblXRFSamp.Lease_ID --- Following changes are for v4.6.1 and model specific: --- For Production model: -- Update tblFSPhoto.Depth_From/Depth_To to allow NULL (4 Apr 2014) Update TR_iutblFSPhoto_Valid_Intervals (4 Apr 2014) -- Enhanced insert/update triggers on the following tables to better handle situation when PK column values updated (14 Apr 2014) tblFSMetSamp tblFSMetSampQC tblFSSamp tblFSSampQC tblProdLocations tblProdSamp tblProdSampQC -- Added default constraints for Depth_From/Depth_To and updated related check constraints on following face sampling tables (30 Apr 2014) tblFSGeology tblFSMagSus tblFSMetaData tblFSMetSamp tblFSMetSampQC tblFSSamp tblFSSampQC -- tblFSGeology Renamed Vein1_Comp to Vein1_Code and added check constraint Renamed Vein2_Comp to Vein2_Code and added check constraint Added check constraint for Vein2_pct/Vein2_Style Changed Min1_pct/Min2_pct to DECIMAL(18,2) Added FK for Grid_ID -- tblFSMagSus Enabled FK_tblFSMagSus_tblLIBMagSusFactor_Instrument_FactorCode on update cascade Enhanced TR_iutblFSMagSus_Interval_Overlap Enhanced TR_iutblFSMagSus_AveReading -- tblFSMapping Removed TR_iutblFSMapping_DataSet_Site_ID Updated TR_utblFSMapping -- tblFSMetaData Added Date_Started, Date_Completed Removed Mapped_Date, Mapped_By -- tblFSMetSamp Enhanced TR_iutblFSMetSamp_Interval_Overlap Enhanced TR_iutblFSMetSamp_Valid_Intervals -- tblFSMetSampQC Removed DF_tblFSMetSampQC_Depth_From / DF_tblFSMetSampQC_Depth_To Enhanced TR_iutblFSMetSampQC_Valid_Intervals -- tblFSPhoto Enhanced TR_iutblFSPhoto_Valid_Intervals -- tblFSSamp Enhanced TR_iutblFSSamp_Interval_Overlap Enhanced TR_iutblFSSamp_Valid_Intervals -- tblFSSampQC Removed DF_tblFSSampQC_Depth_From / DF_tblFSSampQC_Depth_To Added TR_iutblFSSampQC_DataSet_Orig_SampleID_SampleID Enhanced TR_iutblFSSampQC_Valid_Intervals -- tblFSSite Enhanced TR_udtblFSSite_Orig_Grid_Audit Lease_ID column changed to NVARCHAR(50) -- tblFSSiteHistory Updated TR_utblFSSiteHistory Added FK_tblFSSiteHistory_tblFSSite_DataSet_Line_ID_Site_ID -- tblFSSurv Renamed column DHSurvey_Method to Survey_Method (30 Apr 2014) Renamed column DHSurvey_Company to Survey_Company (30 Apr 2014) Renamed column DHSurvey_Operator to Survey_Operator (30 Apr 2014) Renamed column DHSurvey_Instrument to Survey_Instrument (30 Apr 2014) Dropped constraint FK_tblFSSurv_tblLIBDHSurveyMethod_DHSurvey_Method (30 Apr 2014) New constraint FK_tblFSSurv_tblLIBSurveyMethod_Survey_Method (30 Apr 2014) Enhanced TR_iutblFSSurv_Valid_Depth -- New tblFSWater table -- Enhancements on tblFSSite and related FS tables (11 Jun 2014) Changed Site_ID to be nvarchar(100) NOT NULL Updated PK column order Updated relevant triggers to reflect above changes -- Enhancements on tblFSMapping (11 Jun 2014) Added Line_ID Added Depth_From Added Depth_To -- Changed Face_Number/Drive_ID on tblFSSite to allow NULL (30 Apr 2014) -- New table tblLIBProdBlockStatus -- New table tblLIBProdExplosiveType -- tblLIBProdGradeCategory Removed 'NR' code from the table Added Code_Group -- New table tblLIBProdGradeCategoryGroup -- tblLIBProdModelName Added 'NA' code -- tblLIBProdOreType Removed IX_tblLIBProdOreType_Material_Type_Commodity_Grade_Category -- New table tblLIBProdTonnageType -- New table tblLIBProdWeightometerName -- tblProdBlasting Added Bench_RL/Burden/Spacing/Average_Hole_Depth/Number_of_Holes/Total_Hole_Depth/Explosive_Type/Explosive_Mass/Explosive_Mass_unitCode/Powder_Factor -- tblProdBlock Changed SG to not null and added default constraint Added Block_Status -- tblProdBlockCommodities Renamed Commodity_Grade to Mined_Grade Renamed Commodity_Grade_Unit to Mined_Grade_Unit Renamed Commodity_Grade_Quantity to Mined_Grade_Quantity Renamed Commodity_Grade_Quantity_Unit to Mined_Grade_Quantity_Unit Renamed Commodity_Grade_Cut_Off to Mined_Grade_Cut_Off Renamed Planned_Value to Mined_Value Renamed Planned_Unit to Mined_Unit Added FK for Mined_Grade_Unit/Mined_Grade_Quantity_Unit/Mined_Unit Added FC_SG/Mined_Grade_Category/FC_Grade/FC_Grade_Unit Added IX_tblProdBlockCommodities_BlockID_IsPrimary Changed Mined_Grade to allow null Added CK for FC_Grade_Unit/Mined_Grade_Unit -- tblProdBlockPlanned Added IX_tblProdBlockPlanned_BlockID_IsPrimary Added CK_tblProdBlockPlanned_Planned_Grade_Unit Changed Planned_Grade_Unit to not null with default 'G/T' -- New table tblProdBottleRollResults -- tblProdDailyTrucking Added FK_tblProdDailyTrucking_tblLIBCompany_Contractor Added IX_tblProdDailyTrucking_Trucking_Date Added Movement_Code -- tblProdEOMActualsStockpiles Changed Surved_SG to not null with default '1' -- Removed table tblProdLocationsActuals (if not already has data) -- Removed table tblProdLocationsBalance (if not already has data) -- tblProdMaterialMovement Added FK_tblProdMaterialMovement_tblLIBCompany_Contractor Added Movement_SG/EquipmentID/Contractor/Movement_Code/Tonnage_Type/Tonnage_Calculated Changed Movement_Value to not null Added IX_tblProdMaterialMovement_Movement_Date_LocationID_From Added IX_tblProdMaterialMovement_Movement_Date_LocationID_To Changed PK -- tblProdProcessing Renamed Ore_Tonnes to Tonnage Changed PK -- Removed tblProdReconciliation (if not already has data) -- New table tblProdReporting -- tblProdSamp Added DataSet -- tblProdSampQC Added DataSet -- tblProdSurveyAdjusted Changed Surved_SG to not null with default '1' -- tblProdWeightometer Added Weightometer_Name/Weightometer_Shift/Moisture_Content/Crushed_Operation_Time/Movement_Code/Curshed_Throughput Renamed Crushed_Tonnes_Wet to Tonnage Removed Tonnes_To_Bin (if not already has data) Changed PK -- Updated view tblVWFSMaxAssays (30 Apr 2014) -- New view tblVWProdSamp (30 Apr 2014) -- Removed FK_tblProdDailyTrucking_tblLIBMachinery_Contractor_Digger_No (30 Apr 2014) -- New view tblVWProdEOMSurvey (30 Apr 2014) -- New view tblVWProdProcessingMonthly (30 Apr 2014) -- New view tblVWProdReconciliationPlanned (30 Apr 2014) -- New view tblVWProdReconciliationReserve (30 Apr 2014) -- New view tblVWProdRptReconciliation (30 Apr 2014) -- New view tblVWProdRptReconPlanned (30 Apr 2014) -- New view tblVWProdRptReconReserve (30 Apr 2014) -- New view tblVWProdStockPileSummary (30 Apr 2014) -- New view tblVWProdSurveyTotals (30 Apr 2014) -- New view tblVWProdSurveyTrucking (30 Apr 2014) -- New view tblVWProdTruckingCalculated (30 Apr 2014) -- New view tblVWProdTruckingClaimed (30 Apr 2014) -- New view tblVWProdTruckingMonthly (30 Apr 2014) -- New view tblVWProdTruckingSurveyRpt (30 Apr 2014) -- New view tblVWProdAssays (6 May 2014) -- New view tblVWProdAssaysQC (6 May 2014) -- New view tblVWProdSampQC (6 May 2014) -- New FK FK_tblProdBlock_tblLIBMineLevel_Level (6 May 2014) -- Changed Site_ID on all face sampling tables to be NVARCHAR(100) NOT NULL (16 Jun 2014) -- Changed BlockID length from 25 to 50 on the following tables tblProdBlock tblProdDailyTrucking tblProdBlockPlanned tblProdBlockCommodities tblProdBlasting -- Change LocationID length on all Prod tables from 25 to 100 -- Added DataSet column on the following tables tblProdSamp tblProdSampQC -- New udf_ProdLocationCurrentBalance -- New udf_ProdLocationCurrentBalance_MovementCode -- New udf_ProdLocationrunningBalance -- New udf_ProdLocationRunningBalance_MovementCode -- New utf_ProdReporting -- New veiw tblVWProdBlockMerged -- New veiw tblVWProdDailyCrushedTotal -- New veiw tblVWProdDailyMaterial_From -- New veiw tblVWProdDailyMaterial_To -- New veiw tblVWProdDailyMovement -- New veiw tblVWProdLocationBalance -- New veiw tblVWProdMinedDailyGradeCategory -- New veiw tblVWProdMovementBalActual -- New veiw tblVWProdMovementBalConditioned -- New veiw tblVWProdMovementBalUnion -- Enhanced veiw tblVWProdProcessingMonthly -- Removed view tblVWProdReconciliationPlanned -- Removed view tblVWProdReconciliationReserve -- Removed view tblVWProdRptReconciliation -- Removed view tblVWProdRptReconPlanned -- Removed view tblVWProdRptReconReserve -- Removed view tblVWProdSampQC -- New view tblVWProdStockpileBal_EOMDate -- New view tblVWProdStockpileBalMeasured -- Enhanced view tblVWProdStockPileSummary -- Enhanced view tblVWProdTruckingCalculated -- Added Code 'NR' to following LIB tables tblLIBProdBench tblLIBProdBlastType tblLIBProdBlockGroup tblLIBProdBlockSource tblLIBProdBlockStatus tblLIBProdBlockType tblLIBProdExplosiveType tblLIBProdLocationGroup tblLIBProdLocationType tblLIBProdMillProcessingRpt tblLIBProdMonitoringType tblLIBProdMovementType tblLIBProdSlopeBenchID tblLIBProdSlopeDesignPractice tblLIBProdSlopeEventFactors tblLIBProdSlopeEventImpact tblLIBProdSlopeEventType tblLIBProdSlopeFailureMode tblLIBProdSlopeHazardRating tblLIBProdSlopeHazardType tblLIBProdSlopeSupportDesign tblLIBProdSlopeSupportType tblLIBProdSurveyType tblLIBProdTonnageType tblLIBDriveID tblLIBFaceType tblLIBMineLevel tblLIBSurveyPoint --Changed RL columns to be DECIMAL(18,2) on following tables tblProdBlasting tblFSSite tblFSSiteHistory For Non-Production models -- Removed table tblLIBDriveID from all MDS models except Production -- Removed table tblLIBFaceType from all MDS models except Production -- Removed table tblLIBMineLevel from all MDS models except Production -- Removed table tblLIBSurveyPoint from all MDS models except Production