/
Well Maintenance

Well Maintenance

Search the Qbyte Metrix Wiki
 

Back to Set Up Masters     Back to System Configuration     Back to Royalty Holiday Maintenance     Back to Qbyte Metrix Home    

Introduction

To maintain wells:

1. Select Master > Wells to reach Well Maintenance.

OR:

2. Highlight the well in Explorer and click either the Master, Production Master, Royalty Obligation, or DOI buttons on the right-hand menu.

You can create wells using the following three options:

You can choose to maintain wells through the Well  Maintenance screen, or through  Application Integration  and the Well  Maintenance screen (as not all fields on this screen are populated through Integration). The Well Maintenance screen allows you to perform well maintenance activities such as production elements, DOIs, analysis, and royalties. 

Master

To create a new Well, including the use of the Copy button, a user will need to have a Corporate role with Full Access to the WellCreate and the WellMaintenanceEdit security components. To delete a Well a user will need to have a Corporate role with Full Access to the WellDelete and the WellMaintenanceEdit security components. To edit an existing Well that is attached to a Control Group a user will need a Control Group role with Full Access to the WellMaintenanceEdit security component. To edit an existing Well that is not attached to a Control Group a user will need a Corporate role with Full Access to the WellMaintenanceEdit security component.

The Master tab within Well Maintenance captures both mandatory and optional fields which may vary by province. Most fields are self-explanatory with the following possible exceptions:

FIELD

DESCRIPTION

FIELD

DESCRIPTION

Fluid Type

An Oil/Gas/Water/Effluent drop-down that determines the fluid type of the well. Defaults to Gas. The Fluid Type is used to trigger various edits and functionality within the Qbyte Metrix application. 

Heavy Oil

Mandatory. Available options include:

  • Non Heavy Oil Well

  • Heavy Oil Well

  • Saskatchewan Southwest

  • Default is Non Heavy Oil Well

If well is classified as a Heavy Oil Well, you can enter/FDC upload zero producing hours for the well and Book Heavy Oil Differently by using the Region > Financial tab option.

Measurement Type

This field determines the Measurement Type. The default is MEAS - Measured.

  • MEAS - Measured

  • TEST - Test To Test

Note: If the fluid type is Effluent, the measurement type must be TEST - Test To Test.

UserDefined1/UserDefined2

You can choose to make these fields mandatory and change the labels (See Administration > System Configuration > User Defined Labels).

These fields can be used by companies for a variety of reasons including field contacts, corporate division, etc. 

Report Liquid As Condensate

A Yes/No drop-down for gas wells only to be used if the liquid produced is to be reported as Oil (No) or Condensate (Yes).

Report Zero Production

Yes/No drop-down that controls if reporting will print wells with zero volumes or suppress them.

Partner Operated Petrinex ID

A free-form field used by the Partner Operated Petrinex Import process to match the Petrinex file data.

Recombined Liquid And Gas

Yes/No drop-down that indicates if you will be recombining your liquid and gas. 

Partner Operated Petrinex ID 

This field identifies the well presentation for the upload from Petrinex. If the well represents a unit or a well group, or if the legal location is different from the one in Petrinex, this field then needs to be populated with the proper Petrinex Code (i.e. AB UN 12345, or AB WI 100082404812W500).

The  WELLMASTERGENERALUPD template (Import Data by Template) can be used to update various general information fields mentioned above.

The WELLMASTERGENERALUPDNORESET template (Import Data by Template) can be used to update various general information fields mentioned above. When using this template, the facility/control group the well is attached to will not be reset.

The WELLMASTERUWIUPDNORESET template (Import Data by Template) can be used to update just the UWI. When using this template, the facility/control group the well is attached to will not be reset.

DOI

DOIs and DOI exceptions can be maintained in the DOI tab. The highlighted DOI is in effect (unless there are DOI exceptions).

Production

The Production tab is where wells are put on or taken off production, and various calculation factors such as WGR and consumption factors are maintained.

 

Setting Well ON Production

Use the Set On Production button to put a well ON production and set up the various calculation and consumption factors.

As an ease-of-use feature, wells on production and not yet linked to a battery can be attached to a battery directly from this screen. Once a well is attached to a battery, it must be detached on the Battery Maintenance > Wells screen.

 

Well Level Factors

FIELD

DESCRIPTION

FIELD

DESCRIPTION

Water Gas Ratio Factor

When the well has a calculated Water Gas Ratio (WGR) to be used to determine water estimated production instead of entered test/measured volumes, enter the factor here and set the Water Gas Ratio Code to Well-level.

Water Gas Ratio Code

A drop-down list with options including Well-Level or Battery-Level. Indicates whether the well’s water estimate is to be determined by a Water Gas Ratio factor and if so at what level the WGR factor will be entered (Well-level or Battery-level).

Test Date

Water Gas Ratio Test Date: This is for information purposes related to when the Well-level Water Gas Ratio factor was last calculated for the well.

Oil/Condensate Gas Ratio Factor

When the well has a calculated Oil Gas Ratio (OGR) to be used to determine oil/condensate estimated production instead of entered test/measured volumes, enter the factor here and set the Oil Gas Ratio Code to Well-level

Oil/Condensate Gas Ratio Code

A drop-down list with options including Well-Level or Battery-Level. Indicates whether the well’s oil/condensate estimate is to be determined by an Oil Gas Ratio factor and if so at what level the OGR factor will be entered (Well-level or Battery-level).

Test Date

Oil/Condensate Gas Ratio Test Date: This is for information purposes related to when the Well-level Oil Gas Ratio factor was last calculated for the well.

Oil Meter Factor

If the well requires an adjustment factor applied to all oil production, then enter the factor here.

  • It must be greater than or equal to zero.

Gas Meter Factor

If the well requires an adjustment factor applied to all gas production, then enter the factor here. 

  • It must be greater than or equal to zero.

Water Meter Factor

If the well requires an adjustment factor applied to all water production, then enter the factor here. 

  • It must be greater than or equal to zero.

Remaining Gas

