The following table lists the fields available for this block, what each field displays, as well as the valid entries for each field in the list.
|
The field... |
Displays... |
Valid Entry |
|
A_ADI |
The block's alarm areas. |
N/A. This field is provided for backward compatibility. |
|
A_ALMEXT1 |
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 |
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 |
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 |
The block's alarm status. |
Enable: Yes (1), or Disable: No (0). |
|
A_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 |
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 |
Whether unsigned writes are accepted or rejected by this tag or accepted and logged. |
ACCEPT, LOG, REJECT. |
|
A_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), |
|
A_HIST_COLLECT |
Sets whether or not this block is under collection. |
Yes (1) or No (0). |
|
A_HIST_COMPRESS |
Sets whether or not compression is used by the Collector. |
Enable (1) or Disable (0). |
|
A_HIST_COMPTIME |
The Collector compression time out. |
A positive numeric value (0 or greater), in milliseconds. |
|
A_HIST_COMPTYPE |
The type of Collector deadband setting. |
Absolute (0) or Percentage (1). |
|
A_HIST_DEADBAND |
The Collector deadband setting. |
A positive numeric value (0 or greater). |
|
A_HIST_DESC |
The Proficy Historian description. |
String; maximum of 128 characters. |
|
A_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 |
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 |
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 |
Yes or 1, if the block has unacknowledged alarms or
|
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 |
Reserved for future use. |
|
|
A_PDR_ARRAYLENGTH |
Reserved for future use. |
|
|
A_PDR_DEADBAND |
Reserved for future use. |
|
|
A_PDR_DISABLEOUT |
Reserved for future use. |
|
|
A_PDR_LATCHDATA |
Reserved for future use. |
|
|
A_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 |
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. |
|
F_SQLST |
Float value of A_SQLST. |
0 if A_SQLST is 00000 |
|
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 |
|
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 |
Reserved for future use. |
|
|
A_ALMCHANGE |
Reserved for future use. |
|
|
A_ALMDELETE |
Reserved for future use. |
|
|
A_ALMGEN |
Reserved for future use. |
|
|
A_ALMRESET |
Reserved for future use. |
|
|
A_ALMUPDATE |
Reserved for future use. |
|
|
A_PUBLISH |
Reserved for future use. |
|
|
A_WRITABLE |
Reserved for future use. |
|
