TimeSeries Configuration
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
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 | CHOKE - % WHP - psig WHT- degF DHGP - psig DHGT - degF OILRATE - STB/d GASRATE - Mscf/d WATERRATE- STB/d SANDRATE - g/s PRESSUREUPSTREAM - psig PRESSUREDOWNSTREAM - psig |
unit | String | Yes | Unit of measure |

