Table Descriptions

Table Name	Description
ALTERATION_INTENSITY	Built-in Alteration Intensity Reference Table
ALTERATION_STYLE	Built-in Alteration Style Reference Table
ALTERATION_TYPE	Built-in Alteration Type Reference Table
ANALYTICAL_FLOW	Analytical flows configured with size fractions
ANALYTICAL_FLOW_DENSITY_PKGS	Density Packages configured with size fractions
ANALYTICAL_FLOW_LAB_PACKAGES	Analytical Flows configured for lab packages (used with the size fraction module)
ANALYTICAL_FLOW_PREP_PACKAGES	Preparation packages configured for lab packages (used with the size fraction module)
ANALYTICAL_METHODS	Reference table used to store all lab analytical methods (FA, AA, MS, etc.)
ASSAY_SAMPLE_TYPE	Reference table used to store sample types (Original, DUP, Split, etc.)
ASSAY_STANDARD_DEFAULTS	This table contains the limits defined for each element for a given standard (min/max, standard deviation)
ASSAY_STANDARD_RESULTS	Used to store the standard analysis values in normalized form
ASSAY_STANDARD_VALIDATION_RULE	Used to store the validation rules for each element/method code/unit of measure combination
ASSAY_STANDARDS	Used to store the various standard codes defined in the Fusion database
ASSAY_UNIT_OF_MEASURE	Used to store all of the units of measure for assay columns (ppm, ppb, gpt, etc.)
AUDIT_COMP_SAMPLES	Used to track audit information related to composite sampling
AUDIT_DHL_SAMPLES	Used to store audit records for original and duplicate sampling
AUDIT_SSTN_RESULTS	Used to store audit records for surface sample results
AUDIT_SSTN_SAMPLES	Used to store audit records for surface samples in general
AUDIT_STANDARDS	Used to store audit records for standards
BUSINESS_UNIT	Used to store business unit information
BUSINESS_UNIT_COLUMN_SETTINGS	Used with business unit preference module (to assign different rules for business units).
BUSINESS_UNIT_COORDINATE_RANK	Used with business unit preference module (to assign different rules for business units).
BUSINESS_UNIT_EMAIL_NOTIFY	Used with business unit preference module (to assign different rules for business units).
BUSINESS_UNIT_EMAIL_RECIPIENTS	Used with business unit preference module (to assign different rules for business units).
BUSINESS_UNIT_PREFERENCES	Used with business unit preference module (to assign different rules for business units).
BUSINESS_UNIT_SAMPLE_SETTINGS	Used with business unit preference module (to assign different rules for business units).
BUSINESS_UNIT_TABLE_SETTINGS	Used with business unit preference module (to assign different rules for business units).
BUSINESS_UNIT_TEST_TYPE_RANK	Used with business unit preference module (to assign different rules for business units).
CASING_TYPE	Reference table of Casing types
COLUMNS_SAMPLE_TYPE	Used to store the assay column to business unit associations
COLUMNS_SAMPLE_TYPE_COMPOSITE	Links composite columns to a business unit
common_audit_items	Stores audit information for lab imports
common_backup_schedule	Stores local database scheduled backup info
common_company_category	Stores company info used with dispatch report
common_company_details	Stores company info used with dispatch report
common_composite_style	Used to store information for automated composites
COMMON_FILE_DATA	Used to store coordinate blob data (datums, transformations between grids). Also used to store the FusionX Local database template
common_location_codes	Used to store reference data for Sample Station Location Tree (child nodes)
common_location_header	Used to store reference data for Sample Station Location Tree (header nodes)
COMMON_SELECTED_OBJECTS	System table used to handle check in / check out security (lock objects that are in use)
COMMON_SQL_STATEMENTS	System table used for distributed database upgrades and configuration changes (stores SQL commands)
COMMON_STANDARDS_FAILURES	Stores a list of standards that have failed on import
common_table_defaults	Used to store pick list default values for the built-In reference tables such as Alteration, Mineralization
CONTRACTOR	Reference table of contractors
COORDINATE_TYPE	Reference table of different coordinate types
CORE_PHOTO_STORAGE_LOCATION	Used to store the default path where core photos will be stored when uploaded or transferred via checkin/checkout
CORE_STORAGE	Reference table for core storage options
CURRENT_DRILLHOLE	System table for drill hole control
CUSTOM_COMP_SAMPLE_DEFINITION	Sample definitions for custom composite sample columns
CUSTOM_EXPORT_DESIGN	Stores the data configured to display the menus for custom exports created in Fusion Connex
CUSTOM_IMPORT_MAPPINGS	Custom import mappings used with the LAS module
CUSTOM_IMPORT_TEMPLATE	Custom import templates used with the LAS module
custom_sample_definition	System table used to store assay column definitions
CV_POLYGON_POINTS	Stores the polygons points from the shape file imported to validate coordinates
CV_POLYGONS	Stores the polygons from the shape file imported to validate coordinates
CV_PROJECT_POLYGONS	Stores de polygon relationship with the project number to validate coordinates
cv_shp_import	Stores the shape file name and the grid assigned
DATABASE_LOCATION	Used to store generic information regarding the database's physical location
database_profile	Stores information about the database type (Local, Fusion Remote, or Central)
DATABASE_STATUS	Stores the status of a database
DATABASE_VERSION	Used to store database version info for all applications
db_lic_id	Referenced by the database licensing module
DENSITY_PACKAGE	Stores the density package information for the Density module
DENSITY_PACKAGE_DETAILS	Stores the density package detail information for the Density module
DEPTH_ADJUST_HOLE_TYPE	Store depth adjustment definitions per hole type information
DEPTH_ADJUST_TEMPLATE	Store depth adjustment template definitions
DEPTH_ADJUST_TEMPLATE_DETAILS	Store depth adjustment template details definitions
descriptor	Legacy table no longer in use in any application
descriptor_category	Legacy table no longer in use in any application
dhl_action_list	Legacy table used to track latest export actions
dhl_action_reason	Reference table used to store the various audit reasons for actions such as deleting holes, authorizing holes/samples
dhl_audit_logging	Main audit table in the Fusion database to track drill hole deletes and authorization
dhl_business_unit_projects	Stores info for projects associated to Business Units
DHL_BLAST_HOLE	Used to store blast hole header information
dhl_composite_cutoff_defaults	Stores info for built-in compositor cut-off defaults
dhl_composite_cutoff_values	Stores info for built-in compositor cut-off values
dhl_composite_values	Stores values generated with the built-in compositor module
DHL_CONTRACT	Contract information for Drill Costing Module
DHL_COST_CATEGORY	Cost category information for Drill Costing Module
DHL_COST_ITEM	Cost item information for Drill Costing Module
DHL_COST_ITEM_DEPTHS	Cost items by depth for Drill Costing Module
DHL_COST_TYPE	Cost type information for Drill Costing Module
DHL_COST_UNIT	Cost Unit information for Drill Costing Module
dhl_dispatch_pulps	Stores pulp instructions for Sample Dispatch
dhl_dispatch_rejects	Stores reject instructions for Sample Dispatch
dhl_downhole_data	Stores values calculated when a hole is de-surveyed
DHL_DRILL_COST_LINE_ITEM	Drill costing line item from Drill Costing Module
dhl_hole_type_generation	Stores information for drill hole generator
dhl_image_import	Legacy table (not referenced)
dhl_import_action_reason	Reference table storing reasons for actions on lab symbols (below / above detection)
dhl_import_symbol	Reference table storing lab symbols used in lab files (>, <, -, etc.)
dhl_import_***	Other tables prefixed with "dhl_import_" are used to perform table/column level validation when importing data using the Drill Hole Import tool
DHL_INSTRUMENT_CONFIGURATION	Used to store information related to an instrument being used to capture data into DHLogger (for example, a scale)
DHL_INSTRUMENT_DATA_CONFIGURATION	Used to store parsing information for instruments
DHL_ITEM_CLASS	Item class for Drill Costing Module
DHL_ITEM_FUNCTION	Item function for Drill Costing Module
DHL_LAB_IMPORT_SUMMARY	Stores the import summary information for all lab imports (ASSAY CSV)
DHL_LAS_DATA	Used to store raw LAS data
DHL_LAS_FINAL_DATA	Used to store final/reviewed LAS data
DHL_LAS_HEADER	Used to store LAS header information
DHL_LAS_RAW_FILES	Used to store LAS raw files
DHL_LAS_SCINT_DATA	Used to store LAS scintillometer data
DHL_LAS_SCINT_HEADER	Used to store LAS scintillometer header information
dhl_logging_style	Used to store logging style information
dhl_logging_style_sample_type	Maps sample types to logging styles
dhl_logging_style_tabs	Used to associate data tables to logging styles
DHL_PLANNED_DH_NAMING_TEMPLATE	Used to store information associated to planned drill hole naming templates
DHL_PLANNED_DRILLHOLES	Stores planned drill holes
DHL_PREP_CODES	Stores preparation codes - legacy table
dhl_project_sample_counts	Stores info for QC sample insertion by project
dhl_qc_header	Stores QC Package names - for drill hole sample generator
dhl_qc_package	Stores QC Package Info - for drill hole sample generator
DHL_QC_PACKAGE_BLOCK_CONTROL	Stores QC Package Block control option configuration (DUPS, Standards, etc.)
dhl_qc_package_details	Stores QC Package details - for drill hole generator
dhl_qc_package_projects	Links QC Packages to projects - for drill hole generator
dhl_qc_samples	Stores QC Samples in QC Packages - for drill hole generator
DHL_SAMPLE_COLUMN_DETAILS	Stores Historical Normalized Assay Results - QAQC Included
DHL_SAMPLE_DISPATCH_ERROR	Stores error information related to the dispatch module
DHL_SAMPLE_DISPATCH_HEADER	Stores header details for sample dispatches
DHL_SAMPLE_DISPATCH_SAMPLES	Stores details for samples in dispatch (sample associations)
DHL_SAMPLE_DISPATCH_TEMPLATES	Stores sample dispatch template information
DHL_SAMPLE_INVOICE	Stores lab invoice names
DHL_SAMPLE_INVOICE_DETAILS	Stores lab invoice details
DHL_TABLE_SORT	Used to store the order of tables in the Details screen in DHLogger
DHL_TABLE_WIDTHS	Used to store the columns widths for each data table in DHLogger
dhl_template	System table storing table template information
dhl_template_columns	System table storing column information for table templates
dhl_unit_conversions	System table for unit conversions
dhl_user_logging_style	System table storing logging styles associated to the various user accounts
DISPATCH_NAME_DETAIL_PROJECT	Used to store dispatch template naming details
DISPATCH_NAMING_DETAILS	Stores the configuration information for the dispatch naming tool
DRILL_HOLE	Collar information (main drill hole collar table)
DRILL_HOLE_COORDINATE	Collar X, Y, Z information (main coordinate table)
DRILL_HOLE_CORE_PHOTOS	Used to store information related to core photos that have been imported in DHLogger
DRILL_HOLE_DIRECTION	Downhole Survey Information (main survey table)
DRILL_HOLE_MAG_SUS	Built-in Magnetic Susceptibility Table
drill_hole_object_status	Stores the status per each drill hole table when the selective transfer module is enabled
DRILL_HOLE_ROCK_QUALITY	Built-in RQD Table
drill_hole_sketch	System table storing drawings from graphic/strip log
dtproperties	System table
ELEMENT_MAPPING	Element mapping information for lab packages
ELEMENT_TYPE	Reference table of all elements - Au, Ag, etc.
EMAIL_NOTIFICATION	Stores information regarding auto email notifications
EMAIL_NOTIFICATION_RECIPIENTS	Stores information regarding user email addresses
EMAIL_NOTIFICATION_TYPE	Stores information regarding the email notification type
EMAIL_SEND_LIST	Stores information regarding the email recipients
FUSION_DATABASE_IDENTIFICATION	Used to store a unique database ID associated to all client databases
FUSION_EVENT_LOG	Used to log events with the Fusion API
FUSION_MODIFIED_TABLES	Used to determine if a specific table has been updated by users (helps with data transfer performance)
graphic_log_preferences	Stores preferences for the graphic log
GRID_CATEGORY	Reference table of grid category codes
GRID_CONVERSION	Reference table storing grid conversion information
GRID_TYPE	Reference table storing grid types
HOLE_ALTERATION	Built-in Alteration table
HOLE_ASSAY_AVERAGES	Stores calculated averages from the assay worksheet
HOLE_ASSAY_DEFAULT_RESULTS	Stores column definitions for drill hole assays
HOLE_ASSAY_SAMPLE	Stores non-normalized assay results (latest batch)
HOLE_ASSAY_SAMPLE_STATUS	Reference table used to store all sample statuses
HOLE_ASSAY_STANDARDS	Used to store standard codes associated to drill holes
HOLE_COMPOSITE_AVERAGES	Used to store averages specific to the composite module
HOLE_COMPOSITE_DEFAULT_RESULTS	Used to store default values configured in the composite module
HOLE_COMPOSITE_SAMPLE	Used to store composite samples
HOLE_COMPOSITE_SAMPLE_RAW	Used to the store the raw samples used to generate the composite
HOLE_INTERVAL	Stores the Lithology records - From, To, Rock Type (main Lithology table)
HOLE_LOCATION	Reference table for built-in collar location field
HOLE_MINERALIZATION	Built-in Mineralization tab
HOLE_SIZE	Reference table used to store hole sizes - BQ, NQ, etc.
HOLE_STRUCTURE	Built-in Structure tab
HOLE_TEXTURE	Built-in Texture tab
HOLE_TYPE	Reference table used to store hole types - DD, CHA, etc.
HOLENAMING_DETAILS	Stores the details for the drill hole naming template configuration
HOLENAMING_TEMPLATE	Stores the information for the drill hole naming template configuration
LAB_ASSAY_DEFINITION	Legacy table no longer in use in any application
LAB_PACKAGE	Used to store lab package/analysis configuration information (i.e. AA24, MS61, etc.)
lab_package_import_logic	Stores import logic info for handling lab repeats
LAB_PACKAGE_SAMPLE_TYPE	Stores sample type mapping for lab import - lab repeats, standards, dups
LABIMPORT_TEMPLATE	Used to store custom lab import template information
LABORATORY	Used to store main lab info (SGS, ALS, etc.)
LABORATORY_ANALYTICAL_DETAILS	Stores lab package details (element mappings)
LAS_EQUIP_CALIBRATION_FILES	Used to store LAS calibration file data
LAS_EQUIPMENT_CALIBRATION	Used to store LAS equipment calibration information
LAS_EQUIPMENT_CATEGORY	Used to store LAS equipment categories
LAS_HEADER_RIG	Used to store LAS rig information
list_versions	Stores refresh list version information for synchronization (used to track if updated have been made)
METAL_PRICES	Reference table storing metal prices
MINE	Legacy table no longer in use in any application
MINERALIZATION_STYLE	Built-in reference table for Mineralization Styles
MINERALIZATION_TYPE	Built-in reference table for Mineralization Types
MM_DXF_CLIENT	Stores MINEMAPPER 3D DXF Import templates
MM_LOGGING_STYLE	Stores the Logging Style definitions in Minemapper 3D
MM_LOGGING_STYLE_SAMPLE_TYPE	Stores the relationship between sample type and logging style in MineMapper 3D
MM_MAP	Stores Map names and header information for MineMapper 3D
MM_MAP_CAMERA	Stores camera positions for MineMapper 3D
MM_MAP_DRAWING	Stores MineMapper 3D Drawing information
MM_MAP_LOCATION	Stores MineMapper 3D Location information
MM_MAP_OBJECT	Stores MineMapper 3D Object information
MM_MAP_OBJECT_POINT	Stores MineMapper 3D Object Point information
MM_MAP_OBJECT_TYPE	Stores MineMapper 3D Object Type information
MM_MAP_OBJECT_TYPE_FORMULA	Stores MineMapper 3D Object Type Formula information
MM_PICTURE	Stores MineMapper 3D Picture
MM_REPORT_DATA	Stores MineMapper 3D Report Data
MM_STATION	Stores MineMapper 3D Survey Station Information
MM_SYMBOL_POINTS	Stores MineMapper 3D Symbol Point Information
MM_SYMBOL_STYLE	Stores MineMapper 3D Symbol Style Information
MM_USER_LOGGING_STYLE	Stores the relationship between users and logging style in MineMapper 3D
MM_VEIN_PATH	Stores MineMapper 3D Vein Path Information - Not in use
MMA_ALTERACION	Stores MineMapper 3D Alteration Object Definition
MMA_GEOTECHNICO	Stores MineMapper 3D Geotechnical Object Definition
MMA_LITOLOGIA	Stores MineMapper 3D Lithology Object Definition
MMA_MINERALIZACION	Stores MineMapper 3D Mineralization Object Definition
MMA_OXIDACION	Stores MineMapper 3D Oxidation Object Definition
MMA_STRUCTURE	Stores MineMapper 3D Structure Object Definition
MMA_ZONAESTRUCTURA	Stores MineMapper 3D Structure Zone Object Definition
next_custom_id	System table used to assign ID's to rows inserted into certain data tables
next_interval_id	System table used to track the next ID assignment for new rows inserted in to data tables
NEXT_NUMBER	System table used to generate the next hole number
next_sample_id	System table used to generate the next sample number in sequence
pbcatcol	System table used to control user access to certain windows / modules in the various Fusion applications
pbcatedt	System table used to control user access to certain windows / modules in the various Fusion applications
pbcatfmt	System table used to control user access to certain windows / modules in the various Fusion applications
pbcattbl	System table used to control user access to certain windows / modules in the various Fusion applications
pbcatvld	System table used to control user access to certain windows / modules in the various Fusion applications
PENDING_CHECK_INS	System table used to track object checkins (samples / drill holes)
PENDING_CHECK_OUTS	System table used to track object checkouts (samples / drill holes)
PERCENT_LIST	System table used to control user access to certain windows / modules in the various Fusion applications
pfapp	System table used to control user access to certain windows / modules in the various Fusion applications
pfapp_role	System table used to control user access to certain windows / modules in the various Fusion applications
pfcontrol	System table used to control user access to certain windows / modules in the various Fusion applications
pferrorlog	System table used to control user access to certain windows / modules in the various Fusion applications
pferrormsg	System table used to control user access to certain windows / modules in the various Fusion applications
pfprof	System table used to control user access to certain windows / modules in the various Fusion applications
pfprof_col	System table used to control user access to certain windows / modules in the various Fusion applications
pfprof_ctrl	System table used to control user access to certain windows / modules in the various Fusion applications
pfprof_win	System table used to control user access to certain windows / modules in the various Fusion applications
pfsec_col	System table used to control user access to certain windows / modules in the various Fusion applications
pfsec_db	System table used to control user access to certain windows / modules in the various Fusion applications
pfuser	System table used to control user access to certain windows / modules in the various Fusion applications
pfuser_col	System table used to control user access to certain windows / modules in the various Fusion applications
pfuser_ctrl	System table used to control user access to certain windows / modules in the various Fusion applications
pfuser_db	System table used to control user access to certain windows / modules in the various Fusion applications
pfuser_pref	System table used to control user access to certain windows / modules in the various Fusion applications
pfuser_prof	System table used to control user access to certain windows / modules in the various Fusion applications
pfuser_win	System table used to control user access to certain windows / modules in the various Fusion applications
pfwindow	System table used to control user access to certain windows / modules in the various Fusion applications
PHRASES	Reference table used to store common phrases for the collar comments field
PREFERENCES	Tables used to store the various system preference triggers (enabled or disbled)
PREPARATION_PACKAGE	Store the preparation information for sample dispatch data
PREPARATION_PACKAGE_DETAILS	Store the preparation details for sample dispatch data
PROJECT	Reference table storing project information
PROJECT_DETAILS	Stores the project details data
QC_STATUS_CHANGE	Used to store the sample status change options (for QPs in the batch authorization module)
QRM_ACTIVITIES	Legacy Report Manager table - no longer referenced
QRM_ACTIVITY_DETAILS	Legacy Report Manager table - no longer referenced
QRM_CHARTS	Legacy Report Manager table - no longer referenced
QRM_CHARTS_TEMPLATES	Legacy Report Manager table - no longer referenced
REF_***	Table prefixed with "REF_" are custom reference tables (pick lists / legends) created in Fusion Administrator. Examples: REF_COLOR, REF_ALTERATION_TYPE
REFERENCE_CODE_ASSIGNMENTS	Used to store reference code assignments to business units (show/hide pick list codes)
REFERENCE_CODE_SHARING	System table controlling sharing of reference tables in apps (DHLogger / MineMapper 3D)
region	Reference table used to store regions configured for Sample Station (grab sampling)
report_columns	Used to store columns selected for the graphic log
report_header_footer	Used to store header / paging information for the graphic log
report_result_grade_colours	Used to store grade colour assignments for assay columns in the graphic log
RM_ACTIVITY	Used to information related to activities that are created in Report Manager
RM_CHARTS	Used to information related to QAQC charts that are created in Report Manager
RM_CHARTS_ACTIVITIES	Used to store charts associated to activities in Report Manager
RM_DASHBOARD	Used to information related to dashboards that are created in Report Manager
RM_DASHBOARD_ITEM	Used to store items assigned to dashboards in Report Manager
RM_DATABASE_REPORT	Used to store preferences for reports that are created in Report Manager
RM_EXPORT	Used to store information related to custom exports created in Report Manager
RM_EXPORT_ITEM	Used to store the various queries assigned to the exports in Report Manager
RM_EXPORT_QUEUE	Used to store user ID and output path information when running a custom export created in Report Manager
RM_FOLDER_LOCATION	Used to store information related to custom folders created in Report Manager
RM_JOB_ITEM	Used to store information related to scheduled jobs in Report Manager
RM_JOBS	Used to store header information for each job created in Report Manager
RM_LAYOUT	Used to store the various dashboard layouts available in Report Manager
RM_LOGS	Used to store a history of all issues/errors that can occur in Report Manager (for troubleshooting purposes)
RM_OBJECT_BUS_UNIT	Used to keep track of objects assigned to business units in Report Manager (visibility / security)
RM_QUERY	Used to store all information related to queries created in Report Manager
RM_REF_INTOUCH_QUERY	Used to store the queries to extract the data from the Fusion database which is then passed on to the InTouch widget (visualizer)
RM_REPORT	Used to store header information related to reports saved in Report Manager
RM_REPORT_ITEM	Used to store the various items assigned to the reports (charts, activities, queries, etc.)
RM_TEXT	Used to store static text which can be assigned to a report created in Report Manager
RM_WIDGET	Used to store information related to widgets that are created in Report Manager
ROCK_TYPE	Reference table storing rock codes
ROCK_TYPE_CATEGORY	Stores Categories for Rock types (if hierarchy used)
SAMPLE_MODULES	System table used to store sample module information
SAMPLE_PRIORITY	Stores the sample priority options reference in the sample dispatch module
sample_station_dimension	Reference table for Sample Dimensions - point, line, etc.
SAMPLE_STATION_MEDIUM	Reference table used to store Medium types for grab sampling - air, water, rock, etc.
sample_type	Legacy table - reference table storing sample types
SAMPLENAMING_DETAILS	Used to store the drill hole sample naming details
SAMPLENAMING_TEMPLATE	Used to store the drill hole sample naming template information
SAMPLENAMING_TEMPLATE_SAMPTYPE	Used to store the sample types assigned to templates
SFR_VIEW_COLUMNS	Store how the columns are seen in Size fraction module
SFR_VIEW_SCREEN_SIZE	Store the screen size in the Size fraction module
SFR_VIEWS	Store the size fraction views data
sstn_column_maintenance	Used to store sample station column definitions for the Header and Results tables
sstn_columns_sample_type	Used to store sample column assignments to business units
sstn_custom_sample_definition	Stores the definitions of the surface sample assay columns
sstn_import_***	Tables prefixed with "sstn_import_" are used to perform table/column level validation when importing data using the Sample Station Import tool
sstn_logging_style	Used to store sample station logging style information
sstn_logging_style_sample_type	Used to store samples types assigned to the various logging styles
sstn_logging_style_tabs	Used to store the various tables assigned to the sample station logging styles
sstn_sample_coordinate	Main coordinate table for surface samples
sstn_sample_results	Stores real-time sample results
SSTN_SURFACE_SAMPLE_AVERAGES	Used to store averages for a range of grab samples
sstn_surface_samples	Used to store the surface sample header information
sstn_user_logging_style	Used to track the logging styles assigned to the various users
STRUCTURE_TYPE	Built-in Reference table for Structure Types
TABLE_COLUMN_ASSIGNMENTS	Used to track the visibility of columns for all data tables per logging style (if the preference is enabled)
TABLE_COLUMN_MAPPING	Stores table mapping information - Table Mapper Tool
TABLE_LINKING_CONFIG	Used to store configuration related to tables that are linked (using the Table Linking feature)
TABLE_LINKING_DEFAULT_CONFIG	Used to store defaults for required pick lists when using the Table Linking feature
TABLE_MAPPING	Stores table mapping information - Table Mapper Tool
TABLE_MAPPING_GROUP	Stores table mapping information - Table Mapper Tool
temp_interval_descriptor	Legacy table - no longer in use
TEST_TYPE	Reference table used to store survey instrument types (Reflex, EZ-Gyro, etc.)
TEXTURE_TYPE	Built-in Reference table for Texture Types
UDEF_***	All tables prefixed with "UDEF_" are custom tables added and managed using Fusion Administrator. Examples include: alteration, structure, veins, etc.
UNIT_OF_DEGREE	Reference table storing Measurement type - Degree, Decimal
UNIT_OF_MEASURE	Reference table storing units - METRIC, IMPERIAL
USER_BUSINESS_UNIT	Used to store the business unit assignments to the individual user accounts
USER_DEFINED_TABLE	Used to store meta data related to MineMapper 3D data tables
USER_DEFINED_TABLE_COLUMN	Used to store meta data related to MineMapper 3D columns
USER_DEFINED_TABLE_COLUMNS	Used to store meta data related to Drill Hole columns
USER_DEFINED_TABLE_NAME	Used to store meta data related to Drill Hole data tables
USER_DEFINED_TABLE_OBJECTS	Used to store collar and dispatch visual layout properties
User_Preferences	Used to store the various user preferences and their associated status (active or inactive)
VALIDATION_RULES	Used to store all criteria associated to validation rules
VALIDATION_RULES_GROUP	Used to store information related to validation rule groups
VALIDATION_RULES_GROUP_ASSOCATION	Used to store validation rules assigned to the validation groups
WEDGE	Built-in drill hole Wedge data table

