complexType "sp_ampl_dataTYPE"
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
<...
    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
    pst_sc_db_site
 = 
xsd:hexBinary
    pst_sc_db_id
 = 
xsd:unsignedInt
    pst_sc_type_code
 = 
xsd:unsignedInt
    freq_or_order
 = 
("F" | "O")
    min_in_hz_or_ord
 = 
xsd:double
    max_in_hz_or_ord
 = 
xsd:double
    src_dt_db_site
 = 
xsd:hexBinary
    src_dt_db_id
 = 
xsd:unsignedInt
    src_dt_type_code
 = 
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
    amplitude
 = 
xsd:double
    angle_in_degrees
 = 
xsd:double
    user_tag_ident
 = 
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
Signal-Processec Frequency/Order Single Amplitude/Vector Data Entity:
This entity stores one or more single amplitueds AND/OR single vectors which are related to frequency or order ranges which resulted as an output of a measurement event.
Note: A vector can be stored by placing the angle in degrees in the angle_in_degrees column.
Note: If the source signal detector type is “FFT Power RMS”, the amplitude field is calculated from the spectra by taking the square root of the sum of all amplitude values squared which is then divided by the window factor.
XML Source (w/o annotations (29))
<xsd:complexType name="sp_ampl_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="pst_sc_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="pst_sc_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="pst_sc_type_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="freq_or_order" type="charFO" use="required"/>
<xsd:attribute name="min_in_hz_or_ord" type="xsd:double" use="required"/>
<xsd:attribute name="max_in_hz_or_ord" type="xsd:double" use="required"/>
<xsd:attribute name="src_dt_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="src_dt_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="src_dt_type_code" 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="amplitude" type="xsd:double" use="required"/>
<xsd:attribute name="angle_in_degrees" 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="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; 28/28)
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"/>

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

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

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

freq_or_order
Type:
Use:
required
Attribute Value
enumeration of xsd:string
Enumeration:
"F", "O"
Length:
1
XML Source (w/o annotations (1))
<xsd:attribute name="freq_or_order" type="charFO" use="required"/>

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

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

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

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

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

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

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

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