SAMPLES AND ANALYSIS
Note: This guide is out of date and needs to be updated
About the Fluid Analysis Tables
The fluid analysis tables are inherited from PPDM version 2, with few modifications or enhancements. Consequently, business requirements are not fully addressed in the current version,although the tables have been generalized to support fluid analysis from a well, facilty, HSE incident etc. The tables are designed to capture most of the information on a typical laboratory report.
Fluid samples are often, though not always, taken from the well during a test. So the tables have foreign keys to the test type, run number, test number and source (see the SOURCE column description later in this section).
The model also has a table WELL_TEST_ANALYSIS. It is not as comprehensive as the fluid analysis tables, but is intended to capture information commonly reported for a well test (e.g., GOR, H2S, oil gravity). The source document may be the test report, whereas data in the fluid analysis tables is usually derived from the laboratory reports.
There are some inconsistencies in the design of the fluid tables, when comparing GAS_ANALYSIS, OIL_ANALYSIS, and WATER_ANALYSIS. For example, only the WATER_ANALYSIS has columns for laboratory name and analysis file reference.
SOURCE is used for two purposes: to identify the source of the data in the analysis table, and as part of the foreign key to WELL_TEST.SOURCE. If the source of data in WELL_TEST is not the same as the source for data in WELL_“fluid type”_ANALYSIS, the relationship cannot be established. To support this business requirement, add a column (compare well_treatment.well_test_source) and submit a change request to PPDM Association.
FLUID_TYPE column is only in the GAS_ANALYSIS table. It is part of the primary key, so it should be populated as gas or condensate. A similar column, well_water_anal.water_type, should have values such as water, salt water, formation water, load water, etc.
SAMPLE_LOCATION is the position in the well where the sample was taken (downhole or at surface). Reference values should be defined in R_SAMPLE_LOCATION.
REPORTED_TVD captures the true vertical depth, if included in the laboratory report. This depth may not be as accurate as what is derived from a directional survey (see WELL_DIR_SRVY), perhaps because the laboratory was provided with a preliminary number or because of a typographical error on the report. But if the source of an analysis is uncertain, this reported depth may help to resolve the confusion.
The TOP_STRAT_UNIT and BASE_STRAT_UNIT columns are intended to capture the formations as reported on the source document. They must be defined with the same STRAT_NAME_SET_NAME. If the values are not available from the source, we recommend these columns be left null. Do not copy values from STRAT_WELL_SECTION, as this would be too difficult to maintain.
LABORATORY_REFERENCE_NUM is the number or code on the source document. Note that this column is not part of the Primary Key (use ANALYSIS_OBS_NO instead, usually assigned by the data vendor or your system). It is used the same way as well_water_analysis.file_num.
STRING_ID in WELL_OIL_ANALYSIS is used to identify the source of the sample when taken from a production string in the well. The value should be a reference to prod_string.string_id.
