ihHabAlarms Table

The ihHabAlarms table contains alarm data collected from Habitat by the HAB collector. This data is stored in the Historian archive files.


Column Name	Data Type	Description
`tagname`	`VT_BSTR`	The tagname property of the tag.
`timestamp`	`VT_DBTimeStamp`	The date and time for the data sample (based on the timestamp of collector)
`timestampseconds`	`VT_I4`	The date and time for the data sample.
`microseconds`	`VT_I4`	The microsecond interval for the data sample.
`samplingmode`	`VT_BSTR`	The mode used to retrieve data from the archive. Only the RawByTime sampling mode is used for alarms. It retrieves raw archive values for a time period.
`quality`	`VT_BSTR`	The quality of the tag data. For raw sampled data, the valid data values is Good.
`text`	`VT_BSTR`	The alarms message
`location`	`VT_BSTR`	The substation or location as defined in the Habitat database
`priority`	`VT_BSTR`	The alarm priority as defined in the Habitat database
`category`	`VT_BSTR`	The alarm category as defined in the Habitat database
`exception`	`VT_BSTR`	The alarm exception as defined in the Habitat database
`area`	`VT_BSTR`	The alarm area as defined in the Habitat database
`fieldtime`	`VT_DBTimeStamp`	The field time of the alarm message (if available)
`fmillisec`	`VT_I4`	The milliseconds part of the field time
`fnanosec`	`VT_I4`	The nanoseconds part of the field time
`time`	`VT_DBTimeStamp`	The time of the alarm generated in Habitat (mapped to TIME_CIRCLG)
`timefmt`	`VT_I4`
`tnanosec`	`VT_I4`	The nanoseconds part of the alarms time
`rowcount`	`VT_I4`	The maximum number of rows that can be returned. A value of 0 indicates that there is no limit to the number of rows returned.