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 |
Condition | Response |
|---|---|
sourceTimeSeriesId does not appear in the TimeSeries Configuration table | Record Rejected |
sourceWellId, sourceTimeSeriesId, timestamp, or value is null | Record Rejected |

