pplPipeInventory

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))

Name of the pipeline.

pipeseg

nameType(varchar(32))

The name of the pipe segment.

upsstation

nameType(varchar(32))

The upstream station for the pipe segment.

dnsstation

nameType(varchar(32))

The downstream station for the pipe segment.

seqno

int

The sequence number for the pipe segment.

cumLpack

float

The total linepack volume in the pipeline up to and including the upstream pipe segment to which the node is attached.

The value captured in this field does not take into account the impact of branching and merging in the pipeline.

pave

float

The average pressure of the pipe segment.

tave

float

The average temperature of the pipe segment.

Lpack

float

The linepack volume of the pipe segment.

volUnit

varchar(15)

The unit used for volume.

tempUnit

varchar(15)

The unit used for the temperature.

presUnit

varchar(15)

The unit used for pressure.

ownSysId

int

The ID number of the owning system.

datasetId

int

The ID number of the dataset for the pipeline.

extension

NVARCHAR(MAX)

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

mass

float

The mass of the batch.

cumulativeMass

float

The total mass in the pipeline up to and including the upstream pipe segment to which the node is attached.

The value captured in this field does not take into account the impact of branching and merging in the pipeline.

massUnit

varchar(15)

The unit used for mass.