This field determines what should be done with any remaining gas at the well level. This field defaults to Metering Difference.

  • Metering Difference: Treat the remaining gas as a metering difference.

  • Flared: Assume the remaining gas was flared.

  • Lease Fuel: Assume the remaining gas was used as lease fuel.

  • Vented: Assume the remaining gas was vented.

Note: The available options are based on the well fluid type: Gas, Water, and Effluent only allow Metering Difference.

Battery GOR Exempt 

A Yes/No drop-down that indicates if the well is exempt from using a battery-level Gas Oil Ratio. The default is No.

Note:

  • This field will only appear if the battery the well is attached to has Calculate Battery Gas Oil Ratio = Yes and the well is a Test well.

  • Measured wells are automatically exempt from using a battery-level Gas Oil Ratio and therefore will not be displayed.

All Oil To Be Recovered

Yes/No drop-down that indicates if you want to assume that all oil produced from the well is to be deemed recovered load oil until all load oil is recovered. The default is No.

Note: This field will only appear if the battery the well is attached to has Recovered Load Entry Method = By Well and Load Recovery Adjustment Type = Auto Adjust Well Total.

All Water To Be Recovered 

Yes/No drop-down that indicates if you want to assume that all water produced from the well is to be deemed recovered load water until all load water is recovered. This field defaults to No.

Note: This field will only appear if the battery the well is attached to has Recovered Load Entry Method = By Well and Load Recovery Adjustment Type = Auto Adjust Well Total.

The Spreadsheet Import#HWELLPRODFACTORWELLPRODUCTIONFACTORSpreadsheet Import#HWELLPRODFACTOR template (Import Data by Template) can be used to update any/all of the fields above.

The WELLWGROGR template (Import Data by Template) can be used to update the Water and Oil Gas Ratio Factors, Codes, and Test Dates.

The WELLWGR template (Import Data by Template) can be used to update the Water Gas Ratio Factors and Test Dates.

The Production tab is also where factors and gas adjustment/consumption factors are maintained (see Factors in the screen above).

Well Level Adjustment/Consumption Flags

Well Level Adjustment.png

FIELD

DESCRIPTION

FIELD

DESCRIPTION

Label

 User-defined description for the adjustment/consumption factor.

Calculation Basis

Defines what volume the adjustment/consumption is based on (i.e. Gas Production, Hours of Production, etc.). Calculation Basis is mandatory and should not be left blank. 

Input Directly as Volume: The adjustment/consumption volume is entered manually through the Battery Balance Well Input tab in Edit mode.

For the three Calculation Basis options listed below, Adjust Production must be set to YesAdd to Production must be set to Well if the Consumption Calc is Gathered. It is assumed the gathered volume is going to the battery and will be metered there, so the calculated volume should not be added to the battery again.

  • GOR: GOR has its own rules for the flag combinations. These are dictated by the Measurement Exempt and Prorate GOR battery flags.

    • When Measurement Exempt is set to Yes, then Recalculate on Actual must also be set to Yes.

    • When Prorate GOR is set to Yes, then Include in Proration must also be set to Yes and vice versa.

  • STV: Adjust Production must be set to Yes or Well. Recalculate on Actual must be set to Yes.

    • Include in Proration must be set to Yes.

  • GIS: Adjust Production must be set to Yes or Well.

    • Recalculate on Actual must be set to No.

    • Include in Proration must be set to Yes

Note: 

  • Wells with a fluid type of Effluent cannot have a Consumption Factor with a Calculation Basis of GIS, GOR, STV, Oil Production or Water Production

  • Wells with Battery GOR Exempt = No, attached to a battery with Calculate Battery Gas Oil Ratio = Yes cannot have a Consumption Factor with a Calculation Basis of GIS, GOR, or STV. Wells with Battery GOR Exempt = Yes, attached to a battery with Calculate Battery Gas Oil Ratio = Yes and Battery GOR Exempt = Yes cannot have a Consumption Factor with a Calculation Basis of GIS or STV. 

Rate

A factor to be multiplied by the volume chosen in the Calculation Basis to calculate the adjustment/consumption volume. Factor is mandatory if the Calculation Basis is not Input Directly as Volume.

  • The rate must be greater than zero.

  • Factor must be blank if Calculation Basis is Input Directly as Volume.

Usage Type

Allows you to select whether this adjustment/consumption volume is to be Flared, Vented, used for fuel (Lease Fuel), or Gathered for further processing.

  • Usage Type is mandatory and should not be blank.

Adjust Production

Determines whether this adjustment/consumption volume should be added to production or not.

  • Setting this option to Yes will adjust both well production and battery production (measurement/usage of this consumption occurred before wellhead measurement - upstream of measurement point).

  • Setting this option to No means no adjustment is made to well production (measurement/usage of this consumption occurred after wellhead measurement - downstream of measurement point).

  • Setting this option to Well will adjust well production, but not battery production. This is used for situations where this well's production adjustment is considered an estimate, and a different actual production volume is entered at the battery. i.e. GOR.

  • Setting this option to Receipt (Do Not Adjust Production) means no adjustment is made to well or battery production because the gas consumed came from received gas and not gas produced at this well.

    • The Calculation Basis must be Input Directly as Volume. The Usage Type must be Lease Fuel, Flared or Vented. This option is used in situations where the gas used as consumption at the wellhead is from a receipt of gas and not from the well's own production. Use the following steps to report wellhead fuel (from a Receipt) to Petrinex without impacting the well's gas production volume:

1. Create well consumption factors at the well(s) consuming received gas and set the Adjust ProductionReceipt (Do Not Adjust Production) and Calculation Basis = Input Directly as Volume.

2. At each Well (Battery Balance > Well Input), enter the wellhead fuel (from a receipt). The volumes can also be loaded via FDC using the CONSINPT record (CSV format).

3. Ensure that there are valid gas receipts at the battery to cover the sum of all wellhead consumption volumes entered for consumption factors using Adjust ProductionReceipt (Do Not Adjust Production). The following receipt types can be used:

  • Consumption Receipt for Wells - This is a user-entered receipt at the battery. These volumes must be used for wellhead-level consumption.

  • Transfer for Consumption - This is an auto-generated receipt created from a Transfer for Consumption disposition from the sending battery. This is only available for non-gas flow batteries. These volumes can be used for wellhead-level consumption or battery-level consumption .

  • Consumption Receipt - This is a user-entered receipt at the battery. These volumes can be used for wellhead-level consumption or battery-level consumption.

