Plm table details

adjustmentApplication

adjustmentApplicationType

The type of adjustments that should be applied (SUM, MAX).

almSup

oas_boolean_t

Is alarming suppressed for the plm record?

autoinh

oas_boolean_t

Indicate whether the record is inhibited due to an auto-inhibit operation.

autoInhPath

path

The path to the status or multistate record that identifies whether the plm record is inhibited or enabled.

bal_fact

double

Adjustment to the flow differential (Total Metered Input – Total Metered Output).

bdthreshold

unsigned int

This is the percentage of data used for any balance period that must be flagged as bad data before the period quality is flagged as bad data.

cur_day

plmDVolSumType

The delta volume (difference between the volume counter value and the previous volume counter) for the current day.

cur_month

plmDVolSumType

The delta volume (difference between the volume counter value and the previous volume counter) for the current month.

cur_pass

plmDVolSumType

The delta volume (difference between the volume counter value and the previous volume counter) for the current pass.

cur_week

plmDVolSumType

The delta volume (difference between the volume counter value and the previous volume counter) for the current week.

daily_balances

weekarray

An array containing the daily line balances for the last seven days.

daily_dflows

weekarray

An array containing the daily delta flows for the last seven days.

daily_dlinefils

weekarray

An array containing the daily delta line fills for the last seven days.

daily_dtanks

weekarray

An array containing the daily tank changes for the last seven days.

daily_mtrins

weekarray

An array containing the daily meter ins for the last seven days.

daily_mtrouts

weekarray

An array containing the daily meter outs for the last seven days.

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.

DATrigger

triggerTypeArray

An array containing the dynamic alarm limit triggers for this record.

debugEna

oas_boolean_t

Enable debugging messages that appear in the AVEVA Enterprise SCADA error log to show the extrapolation applied?

decaystimer

long

This field is currently not used in the baseline product.

description

description

A description of this PLM point, up to 47 characters in length.

diag_db

double

Pipeline Monitoring (PLM) calculates an average change across all components within the PLM system (meters, tanks, and linepacks). If the change across a component is greater than the diag_db value, AVEVA Enterprise SCADA marks that component by placing a Y in the Leak Risk field of the appropriate summary (PLM Meter Summary, PLM Linefill Summary, or PLM Tank Summary).

displayenastates

string80

This field is used to enter one or more integers separated by commas. Each integer represents a status or multistate value that, if present, designates the plm record as enabled.

displayinhstates

string80

This field is used to enter one or more integers separated by commas. Each integer represents a status or multistate value that, if present, designates the plm record as inhibited.

doCollectS0

oas_boolean_t

Save instantaneous (one minute interval) balance values to Historical?

do_staleRem

oas_boolean_t

Generate a reminder alarm for the Controller when the plm record is in a stale state and enable_calcalm is not TRUE?

enable_calcalm

oas_boolean_t

Enable alarming when this PLM system stops calculating or re-starts calculating?

enastates

string80

This field is used to enter one or more integers, each of which represents a status or multistate value which, if present, designates the plm record as enabled.

flag.alminh

oas_boolean_t

Inhibit alarming when this PLM system enters an alarm state?

flag.bmsg

messageslot

The message associated with the record.

flag.cevinh

oas_boolean_t

Inhibit logging an event when this PLM system returns to a normal state?

flag.clrinh

oas_boolean_t

Inhibit alarming when this PLM system returns to a normal state?

flag.evtinh

oas_boolean_t

Inhibit logging an event when this PLM system enters an alarm state?

flag.safety

oas_boolean_t

Is the point safety-related?

flg_stnbal

oas_boolean_t

Reissue the deviation alarm every minute while the limit violation persists?

flow_path

path

The path leading to the status or multistate point associated with the flow rate used to determine whether the plm record is in a suspended state.

fmin

double

The minimum flow rate required for the PLM system to enter a suspended state.

group

groupslot

This field shows the group that this point is associated with for alarming.

inh

oas_boolean_t

Inhibit the plm record?

inhstates

string80

This field is used to enter one or more integers separated by commas. Each integer represents a status or multistate value that, if present, designates the plm record as inhibited.

inst

plmDVolSumType

The instantaneous delta volume (difference between the current volume and the previous volume counter).

kl

double

Filter factor applied when calculating instantaneous (current) balance.

last_day_read

