pplBatchSequence

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 batch.

batchID

nameType(varchar(31))

The ID of the batch that was provided to Batch Tracking by the Batch Transfer or Virtual Flow Computer applications.

batchName

batchnameType

The name of the batch that was automatically generated by Batch Tracking.

density

float

The density of the batch.

continuousVol

float

The total volume of the batch.

volFromPplStartNode

float

Volume from the pipeline start node to the batch.

distFromPplStartNode

float

Distance from the pipeline start node to the batch.

volToPplEndNode

varchar(15)

Volume from the batch to the pipeline end node.

etaToPplEndNode

varchar(60)

Estimated time of arrival of the batch to the pipeline end node.

prodtype

nameType(varchar(32))

The product type of the batch.

pplStartNode

nameType(varchar(32))

The name of the pipeline start node.

pplEndNode

nameType(varchar(32))

The name of the pipeline end node.

mass

float

The mass of the batch.

massUnit

varchar(15)

The unit used for mass.

volUnit

varchar(15)

The volume unit.

densUnit

varchar(15)

The density unit.

lengthUnit

varchar(15)

The length unit.

ownSysId

tagIDType(int)

The ID number of the owning system of the batch.

datasetId

tagIDType(int)

The ID number of the dataset of the batch.

extension

NVARCHAR(MAX)

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