ALTERATION_INTENSITY

Built-in Alteration Intensity Reference Table

ALTERATION_STYLE

Built-in Alteration Style Reference Table

ALTERATION_TYPE

Built-in Alteration Type Reference Table

ANALYTICAL_FLOW

Analytical flows configured with size fractions

ANALYTICAL_FLOW_DENSITY_PKGS

Density Packages configured with size fractions

ANALYTICAL_FLOW_LAB_PACKAGES

Analytical Flows configured for lab packages (used with the size fraction module)

ANALYTICAL_FLOW_PREP_PACKAGES

Preparation packages configured for lab packages (used with the size fraction module)

ANALYTICAL_METHODS

Reference table used to store all lab analytical methods (FA, AA, MS, etc.)

ASSAY_SAMPLE_TYPE

Reference table used to store sample types (Original, DUP, Split, etc.)

ASSAY_STANDARD_DEFAULTS

This table contains the limits defined for each element for a given standard (min/max, standard deviation)

ASSAY_STANDARD_RESULTS

Used to store the standard analysis values in normalized form

ASSAY_STANDARD_VALIDATION_RULE

Used to store the validation rules for each element/method code/unit of measure combination

ASSAY_STANDARDS

Used to store the various standard codes defined in the Fusion database

ASSAY_UNIT_OF_MEASURE

