Data Schema
Well
TimeSeries Configuration
summary the timeseries configuration table is the master registry of historian tags historian tags are digital ids which relate to a specific measurement on a specific well the timeseries history table is related to this configuration registry table by sourceid each timeseries configuration entry belongs to a single well the well is specified in this table as sourcewellid each well can have 1 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 well from wellview table wvwellheader use idwell column from openwells table cd well use 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 note uom in this field must match the documented uom for the measurement as described above 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 pressure) chp psig (casing pressure) dhgp psig (downhole gauge pressure) pressureupstream psig (upstream choke pressure / flowine pressure) pressuredownstream psig (downstream choke pressure) hpseparatorpressure psig lpseparatorpressure psig temperatures wht degf (wellhead/tubing 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 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