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 |
|
unit | String | Yes | Unit of measure. Note: UoM in this field must match the documented UoM for the measurement as described above |