Used to store all of the units of measure for assay columns (ppm, ppb, gpt, etc.)

AUDIT_COMP_SAMPLES

Used to track audit information related to composite sampling

AUDIT_DHL_SAMPLES

Used to store audit records for original and duplicate sampling

AUDIT_SSTN_RESULTS

Used to store audit records for surface sample results

AUDIT_SSTN_SAMPLES

Used to store audit records for surface samples in general

AUDIT_STANDARDS

Used to store audit records for standards

BUSINESS_UNIT

Used to store business unit information

BUSINESS_UNIT_COLUMN_SETTINGS

Used with business unit preference module (to assign different rules for business units).

BUSINESS_UNIT_COORDINATE_RANK

Used with business unit preference module (to assign different rules for business units).

BUSINESS_UNIT_EMAIL_NOTIFY

Used with business unit preference module (to assign different rules for business units).

BUSINESS_UNIT_EMAIL_RECIPIENTS

Used with business unit preference module (to assign different rules for business units).

BUSINESS_UNIT_PREFERENCES

Used with business unit preference module (to assign different rules for business units).

BUSINESS_UNIT_SAMPLE_SETTINGS

Used with business unit preference module (to assign different rules for business units).

BUSINESS_UNIT_TABLE_SETTINGS

Used with business unit preference module (to assign different rules for business units).

