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 sourceId, meaning that the sourceId (tag identifier) must be globally unique.
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 (wellhead/tubing pressure) WHT - degF (wellhead/tubing temp) CHP - psig (casing pressure) DHGP - psig (downhole gauge pressure) DHGT - degF (downhole gauge temp) OILRATE - STB/d GASRATE - Mscf/d GASLIFTINJECTIONRATE - Mscf/d WATERRATE - STB/d SANDRATE - g/s PRESSUREUPSTREAM - psig (upstream choke pressure) PRESSUREDOWNSTREAM - psig (downstream choke pressure) |
unit | String | Yes | Unit of measure |
![Doc contributor](https://s3.amazonaws.com/archbee-animals/gorilla.png)