Note: Volumes from Transfer for Consumption or Consumption Receipt type receipts will be used for any wellhead-level consumption not already provided for by Consumption Receipt for Wells receipt types before it will be available for use at the battery-level.

Note: If the Calculation Basis is  Gas Production , the Adjust Production flag must be set to No .

Recalculate On Actuals

This option allows you to choose whether the system should use the estimated or actual production volume when calculating the factor. This option is applicable only to factors with a production-based Calculation Basis (Oil Production, Water Production). 

Note:

  • When using Gas Production as the Calculation Basis, the Recalculate On Actuals must be set to No to avoid circular calculations.

  • If the well is measured, the Recalculate On Actuals flag will not have any effect on the calculation result. If the well is a test well, the adjustment/consumption volume will be recalculated to be based on actual volume during the battery processing, if the flag is set to Yes.

  • Consumption factors with Adjust Production = Receipt (Do Not Adjust Production) must have Recalculate On Actuals set to blank.

Include In Proration

If the adjustment/consumption volume is being added to the well gas production, you have the option to either deem this volume as a measured volume (Include in Proration is set to No), or an estimated volume (Include in Proration is set to Yes). This selection will determine whether the volume remains unchanged during balancing or if it is multiplied by the gas proration factor to adjust to actual volume. If Include in Proration is set to Battery, the system prorates the adjustment/consumption volume to all wells attached to the battery regardless of their fuel consumption.

Note: Wells attached to a battery with Calculate Battery Gas Oil Ratio = Yes cannot have a Consumption Factor with an Include In Proration either Yes or Battery. Consumption factors with Adjust Production = Receipt (Do Not Adjust Production) must have Include in Proration set to blank.

The  WELLCONSUMPTION template (Import Data by Template) can be used to set up the new consumption factors at the well.

The  WELLCONSUMPTIONUPD template (Import Data by Template) can be used to update any/all fields of existing consumption factors at the well.

The  WELLCONSBYLABEL template (Import Data by Template) can be used to update just the Rate on existing consumption factors at the well.

The WELLCONSDELETEBYLABEL template (Import Data by Template) can be used to delete existing consumption factors at the well.

*** Also, see  Qbyte Metrix Well Consumption Master Imports  presentation that shows detailed examples of creating/importing well consumption master data.

The  CONSINPT FDC record (CSV format) can also be used to upload the Volume for factors set up with a Calculation Basis of Input Directly as Volume each month.



Setting Well OFF Production

Use the Set Off Production button to take a well OFF production. 

When this button is clicked several checks are done to determine whether the well is eligible to be taken OFF production. The checks are displayed with their status and are split into two groups: Mandatory Checks and Optional Checks. If any of the Mandatory checks fail for the well then the well cannot be taken OFF production and the Continue button will not be visible. If all the Mandatory checks pass, then the well can be taken OFF production and the Continue button will be visible.

Note: Checks that pass have a green check beside them and checks that fail have a red x beside them. Some checks that fail will have additional information underneath indicating the entity or entities where the well was found.

Click the Continue button to take the well OFF production. 

Note: Even if all Mandatory checks pass, any Optional checks that fail should be reviewed. Depending upon the reason that the well is being taken OFF production, these failures may need to be addressed.

Click the Print button to print the results of the checks which can then be used to follow up on any check failures.  

Click the Cancel button to go back to the Factor screen without taking the well OFF production.

Mandatory Checks

All applicable Mandatory checks must pass for the well to be taken OFF production.

Mandatory Checks

All applicable Mandatory checks must pass for the well to be taken OFF production.

Well cannot be linked to a battery.

This check will fail if the well is linked to a Battery. There will be no additional information displayed when this check fails as this data is accessed at the well-level directly.

Note: To remove a well from a battery, the well cannot be Acknowledged (no monthly data entry, operated or partner operated), the well cannot be a Cap or Solution well and the well cannot be referenced in any Load Oil or Load Water receipts at the battery.

Well cannot have Commingled children.

This check will fail if the well has Commingled child wells. There will be no additional information displayed when this check fails as this data is accessed at the well-level directly.

Well cannot have Cap/Solution children.

This check will fail if the well has Cap/Solution child wells. There will be no additional information displayed when this check fails as this data is accessed at the well-level directly.

Well cannot have Designate Volume entered.

This check will fail if the well is included in the list of wells on the Designated Volume screen (accessed from the Plant Balance). Any Plant and Product that includes the well in its Designated Volume list will be displayed underneath the failed check.

Well cannot have a non-zero Override Production entered.

This check will fail if the well has a non-zero volume entered on the Override Production screen. Any Facility and Product where the well has a non-zero Override Production will be displayed underneath the failed check.

Well cannot have Production Volume at an Injection Facility.

This check will fail if the well is included on the Production tab of the Injection Facility Balance, regardless of the volume entered. Any Injection Facility where the well exists on the Production tab of the Injection Facility Balance will be displayed underneath the failed check.

Well cannot be linked to a Consumption Usage.

This check will fail if the well is included in the Entities list of a Consumption Usage, regardless of the volume entered. Any Facility and Usage where the well exists on the Entities list of Consumption Usage will be displayed underneath the failed check.

Note: If the well is the only entity linked to the Consumption Usage, then simply removing the well may cause the consumption allocation for the Usage to be incorrect. If the Consumption Usage is linked to a Gas Flow facility, then a Usage with no entities is allocated to all entities. If the facility is non-Gas Flow, then the Usage is not allocated to any entities.

Well cannot be linked to an IPS Processing Order.

This check will fail if the well exists as a Participant on an Ideal Product Shrinkage Order, regardless of whether it is INCLUDED or EXCLUDED. Any Facility, Product, and Order Sequence where the well exists as a Participant will be displayed underneath the failed check.

Well cannot be linked to an IOGC Reserve.

