pplAnomalyInventory

time

GMTtime(int)

The time the data was written to the Historical database.

offset

GMToffset(smallint)

The minute offset of this timezone from Greenwich Mean Time (GMT).

pipeline

nameType(varchar(32))

The pipeline that contains the anomaly.

anomaly_name

nameType(varchar(32))

The name of the anomaly.

pipeseg

nameType(varchar(32))

The pipe segment that the anomaly is in.

pipeoffset

float

The volume offset of the anomaly from the upstream end of the pipe segment.

anomaly_type

nameType(varchar(32))

The type of anomaly.

volFromPplStartNode

float

The volume amount that is between the position of the anomaly and the starting node.

distFromPplStartNode

float

The distance between the position of the anomaly and the starting node.

etaToPplEndNode

nameType(varchar(60))

Estimated time of arrival (ETA) of the anomaly to the end node on the pipeline. The ETA is represented in the date/time format.

pplStartNode

nameType(varchar(32))

The name of the starting node of the pipeline.

pplEndNode

nameType(varchar(32))

The name of the end node of the pipeline.

volUnit

nameType(varchar(15))

The volume unit.

lengthUnit

nameType(varchar(15))

The length unit.

ownSysId

tagIDType(int)

The ID number of the owning system of the anomaly.

datasetId

tagIDType(int)

The ID number of the dataset of the anomaly.

extension

NVARCHAR(MAX)

A field where extended anomaly inventory data from the extension plugin is stored in string format.