Krux makes the following Dimension tables available:
• DIM_ApprovalStatus – workflow status (e.g., Approved, New, Rejected, Validated)
• DIM_Bit – for drilling companies that have enabled the feature to mandate including the bit serial number within daily shift reports
• DIM_BitSize – for drilling companies that have opted to not enforce tracking of bit sizes
• DIM_Category – a grouping of the business activities or charge types (e.g., Fuel, Labour, Testing, Casing, Drilling, Consumables)
• DIM_ChargeType - Charges are grouped to allow total amount to be presented at different levels of granularity - e.g. Labour charges can be displayed as overall labour charges, or broken out by timesheet and DSR labour charges. Total DSR charges can be presented as an overall charge or split up by activity, consumable and equipment charges.
• DIM_Company_Drilling – list of drilling companies and their details
• DIM_Company_Mining – list of mining companies and their details
• DIM_Contract – contract details like name, number, contractee, contractor, currency, and status
• DIM_Currency – currency details like currency code, country, and symbol
• DIM_Date – date associated to the report date (e.g., Year, Quarter, Month, Week, Date)
• DIM_Date_Approved – date associated to the approval date (e.g., Year, Quarter, Month, Week, Date)
• DIM_Date_Created – date associated to the record creation date (e.g., Year, Quarter, Month, Week, Date)
• DIM_Date_LastModified – date associated to the record last modified date (e.g., Year, Quarter, Month, Week, Date)
• DIM_Date_PlanForecast - Date associated to the plan forecast month (e.g., Year, Quarter, Month) for planned drilling. Use in combination with DepthForecasted_Plan.
• DIM_Date_Rejected – date associated to the rejected date (e.g., Year, Quarter, Month, Week, Date)
• DIM_Date_Validated – date associated to the validated date (e.g., Year, Quarter, Month, Week, Date)
• DIM_Distance_Between – Depth range intervals/buckets (in feet or meters of 1,5,10,20,30,40,50,100 or 200) using the distance between the DistanceFrom and DistanceTo fields
• DIM_Distance_From – Depth range intervals/buckets (in feet or meters of 1,5,10,20,30,40,50,100 or 200) using the distance between the DistanceFrom and DistanceTo fields
• DIM_Distance_To – Depth range intervals/buckets (in feet or meters of 1,5,10,20,30,40,50,100 or 200) using the distance between the DistanceFrom and DistanceTo fields
• DIM_Drill – list of drills and their details like drill type, name, serial number, make and model
• DIM_Employee – A list of employees associated with either a timesheet or a daily shift report. This dimension table is used when combining timesheet and daily shift report metrics by employee.
• DIM_Employee_ApprovedBy – A list of employees who are associated with record approvals
• DIM_Employee_LastModifiedBy – A list of employees who are associated with when a record was last modified
• DIM_Employee_RejectedBy – A list of employees who are associated with records in a rejected status
• DIM_Employee_ValidatedBy – A list of employees who are associated with records that have been validated
• DIM_EmployeeRole – A list of employees and their roles associated with either a timesheet or a daily shift report. This dimension table is used when combining timesheet and daily shift report metrics by employee and role.
• DIM_Equipment – A list of equipment items associated with either a timesheet, daily shift report or equipment rental. This dimension table is used when combining timesheet, daily shift report or equipment rental metrics by equipment item.
• DIM_Group – A list of unique timesheets, daily shift reports and equipment ids. This dimension table is used when combining timesheet, daily shift report and equipment metrics. Refer to data model.
• DIM_Hole – List of holes and their details like elevation, planned depth (includes X, Y, Z, Azimuth, Dip, Easting, etc.)
• DIM_HoursType – type of hourly rate (e.g., Drilling, Daywork, Crew Travel, Moving, Repair)
• DIM_KPIComparisonType – this dimension view contains all of the unique KPI comparison types (e.g. greater than, less than, equal to etc). Use this in combination with KPI measures only or FACT_KPI_Contract table.
• DIM_KPIDefinedRate – Contains all of the defined rates set at the contract level. Use this in combination with KPI measures only or the FACT_KPI_Contract table.
• DIM_KPIStatus – Contains the KPI performance indicator (on target or off target). Use this in combination with KPI measures only or the FACT_KPI_Contract table.
• DIM_KPIType – Contains the unique KPI types (e.g. distance per shift, rate of penetration). Use this in combination with KPI measures only or the FACT_KPI_Contract table.
• DIM_KPIUnitOfMeasure – Contains the unique unit of measures (e.g. distance, distance/hour, percentage). Use this in combination with KPI measures only or the FACT_KPI_Contract table.
• DIM_Location – list of locations and their details like name, city, province/state, country, deposit (includes latitude and longitude)
• DIM_Note – Notes/comments associated with activities and additional charges
• DIM_Plan – mining plan details like budget, planned holes and planned drilling (available to mining companies only)
• DIM_Plan_FundingParty – list of associated Funding parties (e.g., Exploration, Geological) and the funding percentage (available to mining companies only)
• DIM_Plan_Resources – Resources associated to a mining plan like coal, copper, gold and diamond (available to mining companies only)
• DIM_Project – list of projects and their details like PO Number, contractor, and project name
• DIM_Shift – list of daily shift reports and their details like start/end time, duration, and supervisor
• DIM_Shift_EmployeeRole – list of employees associated to the shifts, their role and employer
• DIM_Shift_Equipment – List of equipment items associated to the shifts, their make, model, and unit number
• DIM_SubCategory – a more granular categorization of DIM_Category (e.g., repair mud pump, rig maintenance, non-billable)
• DIM_Tenement – A list of mining tenements (lease, claim or license) and their details like start and end date. Only available to mining companies.
• DIM_Time_Approved - Time associated to the approval date (e.g., Hour, Minute, Second)
• DIM_Time_Created - Time associated to the record creation date (e.g., Hour, Minute, Second)
• DIM_Time_LastModified - Time associated to the time the record was last modified (e.g., Hour, Minute, Second)
• DIM_Time_Rejected - Time associated to the rejected date (e.g., Hour, Minute, Second)
• DIM_Time_Validated - Time associated to the validated date (e.g., Hour, Minute, Second)
• DIM_Timesheet - List of timesheets and their details like date, status and whether approval is required
• DIM_Timesheet_Aggregated - List of aggregated timesheets (by timesheet date) and their details like status, contract, and project
• DIM_Timesheet_EmployeeRole - List of workers associated with an aggregated timesheet, their role, and payroll/man-hours
• DIM_Timesheet_Equipment - List of equipment associated with an aggregated timesheet, the equipment hours, and unit number
• DIM_Timesheet_SubmittedBy - List of submitted timesheets, date submitted, status and the person who submitted the timesheet
• DIM_Unit – the unit of measurement, name, abbreviation, and conversion rate
DIM_Group
This special dimension table allows report users to create dashboards that can be filtered by an employee (DIM_Employee or DIM_EmployeeRole) or a piece of equipment (DIM_Equipment).
The employee can belong to a timesheet or a daily shift report. The equipment can belong to a timesheet, daily shift report or can be an equipment rental item.
The following measures can be used with these dimension tables:
• PayrollHours_ByEmployee
• ManHours_ByEmployee
• EquipmentHours_ByEquipItem
• Charges