Well Test

the well test table stores individual well test measurements well tests overlay on production charts and can be compared with allocated volumes the uwi field must match a uwi in the well docid\ p xhbe4jqkjqemay7aol5 table the table supports a variety of test types welltest, tracer, cgr, and salinity the default is welltest, a standard production volume measurement through a test separator the unique constraint on well test entries is uwi + sourceid if sourceid is not supplied, the test's date is used as its sourceid — so clients that never send sourceid effectively get one test per well per date, and re posting the same date upserts it variable data type unit of measure is nullable? default value description uwi string no unique well identifier must match the uwi of a record in the well docid\ p xhbe4jqkjqemay7aol5 table sourceid string yes date unique identifier of the test enables upsert from a source system of record if not specified, the test's date is used date datetime offset no test date datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37 +0000 type string yes welltest type of the well test welltest standard measurement through a test separator tracer cgr salinity isvalid boolean yes true whether the well test is valid invalid tests are stored but excluded from analysis oilrate double stb/d yes oil rate gasrate double mscf/d yes gas rate waterrate double stb/d yes water rate tubingpressure double psig yes tubing / wellhead pressure tubingtemperature double degf yes tubing / wellhead temperature casingpressure double psig yes casing pressure casingtemperature double degf yes casing temperature gaugepressure double psig yes downhole gauge pressure (a downhole gauge must exist in the downhole equipment table) gaugetemperature double degf yes downhole gauge temperature (a downhole gauge must exist in the downhole equipment table) choke double % yes choke opening upstreamchokepressure double psig yes upstream choke pressure downstreamchokepressure double psig yes downstream choke pressure basicsedimentandwater double % yes basic sediment and water percentage duration double hrs yes well test duration separatorpressure double psig yes test separator pressure separatortemperature double degf yes test separator temperature gasliftinjectionrate double mscf/d yes gas lift injection rate during the test watergasratio double stb/mmscf yes water/gas ratio measured by the test condensategasratio double stb/mmscf yes condensate/gas ratio measured by the test salinity double ppm yes salinity measured by the test data integrity checks condition response uwi is null or empty record rejected uwi does not exist in the well table record rejected type is null or empty value defaults to welltest isvalid is null or empty value defaults to true sourceid is null or empty value defaults to the date common error messages api scenario error response add / upsert well test unknown uwi well with uwi xxx was not found