Wellbore Formation

the wellbore formation table represents the rock and fluid properties of the subsurface reservoir (formation) from which fluids are produced in most cases a wellbore produces from a single formation, but a wellbore can produce from two or more formations the unique constraint on wellbore formation entries is 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 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, to enable upserts commonly this matches the name sourcewellid string no must match the sourceid of a record in the well docid\ p xhbe4jqkjqemay7aol5 table sourcewellboreid string no must match the sourceid of a record in the wellbore docid\ xpqwcas8awdawyssmvjy6 table startdate datetime offset yes 1900 01 01t00 00 00 +0000 datetime 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 (0 0 1 0) compressibilityrock double 1/psi yes 3e 6 formation rock compressibility pressureformationinitialdatum double psia no initial reservoir pressure temperatureformationdatum double degf no reservoir temperature 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 double stb/scf yes condensate gas ratio watergasratio double stb/scf yes 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 double scf/stb yes 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, startdate can be null and the properties apply for the entire life of the well for wells with changing fluid and rock properties over time, null is treated as 1900 01 01t00 00 00 +0000 (although non null startdate values are preferred), and subsequent valid datetimes trigger the change in properties in the modeling process for formations which change over time, the name / sourceid must be consistent for every entry of that formation — otherwise it is assumed the well has multiple formations/producing zones that vary over time name notes it is critical to keep the formation name consistent when adding multiple entries for a formation over time as allocation factors and fluid properties vary over time, the name is the common link between the records allocation factor notes if the allocation factor is null, it is assumed to be 1 (100%) when the wellbore has a single formation when the wellbore has multiple formations, a normalization reconciles the sum of allocation factors to 1 using the best data available initial oil saturation notes if saturationoilinitial is null, it defaults to (1 saturationwaterinitial) initial gas saturation notes if saturationgasinitial is null, it defaults to 0 0 data integrity checks condition response any non nullable field is null or empty record rejected (sourcewellid, sourcewellboreid) does not match an existing wellbore row skipped partial success on bulk ingest rows referencing an unknown wellbore are skipped while the remaining rows are written the error response names each skipped row, e g "formation with sourceid 'xxx' was skipped wellbore with sourcewellid 'xxx' and sourcewellboreid 'xxx' was not found" an error response therefore does not mean nothing was written common error messages api scenario error response add / upsert formation unknown wellbore formation with sourceid 'xxx' was skipped wellbore with sourcewellid 'xxx' and sourcewellboreid 'xxx' was not found 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 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 fluidmolarfracn2 ✅ pvt ✅ pvt fluidmolarfracco2 ✅ pvt ✅ pvt fluidmolarfrach2s ✅ pvt ✅ pvt