This check will fail if the well is linked to an IOGC Reserve. Any Reserve the well is attached to will be displayed underneath the failed check.

Well cannot be linked to a Group Meter.

This check will fail if the well is linked to a Group Meter. Any Group Meter the well is attached to will be displayed underneath the failed check.

Well cannot have a Wellhead Analysis.

This check will fail if the well has a Wellhead Analysis entered. There will be no additional information displayed when this check fails as this data is accessed at the well-level directly.

Well cannot be linked to an EOR Scheme.

This check will fail if the well is linked to an EOR Scheme. Any EOR Scheme the well is attached to will be displayed underneath the failed check.

Note: Only checked for Alberta wells.

Well cannot be linked to a REN.

This check will fail if the well is linked to a BC REN. Any REN the well is attached to will be displayed underneath the failed check.

Note: Only checked for British Columbia wells for production dates prior to Petrinex Implementation.

Well cannot be linked to a Production Source.

This check will fail if the well is linked to a BC Production Source. Any Facility that contains a Production Source the well is attached to will be displayed underneath the failed check.

Note: Only checked for British Columbia wells for production dates prior to Petrinex Implementation.

Well cannot have Manitoba Holiday Transfers entered.

This check will fail if the well is referenced in a transfer of Manitoba Holiday volume as either an incoming or outgoing well. There will be no additional information displayed when this check fails as this data is accessed at the well-level directly.

Note: Only checked for Manitoba wells.

Well cannot be linked to a Horizontal Drainage Unit.

This check will fail if the well is linked to a Horizontal Drainage Unit. Any Horizontal Drainage Unit the well is attached to will be displayed underneath the failed check.

Note: Only checked for Manitoba wells.

Well cannot be linked to a Tract.

This check will fail if the well is linked to a Manitoba Tract. Any Tract the well is attached to will be displayed underneath the failed check.

Note: Only checked for Manitoba wells.

Well cannot be linked to a Spacing Unit.

This check will fail if the well is linked to a Spacing Unit. Any Spacing Unit the well is attached to will be displayed underneath the failed check.

Note: Only checked for Manitoba wells.

Optional Checks

Optional checks that fail will not stop the well from being taken OFF production but should be reviewed.

Well does not have non-zero Inventory Override  entered.

This check will fail if the well has a non-zero volume entered on the Override Inventory screen for Inventory Types other than Production Royalty (ROY) or Production Royalty Transfer (XROY). Any Facility and Product where the well has a non-zero Override Inventory will be displayed underneath the failed check.

Note: A well OFF production can still be selling product out of inventory so this is an optional check, but the user should review those facilities where the well has inventory. However, it is possible that the facility/product listed may indicate a facility that is no longer ON production, in which case the remaining inventories for the well can be ignored. Another possibility is that the facility/product listed many indicate a product that the facility is no longer producing. This may or may not be a situation that you need to address but you should review it. For example, if a facility was modified to remove the production of C3 - Propane and instead produce C3MX - Propane Mix, there have already been Inventory Overrides for C3. Hopefully when the product was modified, any Inventory Overrides for C3 were moved over to C3MX and the C3 Inventory Overrides were deleted. 

Well does not have non-zero Carried Over Opening Inventory.

This check will fail if the well has a non-zero volume Closing Inventory for Inventory Types other than Production Royalty (ROY) or Production Royalty Transfer (XROY) in the previous production month and there is no Override Inventory in the selected production month for the Facility and Product where the previous non-zero Closing Inventory was found. Any Facility and Product where the well has a non-zero previous month Closing Inventory will be displayed underneath the failed check. This optional check does not include Royalty Obligation TIK volumes. 

Note: A well OFF production can still be selling product out of inventory so this is an optional check, but the user should review those facilities where the well has inventory. However, it is possible that the facility/product listed may indicate a facility that is no longer ON production, in which case the remaining inventories for the well can be ignored. Another possibility is that the facility/product listed many indicate a product that the facility is no longer producing. This may or may not be a situation that you need to address but you should review it. For example, if a facility was modified to remove the production of C3 - Propane and instead produce C3MX - Propane Mix, then there may be remaining closing inventories in the prior month (before the product change) for C3. Hopefully when the product was modified, any closing inventories for C3 were moved over to C3MX using Inventory Overrides.

Well does not have non-zero Inventory Override entered for Royalty Obligation TIK. 

This check will fail if the well has a non-zero volume entered on the Override Inventory screen for Inventory Types Production Royalty (ROY) or Production Royalty Transfer (XROY). Any Facility and Product where the well has a non-zero Inventory Override for Royalty Obligation TIK will be displayed underneath the failed check.

Note: A well OFF production can still be selling Royalty Obligation TIK from inventory so this is an optional check, but to book this correctly the Royalty Obligation MUST NOT be removed.

Well does not have non-zero Carried Over Opening Inventory for Royalty Obligation TIK.

This check will fail if the well has a non-zero volume of Closing Inventory for Inventory Types Production Royalty (ROY) or Production Royalty Transfer (XROY) in the previous production month and there is no Inventory Override for Royalty Obligation TIK in the selected production month for the Facility and Product where the previous non-zero Closing Inventory for Royalty Obligation TIK was found. Any Facility and Product where the well has a non-zero previous month Closing Inventory for Royalty Obligation TIK will be displayed underneath the failed check. 

Note: A well OFF production can still be selling Royalty Obligation TIK from inventory so this is an optional check, but to book this correctly the Royalty Obligation MUST NOT be removed.

Well does not have Royalty Obligations.

This check will fail if the well has Royalty Obligations. There will be no additional information displayed when this check fails as this data is accessed at the well-level directly.

Note: A well OFF production can still be selling product out of inventory so Royalty Obligations based on sales would still be required to calculate the correct royalties. In addition, some of the inventory could be related to taken-in-kind royalties and the Royalty Obligation would be required to ensure that the booking of the volumes sold out of inventory is correct. The Royalty Obligation is required to identify Royalty TypeTax Type, etc.

Well is not a Disposal well at an Injection Facility.

This check will fail if the well is included on the Disposal tab of the Injection Facility Balance, regardless of the volume entered. Any Injection Facility where the well exists on the Disposal tab of the Injection Facility Balance will be displayed underneath the failed check.