unsigned int

The last day value read on previous pass.

last_hour_read

unsigned int

The last hour value read on previous pass.

last_month_read

unsigned int

The last month value read on previous pass.

lock

lmslock

The record's lock state.

low_flow

oas_boolean_t

Is PLM system in a suspended state due to a low flow rate?

LT_1hrly_ena

oas_boolean_t

Process LT1 every hour (if not selected, LT1 is processed minutely)?

mtr_extrap

oas_boolean_t

Enable meter extrapolation?

name

pntname

The unique name of this plm record. The name can be up to 32 characters in length.

negative_tolerance

double

The acceptable tolerance level for a negative delta increment coming from meter volume devices.

pipelnnames

plmpipelnarray

An array of the pipelines this plm record is pointing to.

plmAlarmingMethod

plmAlarmingMethods

The method used for applying the balance limits.

plmlpckinh

oas_boolean_t

Disable deviation alarming if one or more of the linepack segments goes stale?

prev_day

plmDVolSumType

The delta volume (difference between the volume counter value and the previous volume counter) for the previous day.

prev_hr

plmDVolSumType

The delta volume (difference between the volume counter value and the previous volume counter) for the previous hour.

prev_month

plmDVolSumType

The delta volume (difference between the volume counter value and the previous volume counter) for the previous month.

prev_pass

plmDVolSumType

The delta volume (difference between the volume counter value and the previous volume counter value) for the previous pass.

ptnum

slot

This represents the slot number of the plm record in the database.

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.

restart_time

unsigned int

A configuration of the duration (in minutes) that should elapse before PLM calculations restart after the system goes into a suspended state.

rst_timer

unsigned int

A configuration of the duration (in minutes) that should elapse before PLM calculations restart after the system goes into a suspended state.

schedule

execution Schedule

PLM customized schedule configuration during the hour.

seconddev

oas_boolean_t

Is this the second or later deviation?

sevinh

oas_boolean_t

Inhibit logging an event when this PLM system enters a suspended state?

slack

oas_boolean_t

Is the PLM system suspended due to slack?

slminh

oas_boolean_t

Inhibit alarming when this PLM system enters a suspended state?

staleAlarmed

oas_boolean_t

Has a stale alarm been issued?

stale_remtm

unsigned int

The last time an alarm was issued to remind the controller that the PLM system is stale.

stale_time

unsigned int

If any of the PLM data is stale for longer than this timeout period, the plm record will be marked as stale.

state

leakalmstate

The alarm state of the PLM system.

str_todhour

string6

Time of day (in hour and minutes) at which the totals for the day are calculated.

sus_last

unsigned int

The last time the PLM system entered into a suspended state.

sus_time

unsigned int

The amount of time (in minutes) the system will wait before declaring a suspended state.

susdynalmlim

oas_boolean_t

Are suspend dynamic alarm limits applied?

termData

termDataTypeArray

This field contains an array of term entry data.

termInfo

termInfoTypeArray

This field contains an array of term period information.

termInfo[0-8]. alarmHoldOffPeriod

unsigned int

Alarm re-annunciation hold off period in minutes for each of the nine term alarms. A value of zero indicates no hold off period.

termInfo[0-8]. alarmHoldOffStartTime

internaltime

The time at which a hold off period started for a particular term; otherwise, zero.

termInfo[0-8]. alarmHoldOffRTN

oas_boolean_t

True if the particular term alarm has returned to normal during a hold off period; otherwise, false.

timestamp

internaltime

Time the record was last updated.

tod_hour

unsigned int

Time of day (in hour and minutes) at which the totals for the day are calculated

tot_linepack

double

Total linepack (linefill) for the PLM system.

transient

oas_boolean_t

Is the plm record in a transient state?

TVB

oas_boolean_t

Indicates whether this is a tank volume balance record.

unit

pntname

The unit of measure to be used with the plm record.

unitprofile

unitprofileslot

The unit profile to be used with the plm record.

useAutoInh

oas_boolean_t

Enable the use of the status or multistate record configured in autoInhPath?

useGroupTod

oas_boolean_t

Have this plm record use the top of day configured at the Group level using the Separate Top of Day (TOD) and Averages Rollup application, rather than str_todhour?

volumeAlarmInhibit

oas_boolean_t

Should the alarm be inhibited for an invalid meter reading?