TimeSeries Configuration

summary the timeseries configuration table is the master registry of historian tags a historian tag is a digital id that identifies a specific measurement on a specific well the timeseries history docid\ lah15kjxitejxtlddptlh table relates to this registry by sourceid each configuration entry belongs to a single well, specified as sourcewellid each well can have one tag of each measurement type (e g whp, oilrate) the unique constraint on this table is ( sourcewellid + sourceid + measurement ) timeseries configuration for a given sourceid must be added to the system before attempting to add timeseries history to that sourcetimeseriesid variable data type is nullable? description sourcewellid string no source id for the well from wellview wvwellheader table, idwell column from openwells cd well table, well id column sourceid string no time series tag identifier osi pi use tag id xxx yyy zzz osi pi af use attributeid \\\server\\\element\\\attributeid measurement string no see section below for possible values unit string yes unit of measure the uom in this field must match the documented uom for the measurement, as listed below time series measurement values time series measurements must be provided from the following list of possible values prodx forces standardization to enable high frequency data to be used in modeling and comparative visualization rates oilrate stb/d gasrate mscf/d gasliftinjectionrate mscf/d (actual gas lift injection rate) gasliftinjectionratesetpoint mscf/d (control system gas lift injection rate setpoint) waterrate stb/d sandrate g/s pressures whp psig (wellhead/tubing head pressure) chp psig (casing pressure) dhgp psig (downhole gauge pressure) dhgp discharge psig (downhole gauge pressure at pump discharge) pressureupstream psig (upstream choke pressure / flowline pressure) pressuredownstream psig (downstream choke pressure tubing side) pressure downstream annulus psig (downstream choke pressure annulus side) hpseparatorpressure psig lpseparatorpressure psig temperatures wht degf (wellhead/tubing temp) cht degf (casing temp) dhgt degf (downhole gauge temp) flowlinetemperature degf other choke % wellcyclingflag unitless (flag indicating the cycling status of the well) esp drive esp vsd heat sink temp degf esp vsd bus voltage volts esp vsd current amps esp vsd voltage volts motor esp motor current amps esp motor frequency hz esp motor temperature degf esp motor voltage volts controller esp high speed clamp hz esp low speed clamp hz esp current limit amps esp current setpoint amps esp control mode unitless (1 = frequency mode, 2 = pid rate control, 3 = pid amps control) general esp intake pressure psig esp discharge pressure psig esp fluid temperature degf esp runtime hours (hours of cumulative runtime today) esp vibration x g esp vibration y g sucker rod pump srp polished rod load lb srp polished rod position in srp pump fillage % srp pump intake pressure psig srp stroke rate strokes/min srp runtime minutes (minutes of cumulative runtime today) plunger plunger event unitless (valve open = 0, valve closed = 1, or plunger arrived = 2) deprecated the following values are still accepted for backwards compatibility but should not be used in new integrations sandind condrate flowlinepressure data integrity checks condition response sourcewellid does not exist in the well table record rejected and current batch aborted measurement is not one of the values above record rejected any non nullable field is null record rejected if any record in a post references an unknown sourcewellid , the whole batch is aborted — records earlier in the payload are not committed common error messages api scenario error response add / upsert configuration unknown sourcewellid well with source id xxx was not found, current batch aborted