Wellbore Deviation Survey

a deviation survey is a measurement of the three dimensional path of a wellbore, performed with magnetic or gyroscopic instrumentation measurements are taken at frequent intervals (stations) along the wellbore the unique constraint on deviation survey entries is sourcewellboreid + sourceid variable data type unit of measure is nullable? default value description sourceid string no source id for the survey point from wellview wvwellboredirsurveydata table, idrec column from openwells cd survey station table, survey id column sourcewellid string no source id for the well from wellview wvwellboredirsurveydata table, idwell column from openwells cd survey station table, well id column sourcewellboreid string no source id for the wellbore from wellview wvwellboredirsurveydata table, idrecparent column from openwells cd survey station table, wellbore id column md double ft no measured depth inc double decimal degrees yes inclination azi double decimal degrees yes azimuth tvd double ft no true vertical depth deviation survey notes each well should have at least three deviation survey points; typically a survey contains numerous points describing the well trajectory if fewer than three points are provided, the well model may not compute data integrity checks condition response sourceid, sourcewellid, sourcewellboreid, md, or tvd 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 an error response therefore does not mean nothing was written common error messages api scenario error response add / upsert survey unknown wellbore deviationsurvey with sourceid 'xxx' was skipped wellbore with sourcewellid 'xxx' and sourcewellboreid 'xxx' was not found