Note: Wells that are OFF production can be included in an Injection Facility for Disposal. However, if the well is being taken OFF production, to eventually remove the Well Master (well is being sold, etc.) then it should be removed from any Injection Facility.

Well is not linked to a Participant Group.

This check will fail if the well is linked to a Participant Group. Any Participant Group the well is attached to will be displayed underneath the failed check.

Note: A well OFF production can still be selling product out of inventory so this is an optional check as the Participant Group could be being used on the Market Master to determine how sales volumes are to be distributed.

Well is not linked to a Facility Charge Monthly Input.

This check will fail if the well is linked to a Facility Charge Monthly Input. Any Facility Charge Monthly Input the well is attached to will be displayed underneath the failed check.

Note: As there is no way for Qbyte Metrix to know what the Facility Charge Monthly Input data represents, it may be possible that even an OFF production well should still be included. It is up to the user to review this data to see if the well should be removed or not.

Well does not have a Facility Charge Cost Centre Cross Reference.

This check will fail if the well is referenced in a Facility Charge Cost Centre Cross Reference. Any Facility that references the well will be displayed underneath the failed check.

Note: A well OFF production can still be selling product out of inventory so this is an optional check as the Facility Charge Cost Centre Cross Reference that references the well could be based on sales and therefore would still be required to ensure the Facility Charges are booked correctly.

Well is not included in Facility Charge Entity Exceptions.

This check will fail if the well is INCLUDED in an Entity Exceptions list for a Facility Charge. Any Facility, Product and Charge Type that includes the well in the Entity Exceptions will be displayed underneath the failed check.

Note: If the well is the only entity INCLUDED in the Facility Charge, then simply removing the well from the list will cause the Facility Charge to be calculated on all entities. In this case, the entire Facility Charge may need to be removed.

Note: A well OFF production can still be selling product out of inventory so this is an optional check as the Facility Charges that reference the well could be based on sales and therefore would still be required to ensure the Facility Charges are calculated correctly.

Well does not have Entity Owner RTPs.

This check will fail if the well has any Entity Owner RTPs entered. There will be no additional information displayed when this check fails as this data is accessed at the well-level directly.

Note: A well OFF production can still be selling product out of inventory so this is an optional check as the various Petrinex reports may still need to determine the correct Royalty Tax Payer.

Well is not linked to a Unit.

This check will fail if the well is linked to a Unit. Any Unit that includes the well will be displayed underneath the failed check.

Note: A well OFF production can still be selling product out of inventory so this is an optional check as knowing the well is unitized may still be required for royalty calculations and/or Petrinex reporting.

Well is not linked to a Petrinex Well Group.

This check will fail if the well is linked to a Petrinex Well Group. Any Facility and Well Group that includes the well will be displayed underneath the failed check.

Note: A well OFF production can still be selling product out of inventory so this is an optional check as the various Petrinex reports may still need to determine the Well Group.

Well is not linked to a Market Master Participant.

This check will fail if the well is a Participant on the Market Master. Any Facility and Product that includes a Disposition where the well is a Participant will be displayed underneath the failed check.

Note: If the well is the only Participant on the Market Master Purchaser, then removing the Participant will cause a Market Master error as there will be no Participants for the Purchaser. In this case, the Market Master Purchaser may also have to be removed, which may lead to there being no Purchasers on the Market Master Disposition.

Note: A well OFF production can still be selling product out of inventory so this is an optional check as the Market Master Participant may be required to determine how the sales volumes are to be distributed.

 

Royalties

Percentages Tab

The Totals tab (which varies by province) will indicate the Crown %, Freehold %, Federal %, etc. The total of all percentages must be 100%.

 

Crown Tab

Back to BC Petrinex Inclusion Project Overview     Back to EOR Holiday

The Crown tab (which varies by province) requires information specific to each province.

  • For Alberta, this tab contains information related to calculating Crown, including Incentives and Holidays, and information related to Royalty Tax Payers for production dates when Alberta implements Oil Valuation RTP submissions for IOGC. Note: The Oil Valuation RTP functionality is enabled for Alberta through the Function Implementation option Alberta Oil Valuation RTP Implementation for IOGC.

  • For British Columbia, this tab contains information related to the old REN crown estimate calculation and Royalty Tax Payers for production dates when BC implements Petrinex submissions.

  • For Manitoba, this tab contains information related to calculating Crown, including Incentives and Holidays, and Royalty Tax Payers for production dates when Manitoba implements Petrinex submissions.

  • For Saskatchewan, this tab contains only Royalty Tax Payers used in Petrinex Oil Valuation RTP submissions.

British Columbia

The Royalty Calculation section within the Crown tab is only displayed for British Columbia wells when the Production Date is less than the BC Petrinex Implementation Date.

The RTP Owner section is only displayed for non-unitized wells when the Production Date is greater than or equal to the BC Petrinex Implementation Date.

Note: For unitized wells, the Crown tab is not displayed at all when the Production Date is greater than or equal to the BC Petrinex Implementation Date.

For wells in British Columbia, Royalty Tax Payers (RTP) are required on Oil Valuation RTP, SAF/OAF, and NGL/Sulphur Valuation RTP, therefore Royalty Tax Payer data can be set up for oil and/or gas so a  Product will be displayed on the screen. 

  • The Save and Continue button can be clicked to remain in Edit mode so that you can switch between products and make all required changes. 

  • Use the Save button once all changes are complete.

Note: All gas wells in British Columbia are classified as producing condensate. Condensate that is not being recombined into the gas stream is to be reported on the Petrinex Oil Pipeline Split and Oil Valuation RTP as Oil, however, the Gas Royalty Tax Payer is to be used by the British Columbia government when calculating Crown royalties. This means that in most cases the Gas Royalty Tax Payer will be used for both the Oil Pipeline Split and the Oil Valuation RTP. Clients can set up Oil Royalty Tax Payer data for gas wells in British Columbia, and they will be used before the Gas Royalty Tax Payer to handle exceptional situations such as when a partner does not take their wellhead condensate in-kind but does take their gas and by-products in-kind. For this scenario in British Columbia, the partner would not report their own wellhead condensate volumes on the Oil Pipeline Split or Oil Valuation RTP, but they would still be allocated and invoiced Crown royalties by the government on their wellhead condensate.

