Volume Data Model

Volume ERD

Figure 1. Volume ERD

Volume Tables Description

Table	Description
PRODUCT_VOLUME_SUMMARY	A summary of reported volumes for different types of fluids over a specified time period.
RPEN_ALLOCATION_FACTOR	This table represents a factor used in calculations to allocate production from one entity to another.
REPORTING_ENTITY	This Table represents reporting entity against which production data will be reported (ex. Lease, Well, Wellbore, Company, reservoir Etc.). This table will only be a placeholder for the actual data of entity and will be linked with actual data tables (Ex. Well) of entity in case complete information required for entity.
R_REPORTING_ENTITY_KIND	This table is reference and will store reporting entity kinds. For example, Well, Wellbore, Facility, Field etc.
R_REPORTING_PRODUCT	This table is a reference table and will store reporting product types of Ex. Oil, Water, Gas. The product kinds stored in this table will be linked with PRODUCT_VOLUME_SUMMARY table
R_PRODUCT_CATEGORY	This is a reference table for R_REPORTING_PRODUCT and it will store Product categories like Product Fluid, Service Fluid.
R_REPORTING_FLOW	This table is used to store information for the types of volumes flow. Ex. Open Inventory, Closing Inventory, Production, Injection Disposition.
R_QUANTITY_METHOD	It specifies the available methods for deriving a quantity or volume. Ex. Allocated, Allowed, Estimated, Target, Measured, Budget, Forecast Etc.
R_PERIOD_KIND	Specifies the periods of volume for reporting Entities. Such as Month, Day, Year to Date etc.
PRESSURE_TEMPERATURE	The pressure and temperature conditions of the measurement have a profound impact on the underlying ``value'' of the measurement. This table is used to store the reference conditions for pressure and temperature. The conditions are extensible, allowing for local measurement condition standards to be used.
R_ALLOCATION_TYPE	A reference table identifying the type of allocation factor that is used in calculations to attribute (allocate) a measured movement of fluid to several production entities.

Table

Description

PRODUCT_VOLUME_SUMMARY

A summary of reported volumes for different types of fluids over a specified time period.

RPEN_ALLOCATION_FACTOR

This table represents a factor used in calculations to allocate production from one entity to another.

REPORTING_ENTITY

This Table represents reporting entity against which production data will be reported (ex. Lease, Well, Wellbore, Company, reservoir Etc.). This table will only be a placeholder for the actual data of entity and will be linked with actual data tables (Ex. Well) of entity in case complete information required for entity.

R_REPORTING_ENTITY_KIND

This table is reference and will store reporting entity kinds. For example, Well, Wellbore, Facility, Field etc.

R_REPORTING_PRODUCT

This table is a reference table and will store reporting product types of Ex. Oil, Water, Gas. The product kinds stored in this table will be linked with PRODUCT_VOLUME_SUMMARY table

R_PRODUCT_CATEGORY

This is a reference table for R_REPORTING_PRODUCT and it will store Product categories like Product Fluid, Service Fluid.

R_REPORTING_FLOW

This table is used to store information for the types of volumes flow. Ex. Open Inventory, Closing Inventory, Production, Injection Disposition.

R_QUANTITY_METHOD

It specifies the available methods for deriving a quantity or volume. Ex. Allocated, Allowed, Estimated, Target, Measured, Budget, Forecast Etc.

R_PERIOD_KIND

Specifies the periods of volume for reporting Entities. Such as Month, Day, Year to Date etc.

PRESSURE_TEMPERATURE

The pressure and temperature conditions of the measurement have a profound impact on the underlying ``value'' of the measurement. This table is used to store the reference conditions for pressure and temperature. The conditions are extensible, allowing for local measurement condition standards to be used.

R_ALLOCATION_TYPE

A reference table identifying the type of allocation factor that is used in calculations to attribute (allocate) a measured movement of fluid to several production entities.