DOI (Division of Interest)
- IFS Energy and Resources (Deactivated)
- IFS Energy & Resources (Deactivated)
- IFS Energy & Resources
Back to Set Up Masters Back to Plant Maintenance Back to Facility Charges
- 1 Introduction
- 2 DOI Maintenance
- 2.1 Create New
- 2.2 Add Owners
- 2.3 Delete DOI/ DOI Owner
- 2.4 Edit DOI
- 2.5 Copy DOI
- 2.6 DOI Exceptions
- 3 Navigation
- 3.1 Explorer
- 3.2 Well DOI
- 3.3 Unit DOI/Tract DOI
- 3.4 Facility DOI
- 4 Reports
- 4.1 DOI Summary
- 4.2 DOI Details
- 5 Appendix
Introduction
DOIs are used to designate working interest owners and their ownership to revenues as well as expenses such as royalties and facility charges for a designated entity. A DOI consists of an effective date and Sub ID. Only one DOI is in effect during a production date for the same entity, product, or purpose.
A DOI Sub ID is a unique ID identifying a unique set of owners, their percentages, and exclusion options . A new Sub ID should be created if a new owner is added to a DOI mix, or if an owner needs to be excluded from the DOI. Multiple Sub IDs can exist for the same effective date, especially if different Sub IDs are required for booking revenue, royalties, or facility charges differently (as in the case of DOI exceptions).
DOI exceptions should be created in situations where multiple DOIs are required for different purposes or activities, such as allocating royalties, facility charges, and sales. See the Appendix for examples.
The lowest Sub ID for the highest effective date that is less than or equal to the production date is automatically designated as the default DOI. Note: The DOI Sub ID is technically an alphanumeric field, but it is recommended that you use only numerical digits (i.e. 0001, 0002, etc.) to make it easier to understand which is the lowest Sub ID and to determine what a new Sub ID should be.
A DOI can be created from the Well/Unit/Plant/GGS/Battery DOI Master Maintenance screens.
DOI Maintenance
DOIs can be maintained by the menu option Master → DOI.
1. Enter a Well/Tract or Facility (Plant/GGS/Injection Facility/Unit) as the Entity ID.
2. Select View to display all available DOIs for the Entity ID.
All existing DOIs for the selected Entity ID will be displayed on this screen. The effective DOI is the primary DOI for the selected entity ID. The lowest numbered Sub ID for the highest effective date that is less than or equal to the entered production date is automatically designated as the default DOI. The default DOI (effective DOI Sub ID) for the selected Production Date will be highlighted in bold blue font.
From this screen you can either:
Create New (create a new DOI)
Edit a DOI
Add Notes for the Entity ID (regardless of Production Date or Effective Date).
Scroll the Production Dates for the same Entity ID or scroll through different entities for the same Production Date.
If the Entity Type is a Well, the scroll functionality will loop through all wells in the same battery.
If the Entity Type is a Tract the scroll functionality will loop through all tracts in the same unit.
If the Entity Type is a Facility (plant, GGS or battery), the scroll functionality will loop through all facilities (of the same type) in the same control group.
If the Entity Type is a Unit or an Injection Facility, there is no scrolling available for the entity (only dates).
To create a new DOI Sub, including the use of the Copy button, a user will need to have a Corporate role with Full Access to the DOICreate and the DOIEdit security components. To delete a DOI Sub, a user will need to have a Corporate role with Full Access to the DOIDelete and the DOIEdit security components. To edit an existing DOI Sub, a user will need to have a Corporate role with Full Access to the DOIEdit security component.
Create New
The default DOI is the primary DOI for the entity. In Qbyte Metrix, the lowest numbered DOI Sub ID for any given effective date is automatically designated as the default DOI for that production date. When a DOI is created, it is especially important to assign the lowest Sub ID possible for that effective date for it to be designated as the default DOI. All other DOIs created for the same effective date should have higher Sub IDs. Sub IDs are unique across effective dates and cannot be repeated. Before creating DOIs, ensure the owners or participants that are associated with the DOI have been set up in Qbyte Metrix.
Reminder: During Step processing, if DOIs for required entities do not exist, errors will be displayed within the Message Centre.
Action buttons include Save, Revert, and Cancel.
1. Select the Create New button to add a new row.
CREATE NEW DOI | |
|---|---|
Effective Date | This field defaults to current production date. It can be changed to reflect the correct effective date for the entity ID. |
Entity Type | This field defaults to the well. Options include:
|
Entity ID | Options include Valid Battery, GGS, Plant, Tract, Unit or Well. |
Sub ID | DOI Sub ID is a unique ID identifying a unique set of owners, their percentages, and exclusion options. Multiple Sub IDs can exist for the same effective date, especially if different Sub IDs are required for booking revenue, royalties, or facility charges differently (as in the case of DOI exceptions) or if there is a difference in exclusion options. Recommendation: The Sub ID has a maximum length of 16 characters; however, it is recommended that you use a 4-digit ID (i.e. 0001, 0002, etc.) beginning with 0001. This keeps the Sub ID short but allows for many DOIs over the life of an entity. |
User Defined1 | This is an optional field. |
Default DOI | This field defaults to No. It is used when integrating with Qbyte Financial. Do not modify this field. |
Add Owners
To add owners:
1. Select the Create New button.
2. Enter owners and their respective interest percent.
3. Select Create New again (and again) to add additional owners.
The total interest percent must equal 100.
Action buttons include Save, Revert and Cancel.
4. Select the Create New button to add a new row.
ADD OWNERS | |
|---|---|
Owner ID | This is the ID of a valid Qbyte Metrix owner. |
Owner Interest Percent | 1-100.000 |
Silent Partner Parent ID | This is an optional field. An owner ID can be identified as a silent partner to be excluded from all government and partner reporting by designating a parent. The parent must be an owner already defined within the DOI as an owner ID. The owner ID with a silent partner parent ID specified will be allocated volumes and values on the financial interface voucher only. Not all owners can have silent partner parent IDs, and no circular references are allowed (Owner 1 parent of Owner 2 and Owner 2 parent of Owner 1, etc.). |
Exclude Owner | This field defaults to No. Change it to Yes if your requirement is one of the following:
|
Delete DOI/ DOI Owner
1. Select the Delete button to delete the DOI.
2. Select a row then select the Delete Row(s) button to delete individual owners of the DOI.
Edit DOI
Changing an existing DOI (adding new owners or changing the ownership percent) may affect prior months' calculations if the DOI being changed was in affect for prior periods. Therefore, when a DOI changes as of a new production date, a new DOI should be created.
To modify an existing DOI:
1. Select Edit from the View DOI screen.
Copy DOI
To copy a Sub ID:
1. Select Copy from the View DOI screen.
Copying is useful when a new DOI is required that is similar to an existing one.
Once the Copy button is selected a new screen is displayed with the Paste button enabled. This indicates that a copy has occurred.
When the Paste button is selected, the screen is replaced with the copied data. You can change all the copied data including the Effective Date, Entity ID, and Sub ID.
DOI Exceptions
DOI exceptions should be created in situations where multiple DOIs are required for different purposes or activities, such as allocating royalties, facility charges, and sales. Each DOI exception references a DOI extension ID that links the DOI Sub ID to a product and an exception type for a specific effective date. Extension IDs can be up to two characters in length.
Royalty DOI Exception
For example, if your freehold/overriding/IOGC royalty is paid by different owners (or ownership) from your default DOI, you need to create a DOI exception and link the extension ID to the royalty.
1. Create the DOI for the royalty payors.
The Sub ID of the DOI will always be a greater than the Sub ID of your default DOI.
To create the exception:
1. Expand the DOI Exceptions accordion.
2. Stay on the Ownership tab and select the Edit button then the Create New button.
Action buttons include Save, Revert and Cancel.
3. Select the Create New button to add a new row.
CREATE OWNERSHIP/ROYALTY DOI EXCEPTION | |
|---|---|
Exception Type | Defaulted to Ownership. The Exception Type refers to the Royalty Type. Available options include:
|
Product | Defaulted to OIL. The product entered must be the product of the royalty. Available options include:
NOTE: If an exception is created for product C2, it will be used for products C2, C2MX and C2SP. Similarly, product C3 will be used for C3, C3MX, C3SP; product C4 for C4, C4MX, C4SP, IC4MX, IC4SP, NC4MX, NC4SP; product C5 for C5MX, C5CP, IC5MX, IC5SP, NC5MX and NC5SP; and C6 will be used for C6MX and C6SP. |
DOI Extension ID | A numeric value from 1-99. This is the extension ID linked to the royalty. If the Exception Type is OWNERSHIP, then the DOI Extension ID must be 1. |
Effective Date | The effective date of the exception. |
4. At the royalty obligation, enter the DOI Extension ID (from above).
The owners of the DOI Sub ID associated with the DOI extension will be displayed on the screen.
This freehold royalty will use the displayed DOI to identify the royalty payors.
Facility Charge DOI Exception
You can set up either an expense or revenue DOI exceptions for facility charges.
1. Create the DOI for the expense or revenue.
The Sub ID of the DOI will always be greater than the Sub ID of your default DOI.
2. To create the exception, expand the DOI Exceptions accordion.
3. From the Facility Charge tab, select the Edit button then the Create New button.
Action buttons include Save, Revert and Cancel.
4. Select the Create New button to add a new row.
CREATE FACILITY CHARGE DOI EXCEPTION | |
|---|---|
Product | Defaulted to NA. The product entered must be the product of the facility charge. Available options include:
NOTE: If an exception is created for product C2, it will be used for products C2, C2MX and C2SP. Similarly, product C3 will be used for C3, C3MX, C3SP; product C4 for C4, C4MX, C4SP, IC4MX, IC4SP, NC4MX, NC4SP; product C5 for C5MX, C5CP, IC5MX, IC5SP, NC5MX and NC5SP; and C6 will be used for C6MX and C6SP. |
DOI Extension ID | A numeric value from 1-99. This is the extension ID linked to the facility charge. |
Effective Date | The effective date of the exception. |
Charging Entity Type | Defaulted to and protected (most times) to the entity type of the entity ID. Available options include:
|
Charging Entity ID | Defaulted to and protected (most times) to the entity ID selected. The entity ID is where the charge occurs. |
Revenue/Expense | Defaulted to Revenue. Identified if this DOI exception is a Revenue or Expense DOI exception. Available options include:
|
5. Enter the DOI Extension ID (from above) at the facility charge.
Reminder: Qbyte Metrix looks for the Expense DOI Extension specified at each of the wells or tracts that participate in the charge. If the exception is not found at the participating entity, then it looks for the Expense DOI Extension at the Charge Facility (the facility the charge is set up on). If the exception is still not found, the default DOI at the participating well/tract will be used. When the Expense DOI Extension is left 0, the default DOI for each of the well/tracts that participate in the charge will be used. Qbyte Metrix looks for the Revenue DOI Extension at the Charge Facility. If the exception is not found, then it assumes that the revenue is to be allocated 100% to the Master Owner for the Region the Control Group is in. When the Revenue DOI Extension is left 0, the revenue is allocated 100% to the Master Owner for the Region the Control Group is in.
Navigation
Explorer
Select a facility from the hierarchy.
One of the options available on the right (as shown below) is DOI.
To access a well DOI:
1. Select the well and then the DOI option.
Selecting the DOI option from the Explorer takes you directly to the DOI Maintenance screen. Unit and Tract DOIs cannot be accessed from the Explorer screen.
Well DOI
The well DOI can be accessed via the Explorer → DOI Maintenance → Well Maintenance screen.
Unit DOI/Tract DOI
Unit and tract DOIs can be maintained from the DOI Maintenance screen and the Unit Maintenance screen.
Unit DOI
Tract DOI
Select the Wells and Tracts In Unit tab then the DOI tab within Tracts.
Facility DOI
Facility DOIs can be accessed by navigating to each Facility Maintenance (Battery, GGS, Plant, Injection) menu option (Master → Entities) and then selecting the DOI tab.
Reports
DOI Summary
DOI Details
Appendix
Ownership DOI Exception
If you have different ownership for your products (Oil vs Gas and By-Products), you will need to create an exception DOI of ownership.
For example, your default DOI applies to product Oil while for Gas and By-Products the ownership is different. Therefore, you need to create an exception DOI(s) to be used for Gas and By-Products.
If the entity is attached to a non-Gas Flow control group, then you will need to create a single DOI Sub ID for the Gas and By-Product ownership, in this example it is Sub 0020. You will then need to create a DOI Exception for each separate product that is being produced by the entity. For example, if the entity produces GAS, C2, and C3, then you will need to create a separate DOI Exception for each product.
If the entity is attached to a Gas Flow control group, then you still need to create a single DOI Sub ID for the Gas and By-Product ownership. However, you only need to create one DOI Exception for GAS since for Gas Flow the split to the WIOs is done at the wellhead prior to any processing of the gas into products.
1. Create the DOI applicable to product GAS.
This example assumes you already have a default DOI.
2. Create the ownership DOI exception for GAS.
The Production and Sales Distribution Details report will show you that the default DOI is applied to OIL while the exception DOI is applied to GAS and By-Products.
Royalty DOI Exception
If the freehold/override/IOGC royalty is paid by different owners, the default DOI a royalty DOI exception must be created.
For example, the overriding royalty for product OIL is paid by only some partners of the DOI.
1. Create the DOI exception.
2. Link the DOI Extension to the royalty obligation.
If the royalty obligation is a TIK royalty, the Production and Sales Distribution Details report will display the owners associated with the royalty.
If the royalty obligation is a non-TIK royalty, the Royalty Calculation Details Report will display the owners associated with the royalty.
Facility Charge DOI Exception
If the facility charge is paid (Expense) by the owners that flow through the facility, the fee is collected by the owners of the facility (Revenue).
If you operate the facility, you may decide not to expense yourself. Therefore, you will need to create DOI exceptions for Revenue/Expense.
Create a DOI exception for Expense purposes:
Create a DOI exception for Revenue purposes:
Link the DOI exception to the charge.
If the default DOI is to be used, leave it as 0.
The Facility Charge Distribution Detail report will show the DOIs used for the charge.
Copyright© 2024 IFS AB. Copying prohibited. All rights reserved.