complexType "siteTYPE"
Namespace:
Content:
complex, 16 attributes, 1 element
Defined:
globally in CRIS_Complete_V3-2-1_[31-Dec-2008].xsd, see XML source
Includes:
definitions of 16 attributes and 1 element
Used:
XML Representation Summary
<...
    site_code
 = 
xsd:hexBinary
    enterprise_id
 = 
xsd:unsignedInt
    site_id
 = 
xsd:unsignedInt
    st_db_site
 = 
xsd:hexBinary
    st_db_id
 = 
xsd:unsignedInt
    st_type_code
 = 
xsd:unsignedInt
    user_tag_ident
 = 
xsd:string
    name
 = 
xsd:string
    duns_number
 = 
xsd:unsignedInt
    template_yn
 = 
("Y" | "N")
    segment_site
 = 
xsd:hexBinary
    segment_id
 = 
xsd:unsignedInt
    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
Site Entity:
A Site is an enterprise-defined object (manufacturing plant, office facility, large fleet object [aircraft carrier]) which is responsible to uniquely register Assets, Agents, Databases, Measurement Locations which need to be "birthed" with MIMOSA Codes.
Sites are also required to generate unique MIMOSA Segment Codes for functional Segments which provide breakdown structures related to a Site, a Model, an Asset, or an Agent.
Each Site is associated with exactly one Site Type. For facility applications, the “Site” normally represents a tangible as-built building. For industrial and manufacturing applications, this entity normally represents a physical plant.
For fleet applications, this entity normally represents operating depots or other facilities which manage a fleet of objects (trucks, tanks, aircraft, etc). In some cases the site may be the entire mobile object, such as an aircraft carrier or cruise ship.
The MIMOSA Site Code (column "site_code) is the Enterprise-assigned unique identifier of a Site. Because of multiple methodologies for site/plant/platform identification in different industries and in various computer systems, a Site will often need to be associated with many identifiers relevant to the Site because they are the site's "unique key" for various databases.
These identifiers may change as a Site is sold, transferred, or its role changes in relationship to multiple other Sites or Enterprises.
Because of this requirement, MIMOSA CRIS-compliant systems require that a Site be permanently assigned one and only one MIMOSA Site Code (represented by a fixed-length 16-character hexadecimal string) which is composed of the birth MIMOSA Enterprise Code (represented by a fixed-length 8-character hexadecimal string) concatenated with a site-unique, non-negative integer site_id (also represented by a fixed-length 8-character hexadecimal string).
This MIMOSA Site Code (MIMOSA Enterprise Code + "site_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 Site.
The identical MIMOSA Site 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 Site by various systems.
Each enterprise is free to assign site_id’s in the range from 0 – 4,294967,295 (Hex “00000000” – “FFFFFFFF”). Once this assignment has been made, the number should not be changed.
The site’s user_tag_ident attribute is the user identification tag which is an alpha-numeric string which should be unique for each site in an enterprise.
Some sites may be logical sites used as a design template for physical Site instances. The template_yn column is used to define whether or not a particular Site instance is to be used as a template.
XML Source (w/o annotations (17))
<xsd:complexType name="siteTYPE">
<xsd:sequence>
<xsd:element minOccurs="0" name="lcinfo" type="lcinfo"/>
</xsd:sequence>
<xsd:attribute name="site_code" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="enterprise_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="site_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="st_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="st_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="st_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="duns_number" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="template_yn" type="charYN" 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="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; 16/16)
site_code
Type:
Use:
required
The MIMOSA Site Code which combines the MIMOSA Enterprise Code and the site_id (both 4-byte non-negative integers) into a globally unique, fixed-length 16-character string.
The first 8-characters represent the hex value of the 4-byte non-negative MIMOSA Enterprise Code.
The second 8-characters represent the hex value of the 4-byte non-negative site_id integer assigned by the birth enterprise registration authority.
Included in composite primary key
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="site_code" type="site_codeSimpleType" use="required"/>

enterprise_id
Type:
xsd:unsignedInt, predefined
Use:
required
This is a FK to the enterprise which currently controls this site.
It may or may not be the original birth enterprise GUID which was permanently associated with the site_code.
If a site is acquired by a new enterprise, this field will change to match the new enterprise id.
Foreign key reference to Enterprise.enterprise_id
XML Source (w/o annotations (1))
<xsd:attribute name="enterprise_id" type="xsd:unsignedInt" use="required"/>

site_id
Type:
xsd:unsignedInt, predefined
Use:
required
For informational use only to reduce the parsing required in the site_code to extract. Once assigned, this field should never change.
It is the 4-byte non-negative site integer unique to the enterprise, assigned by the original birth enterprise registration authority and should always match the value represented by the 8 right-most hex characters in the site_code column.
XML Source (w/o annotations (1))
<xsd:attribute name="site_id" type="xsd:unsignedInt" use="required"/>

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

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

st_type_code
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Site_Type.st_type_code
XML Source (w/o annotations (1))
<xsd:attribute name="st_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"/>

duns_number
Type:
xsd:unsignedInt, predefined
Use:
optional
D-U-N-S number for the site, where relevant
XML Source (w/o annotations (1))
<xsd:attribute name="duns_number" type="xsd:unsignedInt" use="optional"/>

template_yn
Type:
Use:
optional
If set to 'Y', identifies that a particular Site entry is a template Site
Attribute Value
enumeration of xsd:string
Enumeration:
"Y", "N"
Length:
1
XML Source (w/o annotations (1))
<xsd:attribute name="template_yn" type="charYN" 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"/>

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