CollectS0 table
- Last UpdatedApr 24, 2025
- 1 minute read
The following table describes the fields in the collectS0 Table of the PlmCollect database.
|
Internal Field |
Data Type |
Description |
|---|---|---|
|
tagId |
tagIDType |
Collect tag identifier (ID). |
|
time |
GMTtime |
Time of data collection, Greenwich Mean Time (GMT). |
|
offset |
GMToffset |
Offset to local time zone. |
|
plminh |
statusType |
Pipeline Monitor (PLM) manually inhibited. Possible values are:
|
|
autoinh |
statusType |
PLM automatically inhibited. Possible values are:
|
|
low_flow |
statusType |
PLM at low-flow. Possible values are:
|
|
slack |
statusType |
PLM at slack. Possible values are:
|
|
status |
statusType |
Status of PLM. Possible values are:
|
|
alm |
statusType |
PLM in alarm. Possible values are:
|
|
almtype |
statusType |
PLM alarm type. Possible values are:
|
|
period |
tinyint |
The number of mins. or hours. |
|
dev |
realType |
Volume deviation. |
|
devpct |
realType |
Volume deviation / metering. |
|
dlf |
realType |
Delta line fill. |
|
mtrin |
doubleType |
Metered input. |
|
mtrout |
doubleType |
Metered output. |
|
dflow |
doubleType |
Delta flow. |
|
tnkchg |
realType |
Tank volume change. |
|
balfact |
realType |
Balance tuning factor. |
|
overvolalm |
realType |
Over volume dynamic alarm limit. |
|
shrtvolalm |
realType |
Shrt volume dynamic alarm limit. |
|
overflwalm |
realType |
over %flow dynamic alarm limit. |
|
shrtflwalm |
realType |
Shrt %flow dynamic alarm limit. |
|
rampstate |
statusType |
Ramping state of PLM to indicate if a dynamic alarm limit was in effect for a particular term. Possible values are: • Y • N Note: For the CollectS0, CollectX1, CollectX2, and CollectX3 tables, the value will always be N because dynamic alarm limits are not applicable for these terms. For other Collect tables, this value will be populated based on the rampstate field originating from the RealTime database PLM table. |