Tank table details
- Last UpdatedApr 24, 2025
- 9 minute read
The tank table is used by the Tank Management application. Each record in the tank table contains configuration data and runtime data for a tank. The tank table contains the following internal fields:
|
Internal Field Name |
Data Type |
Description |
|---|---|---|
|
alertList |
alertTypeTank |
A structure of information about fields associated with the Email Alarm Notification application. Some of the fields in the structure are described below. |
|
alertList.alertGrp |
alertGroupslot |
The name of the alertGroup record containing the Controllers and/or Administrators who will receive messages about alarms associated with this point. |
|
alertList.almType |
oas_boolean_t |
Are the alarms associated with this point AVEVA Enterprise SCADA-related? |
|
alertList.enable |
oas_boolean_t |
Enable the record for email alarm notification? |
|
alertList.enStates |
bool14 |
The types of alarms that will generate email messages. |
|
ambient_temp |
double |
The ambient temperature. |
|
ambient_tempslt |
analogslot |
The analog value for the outside temperature. |
|
anadens_type |
densitysourceenum |
Defines the density source. |
|
API_gravity |
double |
American Petroleum Institute (API) gravity at current temperature. |
|
auto_idle |
oas_boolean_t |
Set the tank into an Auto Idle state? |
|
counter_db |
float |
Counter deadband value. |
|
countersGOV.doit |
oas_boolean_t |
Enable the Gross Observed Volume (GOV) counters? |
|
countersGSV.doit |
oas_boolean_t |
Enable the Gross Standard Volume (GSV) counters? |
|
counter_lastGOV |
double |
Last volume used by counter. |
|
counter_type |
enum_counter |
How the throughput counters operate (in/out/sum/diff). |
|
creepCheckCycle |
long |
How often the tank will perform a check for a deviation in the level. |
|
creepCheckCycleText |
timestring |
How often the tank will perform a check for a deviation in the level. |
|
creepCheckTime |
internaltime |
Time the last creep threshold violation check was done. |
|
creepThreshViolationCount |
int |
Number of creep threshold violation checks completed. |
|
creepThreshViolationLimit |
int |
This field will determine how many creep violations will be allowed before a creep alarm is issued. |
|
curr_dens |
double |
Current observed density from the analog database. |
|
curr_temp |
double |
Current temperature from the analog database. |
|
currentGO |
tanklevel |
Current Gross Observed (GO) level and volume. |
|
currentGS |
tanklevel |
Current Gross Standard (GS) level and volume. |
|
cycle_txtper |
timestring |
How often the Tanking application calculates the average flow rate. |
|
cycle_period |
long |
How often the Tanking application calculates the average flow rate. |
|
cycle_time |
internaltime |
Time the last flow rate was calculated. |
|
dataset |
doas_dset_slot |
This field indicates the dataset to which the record is assigned. Datasets are used to associate the record with the privileges assigned for each system mode. Once a record is assigned to a dataset value, the dataset can only be changed to a value for which the system has a privilege record. |
|
dens |
analogslot |
The analog point that supplies observed density information about this tank. |
|
dens_unitDisp |
string10 |
Density units to be displayed. |
|
densCorr |
oas_boolean_t |
Has the value for density been subject to correction? |
|
description |
pntdescription |
A description of this analog point, up to 47 characters in length. |
|
displayLevelFormat |
strapfraction |
The level fraction format that will be used for the Advanced Database Editor (ADE) and eXtended Operator Station (ezXOS) displays (including alarm limits, level limits, and alarm messages). |
|
doroc |
oas_boolean_t |
Indicates whether the rate of change alarm has been generated. |
|
do_shell_corr |
oas_boolean_t |
Correct for the effect of the ambient temperature? |
|
egu |
units |
Tank volume engineering units. |
|
eguTarget |
units |
Tank volume target engineering units. |
|
enable_point |
path |
If the selected status point is in an abnormal state, then the application will no longer process this tank record. |
|
engr.egumax |
float |
The highest measurable values of the instrument in Engineering Units (EGUs). |
|
engr.egumin |
float |
The lowest measurable values of the instrument in EGUs. |
|
engr.rawmax |
float |
The instrument’s raw upper operating limits. |
|
engr.rawmin |
float |
The instrument’s raw lower operating limits. |
|
engr.scaleraw |
oas_boolean_t |
Convert raw instrument electrical values from this point to EGUs? |
|
equipno |
string10 |
A unique alphanumeric string to identify the tank for accounting purposes. |
|
fillempty.enableTarg |
oas_boolean_t |
Enable the tank target Indicated Volume (IV) and/or GSV calculations? |
|
fillempty.warn_tt_txt |
timestring |
Target warning times. |
|
flag |
flags |
For information on the flag structure, see Flag structure details. |
|
flevel |
double |
Current tank float level. |
|
flowrateUnitShort |
string16 |
Flow rate units (short form) for the tank record. |
|
gaugedvol |
double |
Gauged tank volume. |
|
gcf |
double |
The gravity correction factor that was used when the strapping table was calculated with the roof weight. |
|
GOflow_rate |
double |
The average GO flow rate. |
|
govFlowRate |
double |
The instantaneous GOV flow rate. |
|
group |
groupslot |
This field shows the group that this point is associated with for alarming. |
|
GSflow_rate |
double |
The average Gross Standard (GS) flow rate. |
|
gsvFlowRate |
double |
The instantaneous GSV flow rate. |
|
gtimeout |
int |
Gauge time out in seconds. |
|
gtimeslot |
slot |
Slot of gauge timer. |
|
hilow |
tankhilow |
A structure of information about alarm checking, and deadband. Some of the fields in the structure are described below. |
|
hilow.creep.doit |
oas_boolean_t |
Enable creep detection alarming? |
|
hilow.dev_alarm |
oas_boolean_t |
Currently in creep alarm. |
|
hilow.dev_life |
long |
Number of seconds that a creep alarm lasts before timing out. |
|
hilow.dev_time |
long |
The Unix timestamp that the creep alarm started. |
|
hilow.DeviationType |
CreepAlarmDeviationType |
The selected creep alarm deviation type. |
|
hilow.dev_txtlife |
txtlevel |
The text version of hilow.dev_life. |
|
hilow.doitnel |
oas_boolean_t |
Enable normal empty alarming? |
|
hilow.doitnfl |
oas_boolean_t |
Enable normal fill alarming? |
|
hilow.hilow.doithi |
oas_boolean_t |
Does high alarming occur for the device? |
|
hilow.hilow.doithihi |
oas_boolean_t |
Does high-high alarming occur for the device? |
|
hilow.hilow.doitlo |
oas_boolean_t |
Does low alarming occur for the device? |
|
hilow.hilow.doitlolo |
oas_boolean_t |
Does low-low alarming occur for the device? |
|
hilow.hilow.doitroc |
oas_boolean_t |
Does Rate-of-Change (ROC) alarming occur for the devices? |
|
hilow.hilow.roclim |
float |
This field shows the highest rate that the value for the device is allowed to change by before a ROC alarm occurs. |
|
hilow.hilow.doituhi |
oas_boolean_t |
Enable a user-defined high alarm limit. |
|
hilow.hilow.doitulo |
oas_boolean_t |
Enable a user-defined low alarm limit? |
|
hilow.lev_creep |
txtlevel |
Snapshot of level for level creep alarming. |
|
hilow.lev_dead |
txtlevel |
The volume deadband. |
|
hilow.lev_lo |
txtlevel |
The Tanking application generates a Low alarm if the level in the tank falls below this limit. |
|
hilow.lev_lolo |
txtlevel |
The Tanking application generates a LowLow alarm if the level in the tank falls below this limit. |
|
hilow.lev_nel |
txtlevel |
The Tanking application generates a normal empty alarm if the level in the tank falls below this limit. |
|
hilow.lev_nfl |
txtlevel |
The Tanking application generates a normal fill alarm if the level in the tank rises above this limit. |
|
hilow.lev_neg_dev |
float |
Negative level threshold for level creep alarming. |
|
hilow.lev_pos_dev |
txtlevel |
Positive level threshold for level creep alarming. |
|
hilow.lev_uhi |
txtlevel |
The user-defined high alarm limit. |
|
hilow.lev_ulo |
txtlevel |
The user-defined low alarm limit. |
|
hilow.negdevlim |
float |
Increments for hilow.lev_neg_dev. |
|
hilow.posdevlim |
float |
Increments for hilow.lev_pos_dev. |
|
hilow.VolumeCreep |
double |
Snapshot of observed volume for volume creep alarming. |
|
hilow.vol_neg_dev |
double |
Observed volume at hilow.lev_neg_dev. |
|
hilow.vol_pos_dev |
double |
Observed volume at hilow.lev_pos_dev. |
|
hilow.VolumeNegativeDeviation |
double |
Negative volume threshold for volume creep alarming. |
|
hilow.VolumePositiveDeviation |
double |
Positive volume threshold for volume creep alarming. |
|
hydrometer_corr |
oas_boolean_t |
Perform hydrometer correction on density correction factor. |
|
idle |
oas_boolean_t |
Is Tank idle? Set manually or automatically. |
|
inc_method |
enum_incmethod |
The type of strapping table. |
|
inputLevelFraction |
strapfraction |
The fraction used by the remote device to report information on the level of the tank. |
|
inventory |
oas_boolean_t |
Should the Tanking application record the inventory of the tank? |
|
last |
tanklevel |
GO level and volume in tank at last poll. |
|
last_fr_GOV |
double |
GOV in tank at last flow rate calculation. |
|
last_fr_GSV |
double |
GSV in tank at last flow rate calculation. |
|
lastHrGOV |
double |
The last hour's GOV. |
|
lastHrGSV |
double |
The last hour's GSV. |
|
man_dens |
oas_boolean_t |
Is density manually overridden? |
|
man_temp |
oas_boolean_t |
Is temperature manually overriden? |
|
mappingFlag |
unsigned int |
The 32-bit integer value used to map this point to a non-AVEVA Enterprise SCADA system. |
|
max_phys.txtlev |
txtlevel |
The maximum level possible in the tank. |
|
max_phys.volume |
double |
The maximum volume possible in the tank. |
|
max_safe.txtlev |
txtlevel |
The maximum level to which the tank can safely be filled. |
|
max_safe.volume |
double |
The minimum volume that can be safely held in the tank. |
|
min_safe.txtlev |
txtlevel |
The minimum level to which the tank can safely be filled. |
|
min_safe.volume |
double |
The maximum volume possible in the tank. |
|
mixer |
path |
The status or multistate points corresponding to the tank mixer unit. |
|
mixer[2-5] |
path |
The status or multistate points corresponding to the tank mixer unit. |
|
moveable |
tanklevel |
Amount that can be pumped out of tank. |
|
offset_vol |
double |
The volume below zero tank level. |
|
oper_idle |
oas_boolean_t |
Indicate whether tank is in operator idle override. |
|
packedTankRt |
longstring |
Packaged tank data. |
|
pctfull |
float |
Percentage of tank filled. |
|
pipeline |
pntname |
The name of the pipeline with which the tank is associated. |
|
pointClass |
configenumslot |
The point class category contains multiple configuration enumerations used for categorical configuration of points. |
|
pointSubClass |
configenumslot |
The point subclass category is a configurable enumeration category used for categorical configurations. It cannot be used for configurable alarms and events. |
|
pointtype |
pointtype_enum |
The input value type. |
|
prdgrp |
prodgroupslot |
The Tanking application automatically fills in this field based on the product_type field. |
|
prevlast_frGOV |
double |
GOV in tank at the previous to the last flow rate calculation. |
|
prevlast_frGSV |
double |
GSV in tank at the previous to the last flow rate calculation. |
|
prev_tstamp |
internaltime |
Previous time of last data krunch. |
|
product_type |
prodtypeslot |
The product type of the current contents of the tank. |
|
ptnum |
slot |
The slot number in the database. |
|
rollover |
double |
The value at which the resettable counter rolls over. |
|
roof_corr |
oas_boolean_t |
Indicate whether to compensate for the weight of the tank roof? |
|
rooffp_incs |
int |
The roof low float point (increments). |
|
rooffp2_incs |
int |
The roof high float point (increments). |
|
rooffptxt |
txtlevel |
The level at which the roof starts to float. |
|
rooffp2txt |
txtlevel |
The alternate level at which the roof starts to float. |
|
roof_leg |
enum_roof_leg |
This field indicates whether the Tanking application should use the Low Float Point value (Low) or the High Float Point value (High). |
|
roof_type |
oas_boolean_t |
Have the Tanking application assume that the strapping tables do not have the roof weight already taken into account? |
|
roof_weight |
double |
The weight of the roof if not built into the strapping table. |
|
room |
tanklevel |
Remaining tank level and volume below maximum volume. |
|
rt_path |
path |
The path to the RealTime row that contains the tank level or volume. |
|
rtu |
remoteslot |
The name of the remote record corresponding to the Remote Terminal Unit (RTU) associated with the tank. |
|
rtu_type |
enum_rtutype |
The type of RTU. |
|
settling_time |
long |
Number of seconds to wait until it goes idle. |
|
shell_fact |
double |
Tank shell temperature correction factor. |
|
shortDesc |
stn_str32 |
A brief description of the record. |
|
smoothedGovFlowRate |
double |
The smoothed GOV flow rate. |
|
smoothedGsvFlowRate |
double |
The smoothed GSV flow rate. |
|
smoothingFactor |
double |
Smoothing factor to produce smoothed GSV tank flow rate. |
|
snow_corr |
oas_boolean_t |
Compensate for snow on the tank? |
|
snow_corr_level |
tanklevel |
Tank level or volume corrected the snow level. |
|
snow_corr_mth |
enum_snowcorr |
The method of compensation for the weight of snow on the tank roof. |
|
snow_level |
txtlevel |
Gauge offset due to snow on the tank roof. |
|
snow_txtlev |
txtlevel |
Level of snow on the roof. |
|
snow_weight |
double |
The estimated weight of snow on the tank roof. |
|
source_type |
enum_tanksource |
The type of source input for the tank. |
|
safetyPtState |
safetyPtConfig |
Safety Point state configuration. |
|
stateInhCfg |
stateInhibitsConfig |
A structure of information about the State alarm timed inhibit. |
|
stateInhibit |
stateInhibits |
A structure of information about the states on which to inhibit alarms. |
|
station |
stationslot |
The name of the associated station record. |
|
strap_gravity |
double |
The API density at which the strapping table was measured. |
|
strap_max_inc |
int |
Maximum total increments in the strapping table. |
|
strap_max_vol |
double |
Maximum volume in the strapping table. |
|
strap_table.strap[0-60].num_inc |
int |
The Incremental tank level. This is the relative height above the previous level. |
|
strap_table.strap[0-60].strap_vol |
double |
The tank level’s corresponding volume. |
|
strap_table.strap[0-60].txtlev |
txtlevel |
The tank level. The level is the height above the base, in units specified by the straptype field. |
|
strap_table.strap[0-60].volume |
double |
The total volume. |
|
strap_used |
strap_enum |
The strap used (legacy or extended). |
|
strappingid |
int |
The strapping table ID identifies the strapping table in the Historical database (HDB), corresponding to the ID column in the TankStrappingTables table in the AVEVA Pipeline Operations for Liquids Tank database. |
|
strappingname |
pntname |
The name of the strapping table in use. |
|
strappingtype |
straptabletype |
Type for strap table (upright cylindrical or vessel) |
|
straptype |
strapfraction |
The units used for the strapping table. |
|
tank_id |
pntname |
An alphanumeric string that identifies the tank. |
|
tank_idle_config.tankIdleConfig[0-11].path |
path |
The path to the record where tank idling or external flow information is stored. |
|
tank_idle_config.tankIdleConfig[0-11].state |
msgstring |
The state of the status or multistate point used to evaluate if the tank is idle or flowing. |
|
tank_idle_config.tankIdleConfig[0-11].type |
enum_tankIdleFlowUse |
This field indicates how the information supplied from the field should be interpreted. |
|
tank_idle_config.tankIdleConfig[0-11].value |
double |
The value that would act as a trigger point to indicate that the point is in an Idle (non-flowing) state. |
|
tank_idle_config.tankIdleConfig[0-11].valueComparison |
enum_comparison_operator |
How the device value should be compared against the value in the table. |
|
tankAlarmState |
unsigned int |
Bitmask for tracking current alarm state. |
|
tankin.excdeadband |
unsigned int |
Modifications of this field will trigger a virtual function named DOWNLOAD. Individual protocols may implement protocol-specific functionality for this download command, while the default behavior is for no action to be taken. |
|
tankDirection |
type_tankDirection |
Structure used to determine whether the tank is filling, emptying, stationary or floating. |
|
tankin.iospec.external |
IOspecString |
Indicates where the data is mapped within the remote. |
|
tankin.type |
analogtype |
The data type of the point. |
|
tanktype |
pntname |
The tank type. |
|
temp |
analogslot |
The analog point used to obtain the tank temperature. |
|
temp_corr |
oas_boolean_t |
Calculate the Temperature Correction Factor (TCF). Otherwise, the Tanking application sets the TCF to 1, and the GSV and IV will be equal. |
|
temp_unitDisp |
string10 |
Temperature units to be displayed. |
|
temp_type |
enum_tempunit_short |
Temperature units to be used in calculation. |
|
tfact |
double |
Temperature correction factor for API Volume correction. |
|
timestamp |
internaltime |
Time of last data krunch. |
|
tnkcontents |
string10 |
The tank contents. |
|
tnknum |
unsigned int |
The ID number of the tank. |
|
tsettling_time |
timestring |
The time that must elapse after the valves are closed before the tank is considered idle. |
|
unitprofile |
unitprofileslot |
The profile that the tank record is using to display units |
|
useAlmLimitSet |
oas_boolean_t |
Use alarm limit set or baseline alarming fields. |
|
useCreepAlarmSuppression |
oas_boolean_t |
Enable the Creep Alarm Suppression feature? |
|
valve_time |
internaltime |
The time at which the valves were closed, stopping flow into tank. |
|
volconfig |
enum_tnkvoltype |
How the Tanking application presents the tank information and how the percent full calculations are performed. |
|
watchdog |
watchdogSlot |
Point staled by flatline watchdog. |
|
weight_units |
enum_weight_units |
The units that will be used to measure the weight of the roof. |