Wellbore Formation

the wellbore formation represents the rock properties and the fluid properties within the subsurface reservoir (formation) from where the fluids are being produced in most cases a wellbore will only produce from one formation, however there are cases where wellbore will produce from two or more formations the unique constraint on wellbore formation entires is sourcewellid + sourcewellboreid + sourceid + startdate the is nullable? column below reflects whether the api will accept or reject a record to facilitate a streamlined data ingest process and subsequent validation / cleanup please refer to the data requirements for modeling section for a more precise summary of the data requirements for well modeling variables in red below will be deprecated in a future release and are no longer required variable data type unit of measure is nullable? default value description sourceid string no unique source id for the formation commonly this will match the name sourcewellid string no must match the sourceid of the well table sourcewellboreid string no must match the sourceid of the wellbore table startdate datetime offset yes 1900 01 01t00 00 00+0000 datetime that the formation properties become applicable datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37+0000 name string no name of the wellbore formation allocationfactor double decimal percent yes 1 0 allocation of production assigned to this formation compressibilityrock double 1/psi yes 3e 6 formation rock compressibility pressureformationinitialdatum double psia no the initial reservoir pressure value temperatureformationdatum double degf no the reservoir temperature value depth double ft no measured depth of the formation top thicknessformation double ft yes thickness of the formation porosity double decimal percent yes porosity of the formation saturationwaterinitial double decimal percent yes initial water saturation saturationgasinitial double decimal percent yes 0 0 initial gas saturation saturationoilinitial double decimal percent yes initial oil saturation primaryfluidtype string no oil oil gas water rsi double scf/stb no initial solution gas oil ratio condensategasratio condensategasratio double double stb/scf stb/scf yes yes condensate gas ratio condensate gas ratio watergasratio watergasratio double double stb/scf stb/scf yes yes water gas ratio water gas ratio originalgasinplace double scf yes estimated original gas in place originaloilinplace double stb yes estimated original oil in place volumeacquiferinitial double stb yes initial aquifer volume fluidgravityapi double api degrees no oil api gravity fluidgravitygas double specific gravity no gas specific gravity fluidsalinitywater double ppm no water salinity fluidcomingledgor fluidcomingledgor double double scf/stb scf/stb yes yes gas oil ratio of the co mingled fluid in multi wellbore wells gas oil ratio of the co mingled fluid in multi wellbore wells fluidmolarfracn2 double decimal percent yes 0 0 molar fraction n2 fluidmolarfracco2 double decimal percent yes 0 0 molar fraction co2 fluidmolarfrach2s double decimal percent yes 0 0 molar fraction h2s langmuirpressure double psig yes langmuir pressure (for coal seam gas reservoirs) langmuirvolume double scf/ft yes langmuir volume (for coal seam gas reservoirs) initialgascontent double scf/ft yes initial gas content (for coal seam gas reservoirs) bulkdensity double lb/ft3 yes bulk density (for coal seam gas reservoirs) start date notes for wells with constant fluid and rock properties over time, this can be null and the properties will apply for the entire life of the well for wells with changing fluid and rock properties over time, null will be treated as 1900 01 01t00 00 00+0000 (although non null startdate values are preferred) and subsequent valid datetimes will trigger the change in properties in the modeling process note for formations which change over time, the name / sourceid field must be the consistent for every entry of that formation or it will be assumed that the well has multiple formations/producing zones that vary over time name notes it is critical to ensure consistency in formation name when adding multiple formations for a wellbore over time as allocation factors and fluid properties vary over time, the name will be the common link between the records allocation factor notes if the allocation factor is null, it will be assumed to be 1 (or 100%) if the wellbore has a single formation if the wellbore has multiple formations, a normalization will occur to attempt, using the best data available, to reconcile the sum of allocation factors to 1 initial oil saturation notes if the saturationoilinitial value is null, then the default saturationoilinitial value will be calculated at (1 saturationwaterinitial) initial gas saturation notes if the saturationgasinitial value is null, then the default saturationgasinitial value will be 0 0 data integrity checks condition response name or sourcewellboreid is null or empty record rejected name or sourcewellboreid does not exist record rejected data requirements for modeling variable required for unconventional wells? unconventional models required for conventional wells? conventional models sourceid sourcewellid sourcewellboreid startdate only if properties change only if properties change name allocationfactor composite fluid properties for the well material balance compressibilityrock dynamic drainage volume, pibf shut in radial flow, material balance pressureformationinitialdatum dynamic drainage volume material balance temperatureformationdatum dynamic drainage volume, bottomhole pressure, pibf shut in radial flow, material balance depth bottomhole pressure bottomhole pressure thicknessformation shut in radial flow porosity shut in radial flow, material balance saturationwaterinitial shut in radial flow, material balance saturationgasinitial material balance saturationoilinitial primaryfluidtype rsi pvt pvt condensategasratio condensategasratio watergasratio watergasratio originalgasinplace gas well material balance originaloilinplace oil well material balance volumeaquiferinitial aquifer modeling (material balance) fluidgravityapi pvt pvt fluidgravitygas pvt pvt fluidsalinitywater pvt pvt fluidcomingledgor fluidcomingledgor fluidmolarfracn2 pvt pvt fluidmolarfracco2 pvt pvt fluidmolarfrach2s pvt pvt