TimeSeries History

this table stores the historic values of timseries tag measurement readings the measurement reading will be numeric the unique constraint on this table is sourcewellid + sourcetimeseriesid + timestamp timeseries configuration for a given sourcetimeseriesid 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 sourcetimeseriesid string no time series tag identifier which must already exist in timeseries configuration osi pi use tag id xxx yyy zzz osi pi af use attributeid \server\element\attributeid timestamp datetime offset no datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37+0000 value double no the numeric value of the measurement data integrity checks condition response sourcetimeseriesid does not appear in the timeseries configuration table record rejected sourcewellid, sourcetimeseriesid, timestamp, or value is null record rejected