BUSINESS_UNIT_TEST_TYPE_RANK

Used with business unit preference module (to assign different rules for business units).

CASING_TYPE

Reference table of Casing types

COLUMNS_SAMPLE_TYPE

Used to store the assay column to business unit associations

COLUMNS_SAMPLE_TYPE_COMPOSITE

Links composite columns to a business unit

common_audit_items

Stores audit information for lab imports

common_backup_schedule

Stores local database scheduled backup info

common_company_category

Stores company info used with dispatch report

common_company_details

Stores company info used with dispatch report

common_composite_style

Used to store information for automated composites

COMMON_FILE_DATA

Used to store coordinate blob data (datums, transformations between grids). Also used to store the FusionX Local database template

common_location_codes

Used to store reference data for Sample Station Location Tree (child nodes)

common_location_header

Used to store reference data for Sample Station Location Tree (header nodes)

COMMON_SELECTED_OBJECTS

System table used to handle check in / check out security (lock objects that are in use)

COMMON_SQL_STATEMENTS

System table used for distributed database upgrades and configuration changes (stores SQL commands)

COMMON_STANDARDS_FAILURES

Stores a list of standards that have failed on import

common_table_defaults

Used to store pick list default values for the built-In reference tables such as Alteration, Mineralization

CONTRACTOR

