complexType "meas_eventTYPE"
Namespace:
Content:
complex, 35 attributes, 1 element
Defined:
globally in CRIS_Complete_V3-2-1_[31-Dec-2008].xsd, see XML source
Includes:
definitions of 35 attributes and 1 element
Used:
XML Representation Summary
<...
    meas_loc_site
 = 
xsd:hexBinary
    meas_loc_id
 = 
xsd:unsignedInt
    gmt_event
 = 
xsd:dateTime
    ev_loc_hr_delta
 = 
xsd:short
    ev_loc_min_delta
 = 
xsd:unsignedShort
    gmt_stored
 = 
xsd:dateTime
    st_loc_hr_delta
 = 
xsd:short
    st_loc_min_delta
 = 
xsd:unsignedShort
    segment_site
 = 
xsd:hexBinary
    segment_id
 = 
xsd:unsignedInt
    asset_org_site
 = 
xsd:hexBinary
    asset_id
 = 
xsd:unsignedInt
    ds_asset_site
 = 
xsd:hexBinary
    ds_asset_id
 = 
xsd:unsignedInt
    tr_asset_site
 = 
xsd:hexBinary
    tr_asset_id
 = 
xsd:unsignedInt
    dqual_type_code
 = 
xsd:unsignedShort
    ml_db_site
 = 
xsd:hexBinary
    ml_db_id
 = 
xsd:unsignedInt
    ml_type_code
 = 
xsd:unsignedInt
    mc_db_site
 = 
xsd:hexBinary
    mc_db_id
 = 
xsd:unsignedInt
    mc_type_code
 = 
xsd:unsignedInt
    mc_calc_size
 = 
xsd:unsignedInt
    collect_duration
 = 
xsd:double
    dur_eu_db_site
 = 
xsd:hexBinary
    dur_eu_db_id
 = 
xsd:unsignedInt
    dur_eu_type_code
 = 
xsd:unsignedInt
    confid_percent
 = 
xsd:unsignedShort
    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 History Entity:
This entity is a history of data collection events occurring at measurement locations. This event could have recorded a single numeric value of a certain type, or a group of related signal processed measurements. Each measurement event relates back to one measurement location.
Foreign keys are defined to the segment, asset, data collection source, and transducer tables in order for a system to track which segment and/or which asset and which data collection source and transducer the measurement is tied to at this particular instance in time. This entity does not contain the actual data, but the fact that at a given time, at a measurement location which was then associated with a physical object and/or a functional object, a measurement of a certain location type was taken.
Note: The non-mandatory segment_site and segment_id columns are for measurement locations on assets where the actual segment where the asset is installed needs to be captured with the measurement event.
Note: The non-mandatory asset_org_site and asset_id columns are for measurement locations on segments where the actual asset installed on the segment needs to be captured with the measurement event.
Note: ev_loc_hr_delta is the number of hours +/- GMT to calculate the correct local time for the event.
Note: st_loc_hr_delta is the number of hours +/- GMT to calculate the correct local time that the event row was stored in the database.
Note: ev_loc_min_delta: If null, assume local minute offset from GMT=0
Note: st_loc_min_delta: If null, assume local minute offset from GMT=0
Note: confid_percent: Confidence in measurement accuracy (0=no confidence, 100=complete confidence)
XML Source (w/o annotations (36))
<xsd:complexType name="meas_eventTYPE">
<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="ev_loc_hr_delta" type="xsd:short" use="optional"/>
<xsd:attribute name="ev_loc_min_delta" type="xsd:unsignedShort" use="optional"/>
<xsd:attribute name="gmt_stored" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="st_loc_hr_delta" type="xsd:short" use="optional"/>
<xsd:attribute name="st_loc_min_delta" type="xsd:unsignedShort" use="optional"/>
<xsd:attribute name="segment_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="segment_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="asset_org_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="asset_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="ds_asset_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="ds_asset_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="tr_asset_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="tr_asset_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="dqual_type_code" type="xsd:unsignedShort" use="required"/>
<xsd:attribute name="ml_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="ml_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="ml_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="mc_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="mc_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="mc_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="mc_calc_size" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="collect_duration" type="xsd:double" use="optional"/>
<xsd:attribute name="dur_eu_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="dur_eu_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="dur_eu_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="confid_percent" type="xsd:unsignedShort" 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; 35/35)
meas_loc_site
Type:
Use:
required
Foreign key reference to Meas_Location.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 Meas_Location.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
Unique timestamp assigned to this measurement collection, as recorded by collection archive system (must be unique and is normally different than the source stored timestamp below), 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"/>

