complexType "binary_num_dataTYPE"
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
    ordering_seq
 = 
xsd:unsignedInt
    gmt_reference
 = 
xsd:dateTime
    total_data_items
 = 
xsd:unsignedInt
    offsets_eu_db_site
 = 
xsd:hexBinary
    offsets_eu_db_id
 = 
xsd:unsignedInt
    offsets_eu_type_code
 = 
xsd:unsignedInt
    offsets_std_data_type_code
 = 
xsd:unsignedShort
    values_eu_db_site
 = 
xsd:hexBinary
    values_eu_db_id
 = 
xsd:unsignedInt
    values_eu_type_code
 = 
xsd:unsignedInt
    values_std_data_type_code
 = 
xsd:unsignedShort
    offsets_binary_data
 = 
xsd:base64Binary
    values_binary_data
 = 
xsd:base64Binary
    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 Binary Numeric Data
Allows the storage of Unlimited Numeric Data of the same Engineering Unit, Each Paired With an Associated Offset Time from a base reference time associated with a Measurement Event.
This entity is usually used to store large amounts of numeric data which was captured intermittently over a period of time from a single reference time.
Note that periodically collected time waveform numeric data (i.e., every second) should be stored in the sp_time_data table.
XML Source (w/o annotations (21))
<xsd:complexType name="binary_num_dataTYPE">
<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="ordering_seq" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="gmt_reference" type="dateTimeWithoutTimezone" use="required"/>
<xsd:attribute name="total_data_items" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="offsets_eu_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="offsets_eu_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="offsets_eu_type_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="offsets_std_data_type_code" type="xsd:unsignedShort" use="required"/>
<xsd:attribute name="values_eu_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="values_eu_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="values_eu_type_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="values_std_data_type_code" type="xsd:unsignedShort" use="required"/>
<xsd:attribute name="offsets_binary_data" type="xsd:base64Binary" use="required"/>
<xsd:attribute name="values_binary_data" type="xsd:base64Binary" use="required"/>
<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 Meas_Event.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_Event.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 Meas_Event.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"/>

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

gmt_reference
Type:
Use:
required
GMT/UTC reference time (start offset of 0)
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_reference" type="dateTimeWithoutTimezone" use="required"/>

total_data_items
Type:
xsd:unsignedInt, predefined
Use:
required
Total number of offset/value data pairs
XML Source (w/o annotations (1))
<xsd:attribute name="total_data_items" type="xsd:unsignedInt" use="required"/>

offsets_eu_db_site
Type:
Use:
required
Foreign key reference to Eng_Unit_Type.eu_db_site (of the offset for each data pair, which would refer to time-related entries such as "millisecond" or "second")
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="offsets_eu_db_site" type="site_codeSimpleType" use="required"/>

offsets_eu_db_id
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Eng_Unit_Type.eu_db_id (of the offset for each data pair, which would refer to time-related entries such as "millisecond" or "second")
XML Source (w/o annotations (1))
<xsd:attribute name="offsets_eu_db_id" type="xsd:unsignedInt" use="required"/>

offsets_eu_type_code
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Eng_Unit_Type.eu_type_code (of the offset for each data pair, which would refer to time-related entries such as "millisecond" or "second")
XML Source (w/o annotations (1))
<xsd:attribute name="offsets_eu_type_code" type="xsd:unsignedInt" use="required"/>

offsets_std_data_type_code
Type:
xsd:unsignedShort, predefined
Use:
required
Foreign key reference to Standard_Data_Type.std_data_type_code (identifies how offsets are represented as numeric data types in all data pairs (4-byte integer, etc.))
XML Source (w/o annotations (1))
<xsd:attribute name="offsets_std_data_type_code" type="xsd:unsignedShort" use="required"/>

values_eu_db_site
Type:
Use:
required
Foreign key reference to Eng_Unit_Type.eu_db_site (of the value for each data pair, which would refer to the engineering unit of the value itself such as "inches", "meters", "GPM", etc.)
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="values_eu_db_site" type="site_codeSimpleType" use="required"/>

values_eu_db_id
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Eng_Unit_Type.eu_db_id (of the value for each data pair, which would refer to the engineering unit of the value itself such as "inches", "meters", "GPM", etc.)
XML Source (w/o annotations (1))
<xsd:attribute name="values_eu_db_id" type="xsd:unsignedInt" use="required"/>

values_eu_type_code
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Eng_Unit_Type.eu_type_code (of the value for each data pair, which would refer to the engineering unit of the value itself such as "inches", "meters", "GPM", etc.)
XML Source (w/o annotations (1))
<xsd:attribute name="values_eu_type_code" type="xsd:unsignedInt" use="required"/>

values_std_data_type_code
Type:
xsd:unsignedShort, predefined
Use:
required
Foreign key reference to Standard_Data_Type.std-data_type_code (identifies how values are represented as numeric data types in all data pairs (Unsigned 4-byte integer, Signed 8-byte integer, etc.))
XML Source (w/o annotations (1))
<xsd:attribute name="values_std_data_type_code" type="xsd:unsignedShort" use="required"/>

offsets_binary_data
Type:
xsd:base64Binary, predefined
Use:
required
Variable-length binary field containing all offsets. The offsets are all the time offsets represented in offset_standard_data_type format (4-byte integer, etc.) of the specified offset times in offset Engineering Units (milliseconds, seconds, etc.) associated with each value from time "0" which equals the gmt_reference time.
XML Source (w/o annotations (1))
<xsd:attribute name="offsets_binary_data" type="xsd:base64Binary" use="required"/>

values_binary_data
Type:
xsd:base64Binary, predefined
Use:
required
Variable-length binary field containing all associated values for each offset stored in offset_binary_data. The values are all the numeric data represented in value_standard_data_type format (signed 8-byte integer, etc.) in the specified Engineering Unit Type format (meters, etc.).
XML Source (w/o annotations (1))
<xsd:attribute name="values_binary_data" type="xsd:base64Binary" use="required"/>

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