The Royalty Tax Payer used for the various Petrinex Submissions depends upon the specific submission, however, in general, entered RTP data will take precedence. When there is RTP data entered for a well, that data will be used for all owners. If we encounter an owner for the well that does not appear in the list of owners in the RTP data, we will assume that they are their own RTP Owner (typically a message will be generated indicating that we made that assumption).

When there is no RTP data entered, the default logic for determining the RTP Owner is to assume that if the owner is flagged as TIK (Exclude Owner = Yes in the DOI - Uses appropriate product Ownership DOI Exception or default DOI if no exception DOI) then they are their own RTP Owner. 

For all non-TIK owners, the RTP is determined differently depending on the specific submission. For example, within the Oil Valuation RTP, the RTP owners for non-TIK partners is assumed to be the operator for which the Generate Oil Valuation Data process was run.

SAF/OAF and NGL Valuation RTP submissions may have slightly different rules regarding Royalty Tax Payer than for Oil Pipeline Split and Oil Valuation RTP.

RTP Owners Section

RTP Owners Section

BUTTON

DESCRIPTION

Default RTP Owner

This button is used to reset any existing RTP data back to default values, where each DOI owner is their own RTP Owner. 

  • This button is enabled only when the grid has at least one record.

Load

This button is used to do the initial population of the RTP data (for a given Product, or Oil if Manitoba or Saskatchewan). The initial population of data will look at the DOI for the well and create a record for each DOI Owner, with themselves as their own RTP Owner.

  • This button is enabled only when the grid is empty.

  • This process uses the appropriate product Ownership DOI Exception or default DOI if no exception DOI.

Remove Unmatched Owners

This button is used to remove DOI Owners that are no longer in the DOI and that no longer require an RTP Owner.

  • This button is enabled only when there is at least one DOI Owner in the grid that is no longer in the DOI.

Note: There may be situations where you want to leave RTP data for an owner that is no longer in the DOI, such as when they still have inventory that needs to be sold and therefore reported. If they are their own RTP, you can safely remove them from the RTP data since we assume that any owner we report that does not have RTP data is their own RTP Owner. However, if they have an RTP Owner different than themselves you will want to keep the RTP data until all their inventory is sold.

Clear

This button is used to remove all RTP Owner data (for a given Product, or Oil if Saskatchewan).

  • This button is enabled only when the grid has at least one record.

 

Manitoba

The RTP Owners section within the Crown tab is not displayed for Manitoba wells when the Production Date is less than the MB Petrinex Implementation Date. For unitized wells, the RTP Owners section will not be displayed, regardless of the production date. The RTP Owners should be set up at the Unit when the Production Date is greater than or equal to the MB Petrinex Implementation Date

The RTP Owners section within the Crown tab is only displayed for Manitoba wells when the Production Date is greater than or equal to the MB Petrinex Implementation Date.

For non-unitized wells in Manitoba, Royalty Tax Payers are only required on the Oil Valuation RTP submission so there is no Product shown on the screen.

When determining the RTP Owner for the Oil Valuation RTP, entered RTP data will take precedence. When there is RTP data entered for a well, that data will be used for all Owners. If we encounter an Owner for the well that does not appear in the list of owners in the RTP data, we will assume that they are their own RTP Owner (typically a message will be generated indicating that we made that assumption). When there is no RTP data entered for the well, the default logic for determining the RTP Owner is to assume that if the Owner is flagged as TIK (Exclude Owner = Yes in the DOI - uses appropriate product Ownership DOI Exception or default DOI if no exception DOI) then they are their own RTP Owner. For all non-TIK owners, the RTP is assumed to be the Operator for which the Generate Oil Valuation Data process was run.

Reminder: The buttons when editing the RTP Owners Section are the same as documented under British Columbia.

Saskatchewan

This tab is used to maintain the Royalty Tax Payers (RTP) for Petrinex submissions in Saskatchewan. For non-unitized wells in Saskatchewan, Royalty Tax Payers are only required on the Oil Valuation RTP submission so there is no Product shown on the screen.

When determining the RTP Owner for the Oil Valuation RTP, entered RTP data will take precedence. When there is RTP data entered for a well, that data will be used for all Owners. If we encounter an Owner for the well that does not appear in the list of owners in the RTP data, we will assume that they are their own RTP Owner (typically a message will be generated indicating that we made that assumption). When there is no RTP data entered for the well, the default logic for determining the RTP Owner is to assume that if the Owner is flagged as TIK (Exclude Owner = Yes in the DOI - uses appropriate product Ownership DOI Exception or default DOI if no exception DOI) then they are their own RTP Owner.  For all non-TIK owners, the RTP is assumed to be the Operator for which the Generate Oil Valuation Data process was run.

Reminder: The buttons when editing the RTP Owners Section are the same as documented under British Columbia.

Alberta

Density, Crown Royalty Calculation Type, Equivalent Use Sub Type, and Holiday information entered for Commingled Child wells where the Parent well has the Calculate Crown at Parent field set to Yes will be ignored. When the Commingled Parent well has the Calculate Crown at Parent field set to Yes, the information must be set up at the Commingled Parent well.

FIELD

DESCRIPTION

FIELD

DESCRIPTION

Oil Density

A numerical value denoting whether a well is light, medium, heavy, or ultra-heavy crude oil.

  • Required for crown royalty rate calculations.

Crown Royalty Calculation Type

Drop-down options include:

  • B - Bypass - Use this when you do not want the system to calculate a crown royalty for you based on the standard provincial formulas and you want to calculate it outside the system or use a royalty obligation instead (recommended for effluent wells).

  • E - Equivalent Use - Use if you want to calculate a cash-based crown royalty (volume will not appear on a split). In addition, use the Equivalent Use Sub Type to select which Crown Royalty formula to use to calculate the volume.

  • MRFC - MRF 2017 C* - To calculate a new well's royalty rate based on the Alberta Modernized Royalty Framework prior to payout (included only if MRF is enabled in System Configuration > Function Implementation).

  • MRFPC - MRF 2017 Post C* - To calculate a well's royalty rate based on the Alberta Modernized Royalty Framework after payout (included only if MRF is enabled in System Configuration > Function Implementation).

  • N - ARF 2009 Normal - To calculate a well's royalty rate based on the Alberta Royalty Framework.

  • T - ARF 2009 Transitional - Use if the well is on the Alberta Government's Transitional royalty program.