Reference table of contractors

COORDINATE_TYPE

Reference table of different coordinate types

CORE_PHOTO_STORAGE_LOCATION

Used to store the default path where core photos will be stored when uploaded or transferred via checkin/checkout

CORE_STORAGE

Reference table for core storage options

CURRENT_DRILLHOLE

System table for drill hole control

CUSTOM_COMP_SAMPLE_DEFINITION

Sample definitions for custom composite sample columns

CUSTOM_EXPORT_DESIGN

Stores the data configured to display the menus for custom exports created in Fusion Connex

CUSTOM_IMPORT_MAPPINGS

Custom import mappings used with the LAS module

CUSTOM_IMPORT_TEMPLATE

Custom import templates used with the LAS module

custom_sample_definition

System table used to store assay column definitions

CV_POLYGON_POINTS

Stores the polygons points from the shape file imported to validate coordinates

CV_POLYGONS

Stores the polygons from the shape file imported to validate coordinates

CV_PROJECT_POLYGONS

Stores de polygon relationship with the project number to validate coordinates

cv_shp_import

Stores the shape file name and the grid assigned

DATABASE_LOCATION

Used to store generic information regarding the database's physical location

database_profile

Stores information about the database type (Local, Fusion Remote, or Central)

DATABASE_STATUS