ev_loc_hr_delta
Type:
xsd:short, predefined
Use:
optional
Local event time hour offset from GMT
XML Source (w/o annotations (1))
<xsd:attribute name="ev_loc_hr_delta" type="xsd:short" use="optional"/>

ev_loc_min_delta
Type:
xsd:unsignedShort, predefined
Use:
optional
Local event time minute offset from GMT
XML Source (w/o annotations (1))
<xsd:attribute name="ev_loc_min_delta" type="xsd:unsignedShort" use="optional"/>

gmt_stored
Type:
Use:
optional
Timestamp in GMT/UTC when measurement was stored/captured on the original source system or platform (may not be unique)
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_stored" type="dateTimeWithoutTimezone" use="optional"/>

st_loc_hr_delta
Type:
xsd:short, predefined
Use:
optional
Local store time hour offset from GMT
XML Source (w/o annotations (1))
<xsd:attribute name="st_loc_hr_delta" type="xsd:short" use="optional"/>

st_loc_min_delta
Type:
xsd:unsignedShort, predefined
Use:
optional
Local store time minute offset from GMT
XML Source (w/o annotations (1))
<xsd:attribute name="st_loc_min_delta" type="xsd:unsignedShort" use="optional"/>

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

segment_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Segment.segment_id
XML Source (w/o annotations (1))
<xsd:attribute name="segment_id" type="xsd:unsignedInt" use="optional"/>

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

asset_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Asset.asset_id
XML Source (w/o annotations (1))
<xsd:attribute name="asset_id" type="xsd:unsignedInt" use="optional"/>

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

ds_asset_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Data_Source.ds_asset_id
XML Source (w/o annotations (1))
<xsd:attribute name="ds_asset_id" type="xsd:unsignedInt" use="optional"/>

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

tr_asset_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Transducer.tr_asset_id
XML Source (w/o annotations (1))
<xsd:attribute name="tr_asset_id" type="xsd:unsignedInt" use="optional"/>

dqual_type_code
Type:
xsd:unsignedShort, predefined
Use:
required
Foreign key reference to Data_Qual_Type.dqual_type_code
XML Source (w/o annotations (1))
<xsd:attribute name="dqual_type_code" type="xsd:unsignedShort" use="required"/>

ml_db_site
Type:
Use:
optional
Foreign key reference to Meas_Loc_Type.ml_db_site (Optional location type which specifically categorizes this measurement event)
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="ml_db_site" type="site_codeSimpleType" use="optional"/>

ml_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Meas_Loc_Type.ml_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="ml_db_id" type="xsd:unsignedInt" use="optional"/>

ml_type_code
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Meas_Loc_Type.ml_type_code
XML Source (w/o annotations (1))
<xsd:attribute name="ml_type_code" type="xsd:unsignedInt" use="optional"/>

mc_db_site
Type:
Use:
optional
Foreign key reference to Mloc_Calc_Type.mc_db_site (Actual method that measurement was calculated from raw data)
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="mc_db_site" type="site_codeSimpleType" use="optional"/>

mc_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Mloc_Calc_Type.mc_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="mc_db_id" type="xsd:unsignedInt" use="optional"/>

mc_type_code
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Mloc_Calc_Type.mc_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="mc_type_code" type="xsd:unsignedInt" use="optional"/>

mc_calc_size
Type:
xsd:unsignedInt, predefined
Use:
optional
Parameter “x” used for the calculation
XML Source (w/o annotations (1))
<xsd:attribute name="mc_calc_size" type="xsd:unsignedInt" use="optional"/>

collect_duration
Type:
xsd:double, predefined
Use:
optional
Actual duration for this measurement event’s data collection
XML Source (w/o annotations (1))
<xsd:attribute name="collect_duration" type="xsd:double" use="optional"/>

dur_eu_db_site
Type:
Use:
optional
Foreign key reference to Eng_Unit_Type.eu_db_site (Eng. units for default collection duration)
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="dur_eu_db_site" type="site_codeSimpleType" use="optional"/>

dur_eu_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Eng_Unit_Type.eu_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="dur_eu_db_id" type="xsd:unsignedInt" use="optional"/>

dur_eu_type_code
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Eng_Unit_Type.eu_type_code
XML Source (w/o annotations (1))
<xsd:attribute name="dur_eu_type_code" type="xsd:unsignedInt" use="optional"/>

confid_percent
Type:
xsd:unsignedShort, predefined
Use:
optional
Confidence in measurement accuracy (0=no confidence, 100=complete confidence)
XML Source (w/o annotations (1))
<xsd:attribute name="confid_percent" type="xsd:unsignedShort" 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