Select the correct Crown Royalty Calculation Type to calculate the royalty rate.

  • See Crown Royalty Rates for more information on Crown Royalty Rates and Crown Royalty Formula Details.

Note: For an effluent well, the Crown Royalty Calculation Type can only be B (as effluent wells produce condensate and therefore oil royalty should not be calculated).

Equivalent Use Sub Type

This field is disabled and is only editable when the Crown Royalty Calculation Type is E - Equivalent Use.

Available drop-down options include:

  • MRFC - MRF 2017 C* (included only if MRF is enabled in System Configuration > Function Implementation)

  • MRFPC - MRF 2017 Post C* (included only if MRF is enabled in System Configuration > Function Implementation)

  • N - ARF 2009 Normal

  • T - ARF 2009 Transitional

Select the Equivalent Use Sub Type to calculate the Royalty Rate based on the selected formula.

Oil Holiday/Incentive Sequence #

If the well requires a holiday to be set up:

1. Create a new Holiday Sequence # in the Edit Holiday Details screen.

  • A drop-down will be available upon Save.

2. Select the Oil Holiday/Incentive Sequence # from the list that is to be active.

Note: No royalty holiday will be calculated if a Holiday/Incentive Sequence # is blank. The royalty rate will be calculated based on the Crown Royalty Calculation Type.

Process for Crown Invoice

This is a Yes or No drop-down with a default of Yes.

 

The RTP Owners section within the Crown tab is only displayed for Alberta wells when the Function Implementation option Oil Valuation RTP Implementation for IOGC is Active and the Production Date is greater than or equal to the Start Date of the option. Remember that Oil Valuation RTP submissions are only required in Alberta for batteries that have at least one well with a First Nation mineral ownership (Federal % > 0) so only those Wells with a Federal % > 0 may require RTP Owners set up.

For non-unitized wells in Alberta, Royalty Tax Payers are only required on the Oil Valuation RTP submission so there is no Product shown on the screen.

When determining the RTP Owner for the Oil Valuation RTP, entered RTP data will take precedence. When there is RTP data entered for a well, that data will be used for all Owners. If we encounter an Owner for the well that does not appear in the list of owners in the RTP data, we will assume that they are their own RTP Owner (typically a message will be generated indicating that we made that assumption). When there is no RTP data entered for the well, the default logic for determining the RTP Owner is to assume that if the Owner is flagged as TIK (Exclude Owner = Yes in the DOI - uses appropriate product Ownership DOI Exception or default DOI if no exception DOI) then they are their own RTP Owner. For all non-TIK owners, the RTP is assumed to be the Operator for which the Generate Oil Valuation Data process was run.

For unitized wells, the RTP Owners section will not be displayed, regardless of the production date. The RTP Owners should be set up at the Unit when the Production Date is greater than or equal to the Oil Valuation RTP Implementation for IOGC  Date


Alberta Modernized Royalty Framework (MRF)

Back to System Configuration

The Alberta Modernized Royalty Framework (MRF) came into effect January 1, 2017 (or July 13, 2016, for early opt-ins). You may select whether you are on the MRF C* or Post C* phase and trigger the appropriate royalty calculations for each phase when you set up new wells.

 

To Begin Using MRF:

1. Navigate to System Configuration > Function Implementation.

2. Enable Implement Alberta Modernized Royalty Framework.

Existing Qbyte Optix reports such as Well Details, Alberta Crown Royalty Calculation, and Royalty Holiday Details can be used to review setup details and calculations.

It is a good practice to check newly acquired Alberta wells integrated into Qbyte Metrix to ensure that the Crown Royalty Calculation Type on the Well Maintenance > Royalties > Crown tab  reflects the correct royalty framework. This ensures appropriate royalty rates are being calculated for each well. The Crown Royalty Calculation Type options are explained above. You will use the MRF 2017 C* option prior to payout and use the MRF 2017 Post C* option after payout. Qbyte Metrix calculates the Post C* Royalty Rate for oil based on the established formulas. Once the wells production drops below the Maturity Threshold (Oil Equivalent volumes = 194.0 m3), the formula will adjust accordingly.

If the Alberta Modernized Royalty Frame work 2017 function type has its Active Indicator set to Yes in the Function Implementation screen, the system will default to the Crown Royalty Calculation Type  MRF 2017 C*. If this type is incorrect, you will have to modify it in the Crown tab.  Since Qbyte Metrix does not track when a well is in C* or Post C* phase, you are required to change the Crown Royalty Calculation Type when the well reaches the Post C* phase to ensure the correct royalty rates are being calculated.


Royalty Holiday/Incentives

Holidays do not apply to British Columbia or Saskatchewan wells, they are for Alberta and Manitoba wells only. Holiday information entered for Alberta Commingled Child wells where the Parent well has the Calculate Crown at Parent field set to Yes will be ignored. When the Commingled Parent well has the Calculate Crown at Parent field set to Yes, the holiday information must be set up at the Commingled Parent well.

1. Navigate to Well Maintenance > Royalties > Crown . 

2. Click the Edit button.

3. Create a new Holiday Sequence by selecting Add New.

RoyHoliday.png

4. Another way to get to the Royalty Holiday Maintenance screen is navigating from Royalties > Crown > Royalty Holiday Maintenance. 

5. Click Create New to create a new holiday.

 

Edit Holiday Detail Screen

Alberta

Holiday information entered for Commingled Child wells where the Parent well has the Calculate Crown at Parent field set to Yes will be ignored. When the Commingled Parent well has the Calculate Crown at Parent field set to Yes, the holiday information must be set up at the Commingled Parent well.

FIELD

