The field...
|
Displays...
|
Valid Entry
|
A_ADI
|
The block's alarm areas.
|
N/A. This field is provided for backward compatibility.
|
A_ALMEXT1 A_ALMEXT2
|
The text entered in the block's alarm extension fields.
|
Up to 79 characters.
|
A_ALMINTIME
|
The time and date at which the block generated the
alarm.
|
N/A. This is a display only field.
|
A_ALMLASTTIME
|
The time and date at which the block last generated
an alarm.
|
N/A. This is a display only field.
|
A_ALMOCCUR F_ALMOCCUR
|
The number of times a block goes in and out of alarm
before it is acknowledged.
|
N/A. This is a display only field.
|
A_ALMSHELFREMTIME
F_ALMSHELFREMTIME
|
The remaining time left for a shelved alarm. |
N/A. This is a display only field. |
A_ALMSHELVED
F_ALMSHELVED
|
Indicates whether a specified alarm is shelved (YES/NO). |
N/A. This is a display only field. |
A_ALMSHELVEPOLICY
|
The name of alarm shelving policy. |
N/A. This is a display only field. |
A_ALMSHLVENAB
F_ALMSHLVENAB
|
Defines whether alarm shelving is enabled (YES/NO) for a block. |
N/A. This is a display only field. |
A_IALMSHLVENAB
F_IALMSHLVENAB
|
The initial alarm shelving status (ENABLE/DISABLE) for a block. |
N/A. This is a display only field. |
A_ALMSN
|
The serial number of the alarm area database.
|
N/A. This is a display only field.
|
A_AREA1 through A_AREA15
|
The alarm areas assigned to the block.
|
ALL or an alarm area name.
|
A_AUTO F_AUTO
|
The current automatic/manual status of the block.
|
Automatic (1) or Manual (0).
|
A_BACK
|
Whether the block backs up process data if it detects
a problem with the relational database.
|
Enable or Disable.
|
A_CHALM
|
The chain's most severe alarm.
|
N/A. This is a display only field.
|
A_CMDTP
|
Whether the block executes SQL commands or stored
procedures.
|
SQL or PROC.
|
A_COLS
|
The number of columns to select when a SELECT command
executes.
|
A numeric value.
|
A_CONTG
|
The block and field used by your process hardware
to verify the SQL Trigger block ran.
|
block.F_field.
|
A_CUALM
|
The block's current alarm.
|
N/A. This is a display only field.
|
F_CUALM
|
Float value of A_CUALM.
|
0 indicates alarm is OK or OFF.
|
A_CV
|
The block's transaction sequence.
|
0 to 255.
|
F_CV
|
The state of an executed procedure or command. Also
specifies if the error is SQLST, DBERR, CUALM or a combination of these
three states. The value displayed in this field is derived from a combination
of these three states.
|
N/A. This is a display only field.
|
A_DBERR
|
A number to indicate if the last SQL command executed
successfully. Zero indicates no error. A non-zero number indicates the
specific command that failed.
|
N/A. This is a display only field.
|
F_DBERR
|
Float value of A_DBERR
|
0 indicates no error.
|
A_DBID
|
The name of the relational database accessed by the
block.
|
Text.
|
A_DESC
|
The text in the block's Description field.
|
Up to 256 characters.
|
A_ENAB F_ENAB
|
The block's alarm status.
|
Enable: Yes (1), or Disable: No (0).
|
A_ESIGACK F_ESIGACK
|
Whether operators are allowed to acknowledge alarms
for this tag without entering a signature, even if this tag requires electronic
signatures for data entry.
|
Yes or No.
|
A_ESIGCONT F_ESIGCONT
|
If allow continuous use is enabled for this tag.
|
Yes or No.
|
A_ESIGREQ_COMMENT
F_ESIGREQ_COMMENT
|
A comment is required when using an electronic signature. |
Enable: Yes (1), or Disable: No (0).
|
A_ESIGTRAP F_ESIGTRAP
|
Whether unsigned writes are accepted or rejected by
this tag or accepted and logged.
|
ACCEPT, LOG, REJECT.
|
A_ESIGTYPE F_ESIGTYPE
|
The signing requirements for this tag.
|
None, PERFONLY, or PERFVERI.
|
A_EVDT1
|
The block's event start date.
|
1-31, ALL, NONE, or SUN-SAT.
|
A_EVDT2
|
The block's event end date.
|
1-31, ALL, NONE, or SUN-SAT.
|
A_EVENT
|
The initial event messaging status.
|
N/A. This is a display only field.
|
A_EVPD
|
The trigger time. When this time elapses, the block
triggers.
|
00:00:00-23:59:59 or a blank entry.
|
A_EVTAG
|
The block and field that triggers the SQL Trigger
block.
|
block.F_field.
|
A_EVTM1
|
The block's event start time.
|
00:00:00-23:59:59 or a blank entry.
|
A_EVTM2
|
The block's event end time.
|
00:00:00-23:59:59 or a blank entry.
|
A_EVTYP
|
The event that triggers the block.
|
COV (change of value), HTL (High to Low), or LTH (Low to High)
|
A_HIST_COLLECT F_HIST_COLLECT
|
Sets whether or not this block is under collection.
|
Yes (1) or No (0).
|
A_HIST_COMPRESS F_HIST_COMPRESS
|
Sets whether or not compression is used by the Collector.
|
Enable (1) or Disable (0).
|
A_HIST_COMPTIME F_HIST_COMPTIME
|
The Collector compression time out.
|
A positive numeric value (0 or greater), in milliseconds.
|
A_HIST_COMPTYPE F_HIST_COMPTYPE
|
The type of Collector deadband setting.
|
Absolute (0) or Percentage (1).
|
A_HIST_DEADBAND F_HIST_DEADBAND
|
The Collector deadband setting.
|
A positive numeric value (0 or greater).
|
A_HIST_DESC
|
The GE Historian description.
|
String; maximum of 128 characters.
|
A_HIST_INTERVAL F_HIST_INTERVAL
|
The collection interval for this block. The value
of this field must be greater than the value of the A_HIST_OFFSET and
F_HIST_OFFSET fields.
Use the following formula to determine if the entered
value is acceptable for this field.
A_/F_HIST_INTERVAL > A_/F_HIST_OFFSET * 1000
NOTE: The values for the A_HIST_OFFSET and F_HIST_OFFSET
fields are in seconds.
|
A float value, in milliseconds. Values must be entered
in increments of 100. Minimum value: 100 ms.
|
A_HIST_OFFSET F_HIST_OFFSET
|
The collection offset time. The value of this field
must be less than or equal to the value of the A_HIST_INTERVAL and F_HIST_INTERVAL
fields.
Use the following formula to determine if the entered
value is acceptable for this field.
A_/F_HIST_OFFSET ≤ A_/F_HIST_INTERVAL / 1000
NOTE: The values for the A_HIST_INTERVAL and F_HIST_INTERVAL
fields are in milliseconds.
|
A numeric value, in seconds. Must use whole numbers.
|
A_HIST_TIMERES F_HIST_TIMERES
|
The collection time resolution.
|
Milliseconds (0) or Seconds (1).
|
A_IAM
|
The initial Automatic/Manual status of the block.
|
Automatic or Manual.
|
A_IENAB
|
The initial alarm status.
|
N/A. This is a display only field.
|
A_ISCAN
|
The initial scan status (on or off) of the block.
|
On or Off.
|
A_LAALM
|
The block's most severe unacknowledged alarm. If no
unacknowledged alarm exists, the current alarm is displayed.
|
N/A. This is a display only field.
|
A_NALM F_NALM
|
Yes or 1, if the block has unacknowledged alarms or
No or 0, if the block has no unacknowledged alarms.
|
N/A. This is a display only field.
|
A_NAME
|
The block's type, for example AI for an Analog Input
block.
|
N/A. This is a display only field.
|
A_NEXT
|
The name of the next block in the chain.
|
N/A. This is a display only field.
|
A_OPCLIMIT
|
The hardware options of the OPC server.
|
N/A. This is a display only field.
|
A_OPCQLTY
|
The quality status of the OPC server.
|
N/A. This is a display only field.
|
A_OPCSUBSTAT
|
The quality substatus of the OPC server.
|
N/A. This is a display only field.
|
A_OPCTIME
|
The time and date from the OPC server.
|
N/A. This is a display only field.
|
A_PDR_ACCESSTIME F_PDR_ACCESSTIME
|
Reserved for future use.
|
A_PDR_ARRAYLENGTH F_PDR_ARRAYLENGTH
|
Reserved for future use.
|
A_PDR_DEADBAND F_PDR_DEADBAND
|
Reserved for future use.
|
A_PDR_DISABLEOUT F_PDR_DISABLEOUT
|
Reserved for future use.
|
A_PDR_LATCHDATA F_PDR_LATCHDATA
|
Reserved for future use.
|
A_PDR_UPDATERATE F_PDR_UPDATERATE
|
Reserved for future use.
|
A_PDTMR
|
The length of time remaining before the block triggers.
|
N/A. This is a display only field.
|
A_PREV
|
The name of the previous block in the chain.
|
N/A. This is a display only field.
|
A_PRI
|
The block's alarm priority.
|
Low, Medium, or High.
|
A_PRIM
|
The block's name.
|
N/A. This is a display only field.
|
A_ROWS
|
The number of rows to retrieve when a SELECT command
executes.
|
A numeric value.
|
A_SA1 through A_SA3
|
The security areas assigned to the block.
|
Up to three security area names.
|
A_SCAN
|
The on/off scan status of the block.
|
On or Off.
|
A_SCANT
|
The block's scan time and phase.
|
E for exception-based processing, 0 for one shot processing,
or time:phase for time-based processing.
|
A_SEQ
|
The block's transaction sequence. iFIX uses the number
to identify each block.
|
N/A. This is a display only field.
|
A_SQL
|
The SQL command to execute.
|
Text.
|
A_SQLST
|
A five-character value that indicates an error returned
by the database engine due to the SQL statement failure at the database
engine level. The field is blanked out when the block triggers.
|
N/A. This is a display only field. 00000 = no error. 07001 = wrong number parameter. IM001 = memory error. S1001 = driver does not support this function.
|
F_SQLST
|
Float value of A_SQLST.
|
0 if A_SQLST is 00000 1 if A_SQLST is "" (indicates executing) 2 if A_SQLST is any alphanumeric string.
|
A_STATE
|
The block's state.
|
N/A. This is a display only field.
|
A_TAG
|
The block's name.
|
N/A. This is a display only field.
|
A_TMODE
|
The block's selection mode.
|
SINGLE, MULTIPLE, or ARRAY.
|
A_TRIP
|
Whether the block is running.
|
0 (not running) or 1 (running).
|
A_WARM
|
Yes or No.
|
N/A. This is a display only field.
|
A_XTIME
|
The time of the last transaction.
|
N/A. This is a display only field.
|
A_XDATE
|
The date of the last transaction.
|
N/A. This is a display only field.
|
A_ALMACK F_ALMACK
|
Reserved for future use.
|
A_ALMCHANGE F_ALMCHANGE
|
Reserved for future use.
|
A_ALMDELETE F_ALMDELETE
|
Reserved for future use.
|
A_ALMGEN F_ALMGEN
|
Reserved for future use.
|
A_ALMRESET F_ALMRESET
|
Reserved for future use.
|
A_ALMUPDATE F_ALMUPDATE
|
Reserved for future use.
|
A_PUBLISH F_PUBLISH
|
Reserved for future use.
|
A_WRITABLE F_WRITABLE
|
Reserved for future use.
|