complexType "assetTYPE"
Namespace:
Content:
complex, 28 attributes, 1 element
Defined:
globally in CRIS_Complete_V3-2-1_[31-Dec-2008].xsd, see XML source
Includes:
definitions of 28 attributes and 1 element
Used:
XML Representation Summary
<...
    asset_org_site
 = 
xsd:hexBinary
    asset_id
 = 
xsd:unsignedInt
    as_db_site
 = 
xsd:hexBinary
    as_db_id
 = 
xsd:unsignedInt
    as_type_code
 = 
xsd:unsignedInt
    user_tag_ident
 = 
xsd:string
    name
 = 
xsd:string
    long_description
 = 
xsd:string
    criticality
 = 
xsd:int
    cs_type_db_site
 = 
xsd:hexBinary
    cs_type_db_id
 = 
xsd:unsignedInt
    cs_type_code
 = 
xsd:unsignedInt
    mf_db_site
 = 
xsd:hexBinary
    mf_db_id
 = 
xsd:unsignedInt
    manuf_code
 = 
xsd:unsignedInt
    model_db_site
 = 
xsd:hexBinary
    model_db_id
 = 
xsd:unsignedInt
    model_id
 = 
xsd:unsignedInt
    serial_number
 = 
xsd:string
    asr_db_site
 = 
xsd:hexBinary
    asr_db_id
 = 
xsd:unsignedInt
    asr_type_code
 = 
xsd:unsignedInt
    segment_site
 = 
xsd:hexBinary
    segment_id
 = 
xsd:unsignedInt
    last_upd_db_site
 = 
xsd:hexBinary
    last_upd_db_id
 = 
xsd:unsignedInt
    gmt_last_updated
 = 
xsd:dateTime
    rstat_type_code
 = 
xsd:unsignedShort
    >
   
Content: 
lcinfo?
</...>
Content Elements (1):
lcinfo (type lcinfo)
Known Usage Locations
Annotation
Asset Entity:
  • An Asset is a physical, non-intelligent instantiated object. An Asset may be an entire facility, an entire functioning system (such as an CH-47 Tail Number XYZ helicopter), or a component piece of equipment, such as a specific instance of a bearing.
  • An Asset can be monitored via Measurement Locations, be associated with work, and may be composed of one or more Asset Child Structures.
  • When first referenced in a MIMOSA-compliant system, an origination Site permanently assigns an Asset a MIMOSA Asset Code.
  • The MIMOSA Asset Code is the Site-assigned unique identifier of an Asset.
  • Because of multiple methodologies for serialized asset/component tracking identification in different industries and in various computer systems, an Asset will often need to be associated with many identifiers relevant to the Asset because they are the asset's "unique key" for various databases.
  • These identifiers may change as an Asset is sold, leased, or refurbished and moves throughout multiple Sites or Enterprises.
  • Because of this requirement, MIMOSA-compliant systems require that an Asset be permanently assigned one and only one MIMOSA Asset Code which is composed of the birth MIMOSA Site Code (in CRIS, the "asset_org_site") concatenated with a site-unique, non-negative integer (in CRIS, the "asset_id") which should never change throughout the lifetime of the Asset.
  • This MIMOSA Asset Code (MIMOSA Site Code + "asset_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 Asset.
  • The identical MIMOSA Asset Code must remain permanently-unique for the life-time of the Asset, even though it will most likely have additional temporarily-unique identifier tags assigned to the Asset by various systems.
  • The optional Segment foreign key is the top-level "as-built" breakdown structure for the asset, which is different than the "as-utilized" functional location segment for the asset (asset_on_segment) which tracks where an asset is utilized over time.
  • Note: "User_tag_ident" is the user identification tag which follows the nomenclature of the end-user. This is normally an abbreviation or user-defined code. This column is mandatory.
  • The “name” column is an optional column which is a full description of the asset.
XML Source (w/o annotations (29))
<xsd:complexType name="assetTYPE">
<xsd:sequence>
<xsd:element minOccurs="0" name="lcinfo" type="lcinfo"/>
</xsd:sequence>
<xsd:attribute name="asset_org_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="asset_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="as_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="as_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="as_type_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="user_tag_ident" type="varchar254" use="optional"/>
<xsd:attribute name="name" type="varchar254" use="optional"/>
<xsd:attribute name="long_description" type="varchar4000" use="optional"/>
<xsd:attribute name="criticality" type="xsd:int" use="optional"/>
<xsd:attribute name="cs_type_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="cs_type_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="cs_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="mf_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="mf_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="manuf_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="model_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="model_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="model_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="serial_number" type="varchar254" use="optional"/>
<xsd:attribute name="asr_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="asr_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="asr_type_code" type="xsd:unsignedInt" 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="last_upd_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="last_upd_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="gmt_last_updated" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="rstat_type_code" type="xsd:unsignedShort" use="optional"/>
</xsd:complexType>
Attribute Detail (defined in this component only; 28/28)
asset_org_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="asset_org_site" type="site_codeSimpleType" use="required"/>

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

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

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

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

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"/>

long_description
Type:
Use:
optional
Long_description field
Attribute Value
xsd:string
MaxLength:
4000
XML Source (w/o annotations (1))
<xsd:attribute name="long_description" type="varchar4000" use="optional"/>

criticality
Type:
xsd:int, predefined
Use:
optional
Criticality index with the scale's minimum and maximum value determined by the FK to Criticality_Scale_Type
XML Source (w/o annotations (1))
<xsd:attribute name="criticality" type="xsd:int" use="optional"/>

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

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

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

mf_db_site
Type:
Use:
optional
Foreign key reference to Manufacture.mf_db_site (Only use if no FK to Model table, since the Model table includes the Manufacturer)
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="mf_db_site" type="site_codeSimpleType" use="optional"/>

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

manuf_code
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Manufacture.mf_manuf_code (Optional Manufacturer FK)
XML Source (w/o annotations (1))
<xsd:attribute name="manuf_code" type="xsd:unsignedInt" use="optional"/>

model_db_site
Type:
Use:
optional
Foreign key reference to Model.model_db_site (The model table is the recommended location to associate the manufacturer for the asset)
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="model_db_site" type="site_codeSimpleType" use="optional"/>

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

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

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

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

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

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

segment_site
Type:
Use:
optional
Foreign key reference to Segment.segment_site (Refers to default functional breakdown structure)
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 (Refers to default functional breakdown structure)
XML Source (w/o annotations (1))
<xsd:attribute name="segment_id" type="xsd:unsignedInt" 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"/>

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"/>

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