complexType "meas_locationTYPE"
Namespace:
Content:
complex, 47 attributes, 1 element
Defined:
globally in CRIS_Complete_V3-2-1_[31-Dec-2008].xsd, see XML source
Includes:
definitions of 47 attributes and 1 element
Used:
XML Representation Summary
<...
    meas_loc_site
 = 
xsd:hexBinary
    meas_loc_id
 = 
xsd:unsignedInt
    ml_db_site
 = 
xsd:hexBinary
    ml_db_id
 = 
xsd:unsignedInt
    ml_type_code
 = 
xsd:unsignedInt
    segment_or_asset
 = 
("A" | "S")
    segment_site
 = 
xsd:hexBinary
    segment_id
 = 
xsd:unsignedInt
    asset_org_site
 = 
xsd:hexBinary
    asset_id
 = 
xsd:unsignedInt
    ds_db_site
 = 
xsd:hexBinary
    ds_db_id
 = 
xsd:unsignedInt
    ds_type_code
 = 
xsd:unsignedInt
    tr_db_site
 = 
xsd:hexBinary
    tr_db_id
 = 
xsd:unsignedInt
    tr_type_code
 = 
xsd:unsignedInt
    ta_orient_deg
 = 
xsd:unsignedInt
    ta_db_site
 = 
xsd:hexBinary
    ta_db_id
 = 
xsd:unsignedInt
    ta_type_code
 = 
xsd:unsignedInt
    mim_loc_seq
 = 
xsd:unsignedInt
    motion_direction
 = 
("N" | "R")
    mim_user_prefix
 = 
xsd:string
    mc_db_site
 = 
xsd:hexBinary
    mc_db_id
 = 
xsd:unsignedInt
    mc_type_code
 = 
xsd:unsignedInt
    mc_calc_size
 = 
xsd:unsignedInt
    update_interval
 = 
xsd:double
    int_eu_db_site
 = 
xsd:hexBinary
    int_eu_db_id
 = 
xsd:unsignedInt
    int_eu_type_code
 = 
xsd:unsignedInt
    collect_duration
 = 
xsd:double
    dur_eu_db_site
 = 
xsd:hexBinary
    dur_eu_db_id
 = 
xsd:unsignedInt
    dur_eu_type_code
 = 
xsd:unsignedInt
    ml_eu_db_site
 = 
xsd:hexBinary
    ml_eu_db_id
 = 
xsd:unsignedInt
    ml_eu_type_code
 = 
xsd:unsignedInt
    xml_data_type
 = 
xsd:string
    xml_pattern_regex
 = 
xsd:string
    user_tag_ident
 = 