Stores the status of a database

DATABASE_VERSION

Used to store database version info for all applications

db_lic_id

Referenced by the database licensing module

DENSITY_PACKAGE

Stores the density package information for the Density module

DENSITY_PACKAGE_DETAILS

Stores the density package detail information for the Density module

DEPTH_ADJUST_HOLE_TYPE

Store depth adjustment definitions per hole type information

DEPTH_ADJUST_TEMPLATE

Store depth adjustment template definitions

DEPTH_ADJUST_TEMPLATE_DETAILS

Store depth adjustment template details definitions

descriptor

Legacy table no longer in use in any application

descriptor_category

Legacy table no longer in use in any application

dhl_action_list

Legacy table used to track latest export actions

dhl_action_reason

Reference table used to store the various audit reasons for actions such as deleting holes, authorizing holes/samples

dhl_audit_logging

Main audit table in the Fusion database to track drill hole deletes and authorization

dhl_business_unit_projects

Stores info for projects associated to Business Units

DHL_BLAST_HOLE

Used to store blast hole header information

dhl_composite_cutoff_defaults

Stores info for built-in compositor cut-off defaults

dhl_composite_cutoff_values

Stores info for built-in compositor cut-off values

dhl_composite_values

Stores values generated with the built-in compositor module

DHL_CONTRACT