DESCRIPTION

FIELD

DESCRIPTION

Holiday Incentive Sequence#

A mandatory numerical value to identify a holiday. A well can have more than one holiday over its history, but only one holiday can be in effect at a time.

  • Required for Crown Royalty Rate calculations.

Incentive Type

Available drop-down options include:

  • I - Incentive

  • E - Exemption

This field is required.

Holiday Description

Used to describe the holiday.

Holiday Type

This field is required. See the grid below for additional information.

Volume Cap Based On



Royalty holidays with a production volume cap for OIL (Maximum Volume) require you to select what the Volume Cap is Based On.

Options include Crown Eligible Production or Total Production. The default selection is Total Production.

  • Crown Eligible Production means that only the calculated crown eligible volume will be applied against the Maximum Volume. The calculated crown eligible volume is oil production multiplied by the crown mineral ownership percentage. 

  • Total Production means that all volume produced in a production month will be applied against the Maximum Volume.

Note:

  • If this flag is changed from Crown Eligible Production one month to Total Production another month, (or vice versa) it can impact prior period amendments because the volume cap will be based on a different volume (especially if the Crown Ownership is less than 100%). If the flag must be changed after the initial setup, it is recommended that you create a brand-new Holiday Incentive Sequence# and make the change on an ongoing basis.

  • If you do not follow this recommendation you will have to fix all affected months and re-run Crown calculations to ensure that the Volume Cap is accurately calculated from inception.



Manitoba

FIELD

DESCRIPTION

FIELD

DESCRIPTION

Holiday Incentive Sequence#

A mandatory numerical value to identify a holiday. A well can have more than one holiday over its history, but only one holiday can be in effect at a time.

  • Required for Crown Royalty Rate calculations.

Incentive Type

Available drop-down options include:

  • M - Minimum Royalty Holiday

  • R - Regular Holiday (Total Exemption)

This field is required.

Holiday Description

Used to describe the holiday.

Holiday Type

This field is required. See the grid below for additional information.



Holiday/Incentives Grid

Royalty holiday/incentive tracking has several tracking mechanisms and adjustments. The following chart indicates the data entry that is required, and what triggers the expiry of the incentive/holiday. 

TRACKING MECHANISM

DATA ENTRY REQUIRED

ADJUSTMENTS

TRACKING MECHANISM

DATA ENTRY REQUIRED

ADJUSTMENTS

Calendar Based (AB & MB)

  • Enter Holiday Start Date and Holiday End Date.

Note: You can also set up a Maximum Volume that will be tracked. 

  • The incentive will expire when either threshold is reached.

  • N/A

  • If a Volume Adjustment is entered, it will reduce the remaining volume.

Production Date Based (AB & MB)

  • Enter the Holiday Start Date and the Number of Production Months.

Note: Holiday End Date is not checked or used but can still be entered.

Note: You can also set up a Maximum Volume that will be tracked.

  • The incentive will expire when either threshold is reached.

  • If a Production Months Adjustment is entered, it will reduce the remaining months.

  • If a Volume Adjustment is entered, it will reduce the remaining volume.

Not Date Dependent (AB & MB)

  • Enter the Maximum Volume.

  • If a Volume Adjustment is entered, it will reduce the remaining volume.

Royalty Value (AB)

  • Enter the Maximum Value.

Note: You can also set up the number of Production Months that will be tracked.

  • The incentive will expire when either threshold is reached.

  • If an Adjustment Value is entered, it will reduce the remaining value.

  • If a Production Months Adjustment is entered, it will reduce the remaining months.

Concurrent Calendar and

Production Date Based (AB)

  • Enter Holiday Start Date, Holiday End Date, and the Number of Production Months.

Note: You can also set up a Maximum Volume that will be tracked. 

  • The incentive will expire when calendar months are reached, and production months or volume threshold is reached.

  • If a Production Months Adjustment is entered, it will reduce the remaining months.

  • If a Volume Adjustment is entered, it will reduce the remaining volume.

Relief Multiplier (AB)

  • Enter Holiday Start Date and Holiday End Date.

The incentive will expire when the Holiday End Date is reached.

  •  N/A

Minimum Royalty Holiday (MB)

  • Enter the Maximum Volume.

  • Enter the Crown Minimum Royalty Rate and Freehold Minimum Royalty Rate (if applicable).

  • If a Volume Adjustment is entered, it will reduce the remaining volume.

Regular Holiday (Total Exemption - MB)

  • Enter the Maximum Volume.

  • If a Volume Adjustment is entered, it will reduce the remaining volume.



Freehold/Override Royalty Obligations

Royalties can be maintained in the Freehold/Override/IOGC tab. 



IOGC Royalty Obligations

For IOGC royalties:

  • The Royalty Entity ID can be entered and will be used for gas royalties. 

  • The Oil Royalty Entity ID can be entered and will be used for oil royalties. 

  • If an Oil Royalty Entity ID is not entered, the Royalty Entity ID will also be used for oil royalties. 

The Reserve Code can also be entered here. Royalty obligations can be maintained here, and this screen can also be accessed by selecting the Well ID within Explorer .

 

Advanced

The Advanced tab is where cap and solution wells and/or commingled wells can be maintained. 

The following links describe how these well sets are configured: 

Other

Ontario Township Codes

Township Codes are used for government reporting and are specific to Ontario. Township Codes and Names are published by the Ontario government. The Township Code is part of the Well Master.

A view-only page appears consisting of a table listing all defined Township Codes.

You can sort by Code, Short Description, Description, Sort Order, Active Value, Last Updated User, or Last Updated Date/Time. You can filter on Code, Description, and Active.


To Edit Township Codes:

1. Click the Edit button.

  • A view-only page listing Township Codes will appear.

2. You can Create New (create a new Township Code), Delete Row (delete a Township Code), or select fields for edit.

Clicking the Cancel button brings the view-mode page back.

  • Click the Revert button to revert changes to the last saved changes (if desired).


To Create New Township Codes:

1. Click Create New from the Edit screen and enter all required information.

  • The Clear button reverts changes.


Copyright© 2024 IFS AB. Copying prohibited. All rights reserved.