This dialog box is commonly used when you import well data from a database. You can import well production, attributes, fluid properties, wellbore configurations, and declines (Aries only). Mappings for each connection are saved and shared with all users for the current Harmony Enterprise database.
This dialog box has the following icons:
-
Learn more about Database Mappings — opens this topic for the Assign Mapping dialog box. -
Open the View Definition PDF file — opens a PDF that summarizes the view definitions for the data fields that can be imported and the expected format.
Views:
To import data from your internal database into Harmony Enterprise, views / tables in your database (Client Tables / Views) must be mapped to the corresponding Harmony Enterprise view.
- ARIES_DECLINE_ANALYSES — supports Arps’ decline analyses formatted from Aries.
- PRODUCTION_HISTORY — historical production rates and volumes including custom datasets. Custom datasets must be created in Harmony Enterprise before they can be imported.
- WELL_INFORMATION — well attributes and reservoir properties including custom attributes.
Important: Custom attributes must be created in Harmony Enterprise before they can be imported. For more information, see custom attributes. - RESERVOIR_PROPERTIES — general initial reservoir properties, such as initial reservoir pressure, temperature, and saturations.
- GAS_PROPERTIES_HISTORY — gas gravity and produced gas composition. Can accommodate multiple PVT test results over time, or a single result.
- LIQUID_RICH_GAS_PROPERTIES — condensate gravity along with CGR and recombined gas rate.
- OIL_PROPERTIES — oil gravity, bubble point pressure, and initial GOR.
- OIL_CALIBRATION_PROPERTIES — calibration pressure, temperature, formation volume factor, compressibility, and viscosity.
- SEPARATOR_PROPERTIES — temperature and pressure in the separator.
- CUSTOM_GAS_PVT_PROPERTIES — custom gas formation volume factor table.
- CUSTOM_GAS_VAPORIZED_OIL_PROPERTIES — custom vaporized oil ratio table.
- CUSTOM_GAS_VISCOSITY_PROPERTIES — custom gas viscosity table.
- CUSTOM_VISCOSITY_OIL_PROPERTIES — custom oil viscosity table.
- CUSTOM_SATURATED_OIL_PROPERTIES —oil formation volume factor and solution gas oil ratio custom tables below bubble point.
- CUSTOM_UNSATURATED_OIL_PROPERTIES — oil formation volume factor and solution gas oil ratio custom tables above bubble point.
- WATER_PROPERTIES — water gravity, salinity, viscosity, compressibility, formation volume factor, and solution gas water ratio.
- SHALE_PROPERTIES — shale Langmuir volume, shale Langmuir pressure, and bulk density.
- WELLBORE_CONFIG — configuration name, date and ID, as well as datum, flow path, and pressure loss calculation correlation.
- WELLBORE_CONFIG_DETAILS — top and bottom casing depths, tubing and perforations, along with casing and tubing diameters. Deviation surveys and detailed temperature profiles are also defined here.
- PVT_PROPERTY_CORRELATION — sets all correlations used in the Properties editor along with the Gas Type.
Columns:
After mapping your views / tables to the Harmony Enterprise incoming views, the columns within these views must be mapped. For numeric columns that have been mapped, specify the units that these values use in your database.
| Note: | For well information, you can assign a field to more than one column, and you do not have to map production data. |
Errors and minimum requirements
Every table that is mapped must have at least the well key and one other column specified. (The well key is the identifier used in the source database to separate wells.)
When there are errors in the database mapping, a red X is displayed next to the Harmony Enterprise Views (destination) and the Harmony Enterprise Column Name. At the top of the Assign Mapping dialog box, an error count is listed. Errors may include missing identifiers, or mapping a column of an inconsistent data type (for example, mapping text to numeric Harmony Enterprise data).