Contract information for Drill Costing Module

DHL_COST_CATEGORY

Cost category information for Drill Costing Module

DHL_COST_ITEM

Cost item information for Drill Costing Module

DHL_COST_ITEM_DEPTHS

Cost items by depth for Drill Costing Module

DHL_COST_TYPE

Cost type information for Drill Costing Module

DHL_COST_UNIT

Cost Unit information for Drill Costing Module

dhl_dispatch_pulps

Stores pulp instructions for Sample Dispatch

dhl_dispatch_rejects

Stores reject instructions for Sample Dispatch

dhl_downhole_data

Stores values calculated when a hole is de-surveyed

DHL_DRILL_COST_LINE_ITEM

Drill costing line item from Drill Costing Module

dhl_hole_type_generation

Stores information for drill hole generator

dhl_image_import

Legacy table (not referenced)

dhl_import_action_reason

Reference table storing reasons for actions on lab symbols (below / above detection)

dhl_import_symbol

Reference table storing lab symbols used in lab files (>, <, -, etc.)

dhl_import_***

Other tables prefixed with "dhl_import_" are used to perform table/column level validation when importing data using the Drill Hole Import tool

DHL_INSTRUMENT_CONFIGURATION

Used to store information related to an instrument being used to capture data into DHLogger (for example, a scale)

DHL_INSTRUMENT_DATA_CONFIGURATION

Used to store parsing information for instruments

DHL_ITEM_CLASS

Item class for Drill Costing Module

DHL_ITEM_FUNCTION

Item function for Drill Costing Module

DHL_LAB_IMPORT_SUMMARY

Stores the import summary information for all lab imports (ASSAY CSV)

DHL_LAS_DATA

Used to store raw LAS data

DHL_LAS_FINAL_DATA

Used to store final/reviewed LAS data

DHL_LAS_HEADER

Used to store LAS header information

DHL_LAS_RAW_FILES

Used to store LAS raw files

DHL_LAS_SCINT_DATA

Used to store LAS scintillometer data

DHL_LAS_SCINT_HEADER

Used to store LAS scintillometer header information

dhl_logging_style

Used to store logging style information

dhl_logging_style_sample_type

Maps sample types to logging styles

dhl_logging_style_tabs

Used to associate data tables to logging styles

DHL_PLANNED_DH_NAMING_TEMPLATE

Used to store information associated to planned drill hole naming templates

DHL_PLANNED_DRILLHOLES

Stores planned drill holes

DHL_PREP_CODES

Stores preparation codes - legacy table

dhl_project_sample_counts

Stores info for QC sample insertion by project

dhl_qc_header

Stores QC Package names - for drill hole sample generator

dhl_qc_package

Stores QC Package Info - for drill hole sample generator

DHL_QC_PACKAGE_BLOCK_CONTROL

Stores QC Package Block control option configuration (DUPS, Standards, etc.)

dhl_qc_package_details

Stores QC Package details - for drill hole generator

dhl_qc_package_projects

Links QC Packages to projects - for drill hole generator

dhl_qc_samples

Stores QC Samples in QC Packages - for drill hole generator

DHL_SAMPLE_COLUMN_DETAILS

Stores Historical Normalized Assay Results - QAQC Included

DHL_SAMPLE_DISPATCH_ERROR

Stores error information related to the dispatch module

DHL_SAMPLE_DISPATCH_HEADER

Stores header details for sample dispatches

DHL_SAMPLE_DISPATCH_SAMPLES

Stores details for samples in dispatch (sample associations)

DHL_SAMPLE_DISPATCH_TEMPLATES

Stores sample dispatch template information

DHL_SAMPLE_INVOICE

Stores lab invoice names

DHL_SAMPLE_INVOICE_DETAILS

Stores lab invoice details

DHL_TABLE_SORT

Used to store the order of tables in the Details screen in DHLogger

DHL_TABLE_WIDTHS

Used to store the columns widths for each data table in DHLogger

dhl_template

System table storing table template information

dhl_template_columns

System table storing column information for table templates

dhl_unit_conversions

System table for unit conversions

dhl_user_logging_style

System table storing logging styles associated to the various user accounts

DISPATCH_NAME_DETAIL_PROJECT

Used to store dispatch template naming details

DISPATCH_NAMING_DETAILS

Stores the configuration information for the dispatch naming tool

DRILL_HOLE

Collar information (main drill hole collar table)

DRILL_HOLE_COORDINATE

Collar X, Y, Z information (main coordinate table)

DRILL_HOLE_CORE_PHOTOS

Used to store information related to core photos that have been imported in DHLogger

DRILL_HOLE_DIRECTION

Downhole Survey Information (main survey table)

DRILL_HOLE_MAG_SUS

Built-in Magnetic Susceptibility Table

drill_hole_object_status

Stores the status per each drill hole table when the selective transfer module is enabled

DRILL_HOLE_ROCK_QUALITY

Built-in RQD Table

drill_hole_sketch

System table storing drawings from graphic/strip log

dtproperties

System table

ELEMENT_MAPPING

Element mapping information for lab packages

ELEMENT_TYPE

Reference table of all elements - Au, Ag, etc.

EMAIL_NOTIFICATION

Stores information regarding auto email notifications

EMAIL_NOTIFICATION_RECIPIENTS

Stores information regarding user email addresses

EMAIL_NOTIFICATION_TYPE

Stores information regarding the email notification type

EMAIL_SEND_LIST

Stores information regarding the email recipients

FUSION_DATABASE_IDENTIFICATION

Used to store a unique database ID associated to all client databases

