Well Maintenance
Back to Set Up Masters Back to System Configuration Back to Royalty Holiday Maintenance Back to Qbyte Metrix Home
- 1 Introduction
- 2 Master
- 3 DOI
- 4 Production
- 5 Royalties
- 5.1 Percentages Tab
- 5.2 Crown Tab
- 5.2.1 British Columbia
- 5.2.2 Manitoba
- 5.2.3 Saskatchewan
- 5.2.4 Alberta
- 5.3 Royalty Holiday/Incentives
- 5.3.1 Edit Holiday Detail Screen
- 5.3.1.1 Alberta
- 5.3.1.2 Manitoba
- 5.3.1.3 Holiday/Incentives Grid
- 5.3.2 Freehold/Override Royalty Obligations
- 5.3.3 IOGC Royalty Obligations
- 5.3.1 Edit Holiday Detail Screen
- 6 Advanced
- 7 Other
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:
Well Maintenance screen (Master > Wells)
WELLMASTERCREATION template
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 |
---|---|
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:
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.
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 | A 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 | A 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 |
---|---|
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.
|
Gas Meter Factor | If the well requires an adjustment factor applied to all gas production, then enter the factor here.
|
Water Meter Factor | If the well requires an adjustment factor applied to all water production, then enter the factor here.
|
Remaining Gas | This field determines what should be done with any remaining gas at the well level. This field defaults to Metering Difference.
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:
|
All Oil To Be Recovered | A 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 | A 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
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 Yes. Add 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.
Note:
|
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.
|
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.
|
Adjust Production | Determines whether this adjustment/consumption volume should be added to production or not.
1. Create well consumption factors at the well(s) consuming received gas and set the Adjust Production = Receipt (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 Production = Receipt (Do Not Adjust Production). The following receipt types can be used:
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:
|
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. |
---|---|
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 Type, Tax 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.
For more details on the rules for determining Royalty Tax Payer on the Oil Pipeline Split and Oil Valuation RTP, see Oil Valuation Data and RTP - Royalty Tax Payer.
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 | |
---|---|
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.
|
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.
|
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.
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).
|
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 |
---|---|
Oil Density | A numerical value denoting whether a well is light, medium, heavy, or ultra-heavy crude oil.
|
Crown Royalty Calculation Type | Drop-down options include:
Select the correct Crown Royalty Calculation Type to calculate the royalty rate.
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:
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.
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)
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.
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 |
---|---|
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.
|
Incentive Type | Available drop-down options include:
This field is required. |
Holiday Description | Used to describe the holiday. |
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.
Note:
|
Manitoba
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.
|
Incentive Type | Available drop-down options include:
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 |
---|---|---|
Calendar Based (AB & MB) |
Note: You can also set up a Maximum Volume that will be tracked.
|
|
Production Date Based (AB & MB) |
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.
|
|
Not Date Dependent (AB & MB) |
|
|
Royalty Value (AB) |
Note: You can also set up the number of Production Months that will be tracked.
|
|
Concurrent Calendar and Production Date Based (AB) |
Note: You can also set up a Maximum Volume that will be tracked.
|
|
Relief Multiplier (AB) |
The incentive will expire when the Holiday End Date is reached. |
|
Minimum Royalty Holiday (MB) |
|
|
Regular Holiday (Total Exemption - MB) |
|
|
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 .
For more information on IOGC Royalty Configurations, see IOGC Royalty Configuration and Processes.
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.