complexType "sp_time_dataTYPE"
Namespace:
Content:
complex, 37 attributes, 1 element
Defined:
globally in CRIS_Complete_V3-2-1_[31-Dec-2008].xsd, see XML source
Includes:
definitions of 37 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
    eu_db_site
 = 
xsd:hexBinary
    eu_db_id
 = 
xsd:unsignedInt
    eu_type_code
 = 
xsd:unsignedInt
    secs_or_revs
 = 
("S" | "R")
    off_secs_or_revs
 = 
xsd:double
    max_secs_or_revs
 = 
xsd:double
    number_of_samples
 = 
xsd:double
    win_db_site
 = 
xsd:hexBinary
    win_db_id
 = 
xsd:unsignedInt
    win_type_code
 = 
xsd:unsignedInt
    ave_db_site
 = 
xsd:hexBinary
    ave_db_id
 = 
xsd:unsignedInt
    ave_type_code
 = 
xsd:unsignedInt
    ave_wt_db_site
 = 
xsd:hexBinary
    ave_wt_db_id
 = 
xsd:unsignedInt
    ave_wt_type_code
 = 
xsd:unsignedInt
    ave_sy_db_site
 = 
xsd:hexBinary
    ave_sy_db_id
 = 
xsd:unsignedInt
    ave_sy_type_code
 = 
xsd:unsignedInt
    ave_overlap_pct
 = 
xsd:double
    num_of_averages
 = 
xsd:unsignedInt
    sp_str_db_site
 = 
xsd:hexBinary
    sp_str_db_id
 = 
xsd:unsignedInt
    sp_stream_id
 = 
xsd:unsignedInt
    assoc_rpm_in_hz
 = 
xsd:double
    user_tag_ident
 = 
xsd:string
    name
 = 
xsd:string
    complex_yn
 = 
("Y" | "N")
    waveform_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
Signal-Processed, Real/Complex Linear Time Waveform Data Entity:
This entity stores real-only or complex time waveform data which resulted as an output of a measurement event. A complex time waveform is obtained when you have a decimated signal over a certain frequency range.
Note: The waveform_data column is a variable-length binary field, first containing number_of_samples 4-byte IEEE float real values. If the complex_yn field = ‘Y’, another set of number_of_samples 4-byte IEEE DOUBLE format values, the imaginary values, follow the set of real values.
The IEEE format is: Low-Order Byte First; bits 0-22 --> Mantissa; bits 23-30 --> Exponent; bit 31 --> Sign
Note: The off_secs_or_revs column is the delta offset start time in seconds or offset number of revolutions from gmt_event time when the sample started.
Note: The ave_overlap_pct column is a percentage ranging from 0 to 100 of the average overlap percentage used.
XML Source (w/o annotations (38))
<xsd:complexType name="sp_time_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="eu_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="eu_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="eu_type_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="secs_or_revs" type="charSR" use="required"/>
<xsd:attribute name="off_secs_or_revs" type="xsd:double" use="required"/>
<xsd:attribute name="max_secs_or_revs" type="xsd:double" use="required"/>
<xsd:attribute name="number_of_samples" type="xsd:double" use="required"/>
<xsd:attribute name="win_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="win_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="win_type_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="ave_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="ave_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="ave_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="ave_wt_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="ave_wt_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="ave_wt_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="ave_sy_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="ave_sy_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="ave_sy_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="ave_overlap_pct" type="xsd:double" use="optional"/>
<xsd:attribute name="num_of_averages" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="sp_str_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="sp_str_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="sp_stream_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="assoc_rpm_in_hz" type="xsd:double" use="optional"/>
<xsd:attribute name="user_tag_ident" type="varchar254" use="optional"/>
<xsd:attribute name="name" type="varchar254" use="optional"/>
<xsd:attribute name="complex_yn" type="charYN" use="required"/>
<xsd:attribute name="waveform_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; 37/37)
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
Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="ordering_seq" type="xsd:unsignedInt" use="required"/>

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

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

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

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

off_secs_or_revs
Type:
xsd:double, predefined
Use:
required
XML Source (w/o annotations (1))
<xsd:attribute name="off_secs_or_revs" type="xsd:double" use="required"/>

max_secs_or_revs
Type:
xsd:double, predefined
Use:
required
XML Source (w/o annotations (1))
<xsd:attribute name="max_secs_or_revs" type="xsd:double" use="required"/>

number_of_samples
Type:
xsd:double, predefined
Use:
required
XML Source (w/o annotations (1))
<xsd:attribute name="number_of_samples" type="xsd:double" use="required"/>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

assoc_rpm_in_hz
Type:
xsd:double, predefined
Use:
optional
XML Source (w/o annotations (1))
<xsd:attribute name="assoc_rpm_in_hz" type="xsd:double" 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"/>

complex_yn
Type:
Use:
required
Attribute Value
enumeration of xsd:string
Enumeration:
"Y", "N"
Length:
1
XML Source (w/o annotations (1))
<xsd:attribute name="complex_yn" type="charYN" use="required"/>

waveform_data
Type:
xsd:base64Binary, predefined
Use:
required
XML Source (w/o annotations (1))
<xsd:attribute name="waveform_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