complexType "transducerTYPE"
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
<...
    tr_asset_site
 = 
xsd:hexBinary
    tr_asset_id
 = 
xsd:unsignedInt
    tr_db_site
 = 
xsd:hexBinary
    tr_db_id
 = 
xsd:unsignedInt
    tr_type_code
 = 
xsd:unsignedInt
    out_eu_db_site
 = 
xsd:hexBinary
    out_eu_db_id
 = 
xsd:unsignedInt
    out_eu_type_code
 = 
xsd:unsignedInt
    out_amplitude
 = 
xsd:double
    per_eu_db_site
 = 
xsd:hexBinary
    per_eu_db_id
 = 
xsd:unsignedInt
    per_eu_type_code
 = 
xsd:unsignedInt
    gmt_last_calib
 = 
xsd:dateTime
    self_powered_yn
 = 
("Y" | "N")
    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
Transducer Asset Entity (Subset of Asset Entity):
This entity is a subset of the asset table and catalogs all the transducers used to take measurements.
The output amplitude and output amplitude units describe the raw analog output signal which comes from the transducer (i.e. 200 millivolts) representing 1 resulting engineering unit (the “per” engineering unit fields, i.e. MIL).
Note: Measurements can be stored in the measurement event table without transducer information, so entries in this table are not required.
XML Source (w/o annotations (21))
<xsd:complexType name="transducerTYPE">
<xsd:sequence>
<xsd:element minOccurs="0" name="lcinfo" type="lcinfo"/>
</xsd:sequence>
<xsd:attribute name="tr_asset_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="tr_asset_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="tr_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="tr_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="tr_type_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="out_eu_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="out_eu_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="out_eu_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="out_amplitude" type="xsd:double" use="optional"/>
<xsd:attribute name="per_eu_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="per_eu_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="per_eu_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="gmt_last_calib" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="self_powered_yn" type="charYN" 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; 20/20)
tr_asset_site
Type:
Use:
required
Foreign key reference to Asset.asset_org_site, Included in composite primary key
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="tr_asset_site" type="site_codeSimpleType" use="required"/>

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

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

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

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

out_eu_db_site
Type:
Use:
optional
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="out_eu_db_site" type="site_codeSimpleType" use="optional"/>

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

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

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

per_eu_db_site
Type:
Use:
optional
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="per_eu_db_site" type="site_codeSimpleType" use="optional"/>

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

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

gmt_last_calib
Type:
Use:
optional
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_calib" type="dateTimeWithoutTimezone" use="optional"/>

self_powered_yn
Type:
Use:
optional
Attribute Value
enumeration of xsd:string
Enumeration:
"Y", "N"
Length:
1
XML Source (w/o annotations (1))
<xsd:attribute name="self_powered_yn" type="charYN" 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