complexType "mevent_num_alarmTYPE"
Namespace:
Content:
complex, 20 attributes, 1 element
Defined:
globally in CRIS_Complete_V3-2-1_[31-Dec-2008].xsd, see XML source
Includes:
definitions of 20 attributes and 1 element
Used:
XML Representation Summary
<...
    meas_loc_site
 = 
xsd:hexBinary
    meas_loc_id
 = 
xsd:unsignedInt
    gmt_event
 = 
xsd:dateTime
    eu_db_site
 = 
xsd:hexBinary
    eu_db_id
 = 
xsd:unsignedInt
    eu_type_code
 = 
xsd:unsignedInt
    al_db_site
 = 
xsd:hexBinary
    al_db_id
 = 
xsd:unsignedInt
    al_type_code
 = 
xsd:unsignedInt
    gmt_acknowledged
 = 
xsd:dateTime
    ack_loc_hr_delta
 = 
xsd:short
    ack_loc_min_delta
 = 
xsd:unsignedShort
    org_agent_site
 = 
xsd:hexBinary
    agent_id
 = 
xsd:unsignedInt
    user_tag_ident
 = 
xsd:string
    name
 = 
xsd:string
    gmt_last_updated
 = 
xsd:dateTime
    last_upd_db_site
 = 
xsd:hexBinary
    last_upd_db_id
 = 
xsd:unsignedInt
    rstat_type_code
 = 
xsd:unsignedShort
    >
   
Content: 
lcinfo?
</...>
Content Elements (1):
lcinfo (type lcinfo)
Known Usage Locations
Annotation
Measurement Event Numeric Data Alarm Entity. This entity stores all the alarms triggered by the numeric value stored in the Measurement Event Numeric Data Entity (mevent_num_data.)
If data is available in the Measurement Location Numeric Data Alarm Region Entity (num_alarm_reg), then the alarm data in this table can be derived and does not need to be stored here.
However, some systems do not send all the alarm region data, and we need to store the fact that an alarm was triggered.
Note: MIMOSA maintains the enterprise zero, site zero (meas_loc_site = “0000000000000000”) entries in this table
XML Source (w/o annotations (21))
<xsd:complexType name="mevent_num_alarmTYPE">
<xsd:sequence>
<xsd:element minOccurs="0" name="lcinfo" type="lcinfo"/>
</xsd:sequence>
<xsd:attribute name="meas_loc_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="meas_loc_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="gmt_event" type="dateTimeWithoutTimezone" use="required"/>
<xsd:attribute name="eu_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="eu_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="eu_type_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="al_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="al_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="al_type_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="gmt_acknowledged" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="ack_loc_hr_delta" type="xsd:short" use="optional"/>
<xsd:attribute name="ack_loc_min_delta" type="xsd:unsignedShort" use="optional"/>
<xsd:attribute name="org_agent_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="agent_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="user_tag_ident" type="varchar254" use="optional"/>
<xsd:attribute name="name" type="varchar254" use="optional"/>
<xsd:attribute name="gmt_last_updated" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="last_upd_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="last_upd_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="rstat_type_code" type="xsd:unsignedShort" use="optional"/>
</xsd:complexType>
Attribute Detail (defined in this component only; 20/20)
meas_loc_site
Type:
Use:
required
Foreign key reference to Mevent_Num_Data.meas_loc_site, Included in composite primary key
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="meas_loc_site" type="site_codeSimpleType" use="required"/>

meas_loc_id
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Mevent_Num_Data.meas_loc_id, Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="meas_loc_id" type="xsd:unsignedInt" use="required"/>

gmt_event
Type:
Use:
required
Foreign key reference to Mevent_Num_Data.gmt_event, Included in composite primary key
Attribute Value
xsd:dateTime
Pattern:
[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.?[0-9]{0,9}
XML Source (w/o annotations (1))
<xsd:attribute name="gmt_event" type="dateTimeWithoutTimezone" use="required"/>

eu_db_site
Type:
Use:
required
Foreign key reference to Mevent_Num_Data.eu_db_site, Included in composite primary key
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="eu_db_site" type="site_codeSimpleType" use="required"/>

eu_db_id
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Mevent_Num_Data.eu_db_id, Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="eu_db_id" type="xsd:unsignedInt" use="required"/>

eu_type_code
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Mevent_Num_Data.eu_type_code, Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="eu_type_code" type="xsd:unsignedInt" use="required"/>

al_db_site
Type:
Use:
required
Foreign key reference to Alarm_Type.al_db_site, Included in composite primary key
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="al_db_site" type="site_codeSimpleType" use="required"/>

al_db_id
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Alarm_Type.al_db_id, Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="al_db_id" type="xsd:unsignedInt" use="required"/>

al_type_code
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Alarm_Type.al_type_code, Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="al_type_code" type="xsd:unsignedInt" use="required"/>

gmt_acknowledged
Type:
Use:
optional
Attribute Value
xsd:dateTime
Pattern:
[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.?[0-9]{0,9}
XML Source (w/o annotations (1))
<xsd:attribute name="gmt_acknowledged" type="dateTimeWithoutTimezone" use="optional"/>

ack_loc_hr_delta
Type:
xsd:short, predefined
Use:
optional
XML Source (w/o annotations (1))
<xsd:attribute name="ack_loc_hr_delta" type="xsd:short" use="optional"/>

ack_loc_min_delta
Type:
xsd:unsignedShort, predefined
Use:
optional
XML Source (w/o annotations (1))
<xsd:attribute name="ack_loc_min_delta" type="xsd:unsignedShort" use="optional"/>

org_agent_site
Type:
Use:
optional
Foreign key reference to Agent.org_agent_site (Agent which acknowledged the alarm)
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="org_agent_site" type="site_codeSimpleType" use="optional"/>

agent_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Agent.agent_id (Agent which acknowledged the alarm)
XML Source (w/o annotations (1))
<xsd:attribute name="agent_id" type="xsd:unsignedInt" use="optional"/>

user_tag_ident
Type:
Use:
optional
Short user-defined tag/identifier
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="user_tag_ident" type="varchar254" use="optional"/>

name
Type:
Use:
optional
Full user-defined name/description
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="name" type="varchar254" use="optional"/>

gmt_last_updated
Type:
Use:
optional
UTC/GMT timestamp for the last change to this record
Attribute Value
xsd:dateTime
Pattern:
[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.?[0-9]{0,9}
XML Source (w/o annotations (1))
<xsd:attribute name="gmt_last_updated" type="dateTimeWithoutTimezone" use="optional"/>

last_upd_db_site
Type:
Use:
optional
Foreign key reference to Site_Database.db_site which identifies the database creating/updating/soft deleting this entry
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="last_upd_db_site" type="site_codeSimpleType" use="optional"/>

last_upd_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Site_Database.db_id which identifies the database creating/updating/soft deleting this entry
XML Source (w/o annotations (1))
<xsd:attribute name="last_upd_db_id" type="xsd:unsignedInt" use="optional"/>

rstat_type_code
Type:
xsd:unsignedShort, predefined
Use:
optional
Foreign key reference to Row_Status_Type.rstat_type_cod which determines the status of this entry
XML Source (w/o annotations (1))
<xsd:attribute name="rstat_type_code" type="xsd:unsignedShort" use="optional"/>
Content Element Detail (defined in this component only; 1/1)
lcinfo
Type:
lcinfo, complex content
XML Source
<xsd:element minOccurs="0" name="lcinfo" type="lcinfo"/>

XML schema documentation generated with DocFlex/XML 1.7.2b using DocFlex/XML | XSDDoc 2.1.0b template set