FUSION_EVENT_LOG

Used to log events with the Fusion API

FUSION_MODIFIED_TABLES

Used to determine if a specific table has been updated by users (helps with data transfer performance)

graphic_log_preferences

Stores preferences for the graphic log

GRID_CATEGORY

Reference table of grid category codes

GRID_CONVERSION

Reference table storing grid conversion information

GRID_TYPE

Reference table storing grid types

HOLE_ALTERATION

Built-in Alteration table

HOLE_ASSAY_AVERAGES

Stores calculated averages from the assay worksheet

HOLE_ASSAY_DEFAULT_RESULTS

Stores column definitions for drill hole assays

HOLE_ASSAY_SAMPLE

Stores non-normalized assay results (latest batch)

HOLE_ASSAY_SAMPLE_STATUS

Reference table used to store all sample statuses

HOLE_ASSAY_STANDARDS

Used to store standard codes associated to drill holes

HOLE_COMPOSITE_AVERAGES

Used to store averages specific to the composite module

HOLE_COMPOSITE_DEFAULT_RESULTS

Used to store default values configured in the composite module

HOLE_COMPOSITE_SAMPLE

Used to store composite samples

HOLE_COMPOSITE_SAMPLE_RAW

Used to the store the raw samples used to generate the composite

HOLE_INTERVAL

Stores the Lithology records - From, To, Rock Type (main Lithology table)

HOLE_LOCATION

Reference table for built-in collar location field

HOLE_MINERALIZATION

Built-in Mineralization tab

HOLE_SIZE

Reference table used to store hole sizes - BQ, NQ, etc.

HOLE_STRUCTURE

Built-in Structure tab

HOLE_TEXTURE

Built-in Texture tab

HOLE_TYPE

Reference table used to store hole types - DD, CHA, etc.

HOLENAMING_DETAILS

Stores the details for the drill hole naming template configuration

HOLENAMING_TEMPLATE

Stores the information for the drill hole naming template configuration

LAB_ASSAY_DEFINITION

Legacy table no longer in use in any application

LAB_PACKAGE

Used to store lab package/analysis configuration information (i.e. AA24, MS61, etc.)

lab_package_import_logic

Stores import logic info for handling lab repeats

LAB_PACKAGE_SAMPLE_TYPE

Stores sample type mapping for lab import - lab repeats, standards, dups

LABIMPORT_TEMPLATE

Used to store custom lab import template information

LABORATORY

Used to store main lab info (SGS, ALS, etc.)

LABORATORY_ANALYTICAL_DETAILS

Stores lab package details (element mappings)

LAS_EQUIP_CALIBRATION_FILES

Used to store LAS calibration file data

LAS_EQUIPMENT_CALIBRATION

Used to store LAS equipment calibration information

LAS_EQUIPMENT_CATEGORY

Used to store LAS equipment categories

LAS_HEADER_RIG

Used to store LAS rig information

list_versions

Stores refresh list version information for synchronization (used to track if updated have been made)

METAL_PRICES

Reference table storing metal prices

MINE

Legacy table no longer in use in any application

MINERALIZATION_STYLE

Built-in reference table for Mineralization Styles

MINERALIZATION_TYPE

Built-in reference table for Mineralization Types

MM_DXF_CLIENT

Stores MINEMAPPER 3D DXF Import templates

MM_LOGGING_STYLE

Stores the Logging Style definitions in Minemapper 3D

MM_LOGGING_STYLE_SAMPLE_TYPE

Stores the relationship between sample type and logging style in MineMapper 3D

MM_MAP

Stores Map names and header information for MineMapper 3D

MM_MAP_CAMERA

Stores camera positions for MineMapper 3D

MM_MAP_DRAWING

Stores MineMapper 3D Drawing information

MM_MAP_LOCATION

Stores MineMapper 3D Location information

MM_MAP_OBJECT

Stores MineMapper 3D Object information

MM_MAP_OBJECT_POINT

Stores MineMapper 3D Object Point information

MM_MAP_OBJECT_TYPE

Stores MineMapper 3D Object Type information

MM_MAP_OBJECT_TYPE_FORMULA

Stores MineMapper 3D Object Type Formula information

MM_PICTURE

Stores MineMapper 3D Picture

MM_REPORT_DATA

Stores MineMapper 3D Report Data

MM_STATION

Stores MineMapper 3D Survey Station Information

MM_SYMBOL_POINTS

Stores MineMapper 3D Symbol Point Information

MM_SYMBOL_STYLE

Stores MineMapper 3D Symbol Style Information

MM_USER_LOGGING_STYLE

Stores the relationship between users and logging style in MineMapper 3D

MM_VEIN_PATH

Stores MineMapper 3D Vein Path Information - Not in use

MMA_ALTERACION

Stores MineMapper 3D Alteration Object Definition

MMA_GEOTECHNICO

Stores MineMapper 3D Geotechnical Object Definition

MMA_LITOLOGIA

Stores MineMapper 3D Lithology Object Definition

MMA_MINERALIZACION

Stores MineMapper 3D Mineralization Object Definition

MMA_OXIDACION

Stores MineMapper 3D Oxidation Object Definition

MMA_STRUCTURE

Stores MineMapper 3D Structure Object Definition

MMA_ZONAESTRUCTURA

Stores MineMapper 3D Structure Zone Object Definition

next_custom_id

System table used to assign ID's to rows inserted into certain data tables

next_interval_id

System table used to track the next ID assignment for new rows inserted in to data tables

NEXT_NUMBER

System table used to generate the next hole number

next_sample_id

System table used to generate the next sample number in sequence

pbcatcol