pplFragmentInventory
- Last UpdatedApr 24, 2025
- 2 minute read
The pplFragmentInventory table stores data for all fragments in the pipeline when inventory is completed.
|
Internal Field |
Data Type |
Description |
|---|---|---|
|
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 the fragment is in. |
|
pipeseg |
nameType(varchar(32)) |
The name of the pipe segment the fragment is in. |
|
fragseqno |
Int |
The sequence number of the fragment. |
|
batchName |
batchnameType |
The name of the batch to which the fragment belongs. |
|
batchID |
batchnameType(varchar(31)) |
The ID of the batch to which the fragment belongs. |
|
fragsize |
float |
The volume size of the fragment. |
|
headvoloffset |
float |
The volume offset of the fragment from the head. |
|
volUnit |
varchar(15) |
The volume unit. |
|
ownSysId |
tagIDType(int) |
The ID number of the system that owns the batch. |
|
datasetId |
tagIDType(int) |
The ID number of the batch of the dataset. |
|
section |
nameType(varchar(32)) |
The name of the section the fragment is in. |
|
section_seq |
Int |
The section sequence number. |
|
segment_seq |
Int |
The segment sequence number. |
|
prdtyp |
nameType(varchar(32)) |
The product type of the batch on the fragment. |
|
gravity |
float |
The average density of the batch of the fragment. |
|
milepost |
float |
The distance of the fragment in the pipe segment. |
|
prdgrp |
nameType(varchar(32)) |
The product group of the product type in the fragment. |
|
baseDensity |
float |
The base density of the fragment. |
|
legCapacity |
float |
The capacity, measured in volume, that the fragment takes up in the pipe segment. |
|
avgTemp |
float |
The average temperature of the fragment. |
|
avgPres |
float |
The average pressure of the fragment. |
|
tf |
float |
The temperature correction factor. |
|
pf |
float |
The pressure correction factor. |
|
cts |
float |
The correction factor for temperature on steel. |
|
cps |
float |
The correction factor for pressure on steel. |
|
extension |
NVARCHAR(MAX) |
A field where extended fragment inventory data from the extension plugin is stored in string format. |
|
mass |
float |
The mass of the fragment. |
|
massUnit |
varchar(15) |
The unit used for mass. |