xsd:string
    barcode
 = 
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 Location Entity:
The Measurement Location table identifies the physical position on an asset or segment where actual measurements will be taken along with the associated Measurement Location Type. In order for multiple enterprises to exchange MIMOSA information, every Measurement Location must request and utilize its unique, unchanging MIMOSA Measurement Location Code.
The MIMOSA Measurement Location Code is the Site-assigned unique identifier of a Measurement Location. Because of multiple methodologies for serialized measurement location tracking identification in different industries and in various monitoring systems installed over time, a Measurement Location may be associated with different identifiers relevant to the Measurement Location because they are the measurement location's "unique tag" for various databases.
Because of this requirement, MIMOSA-compliant systems require that a Measurement Location be permanently assigned one and only one MIMOSA Measurement Location Code which is composed of the associated MIMOSA Site Code (in CRIS, the "meas_loc_site") concatenated with a site-unique, non-negative integer (in CRIS, the "meas_loc_id") which should never change throughout the lifetime of the Measurement Location.
This MIMOSA Measurement Location Code (MIMOSA Site Code + "meas_loc_id") normally does not have any external end-user meaning, but is the vital link for all MIMOSA-compliant systems to properly integrate and associate information to the correct Measurement Location.
The identical MIMOSA Measurement Location Code must remain permanently-unique for the life-time of the Site, even though it will most likely have additional temporarily-unique identifier tags assigned to the Measurement Location by various systems.
This entity also stores the source of the measurement data, the type of transducer which will be used (if applicable), the degree of the transducer’s angular orientation (if applicable), and the corresponding transducer sensitive axis direction code (if applicable).
Note: This entity specifices the default location type which will categorize the measurements which will be collected and stored. Each Measurement Event of a Measurement Location can also map to a location type for an “event-specific” category.
Although this table does not physically restrict it, a measurement location must be assigned to either a segment or an asset in this table, as indicated by the segment_or_asset column, but not both.
The degree of the transducer’s angular orientation (column ta_orient_deg) (0-360) and the corresponding transducer sensitive axis direction code, if applicable, is stored in this table.
The specification of the MIMOSA Vibration Measurement Location Code as specified in Document MIM-VB-001, is based on appending the following columns together to form a 14-character unique MIMOSA Location Code. The following columns from this table are used directly or as foreign key references to create this code:
Component Part => mim_user_prefix (4 characters or XXXX if NULL)
Bearing Housing Location on Machine System => mim_loc_seq (3-digits with leading zeroes)
Transducer Type => trans_type.user_tag_ident (first 2 characters in field referenced by tr_db_site, tr_db_id, tr_type_code or XX if NULL)
Angular Orientation => ta_orient_deg (3 digits with leading zeroes or XXX if NULL)
Transducer Sensitive Axis Direction => 1st character from tr_axis_dir_type.name referenced by ta_db_site, ta_db_id, ta_type_code
Direction of Motion => motion direction (1 character or X if NULL)
Note: The "user_tag_ident" is the user identification tag which follows the nomenclature of the end-user. This is normally an abbreviation or user-defined alpha-numeric code from which the end-user derives meaning. This column is mandatory.
XML Source (w/o annotations (48))
<xsd:complexType name="meas_locationTYPE">
<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="ml_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="ml_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="ml_type_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="segment_or_asset" type="charAS" use="required"/>
<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_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="ds_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="ds_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="tr_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="tr_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="tr_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="ta_orient_deg" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="ta_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="ta_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="ta_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="mim_loc_seq" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="motion_direction" type="charNR" use="optional"/>
<xsd:attribute name="mim_user_prefix" type="varchar254" 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="update_interval" type="xsd:double" use="optional"/>
<xsd:attribute name="int_eu_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="int_eu_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="int_eu_type_code" 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="ml_eu_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="ml_eu_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="ml_eu_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="xml_data_type" type="varchar254" use="optional"/>
<xsd:attribute name="xml_pattern_regex" type="varchar254" use="optional"/>
<xsd:attribute name="user_tag_ident" type="varchar254" use="optional"/>
<xsd:attribute name="barcode" 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; 47/47)
meas_loc_site
Type:
Use:
required
Foreign key reference to Site.site_code, 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
Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="meas_loc_id" type="xsd:unsignedInt" use="required"/>

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

ml_db_id
Type:
xsd:unsignedInt, predefined
Use:
required
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="required"/>

ml_type_code
Type:
xsd:unsignedInt, predefined
Use:
required
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="required"/>

segment_or_asset
Type:
Use:
required
Attribute Value
enumeration of xsd:string
Enumeration:
"A", "S"
Length:
1
XML Source (w/o annotations (1))
<xsd:attribute name="segment_or_asset" type="charAS" use="required"/>

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_db_site
Type:
Use:
optional
Foreign key reference to Data_Source_Type.ds_db_site
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="ds_db_site" type="site_codeSimpleType" use="optional"/>

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

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

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

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

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

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

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

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

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

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

motion_direction
Type:
Use:
optional
Valid ‘N’ and ‘R’
Attribute Value
enumeration of xsd:string
Enumeration:
"N", "R"
Length:
1
XML Source (w/o annotations (1))
<xsd:attribute name="motion_direction" type="charNR" use="optional"/>

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

mc_db_site
Type:
Use:
optional
Foreign key reference to Mloc_Calc_Type.mc_db_site (Default method that measurement is 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_type_code
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"/>

update_interval
Type:
xsd:double, predefined
Use:
optional
Default frequency that measurements at this location will be updated
XML Source (w/o annotations (1))
<xsd:attribute name="update_interval" type="xsd:double" use="optional"/>

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

int_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="int_eu_db_id" type="xsd:unsignedInt" use="optional"/>

int_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="int_eu_type_code" type="xsd:unsignedInt" use="optional"/>

collect_duration
Type:
xsd:double, predefined
Use:
optional
Default duration of collection for measurements at this location
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 (Time 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"/>

ml_eu_db_site
Type:
Use:
optional
Foreign key reference to Eng_Unit_Type.eu_db_site to specify an optional default engineering unit
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="ml_eu_db_site" type="site_codeSimpleType" use="optional"/>

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

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

xml_data_type
Type:
Use:
optional
Stores the XML data type for the data stored in this measurement location
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="xml_data_type" type="varchar254" use="optional"/>

xml_pattern_regex
Type:
Use:
optional
Stores the XML regular expression for character data stored in this measurement location
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="xml_pattern_regex" type="varchar254" 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"/>

barcode
Type:
Use:
optional
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="barcode" 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