Touchstone 4.0 Database Documentation
TblSourceDefaultTarget_Xref Table
Description
System reference table used by airsp_EA_PagingPrepare to retrieve the highest weighted regions. This value is used to assign values to regions that do not have a high enough weight.
Properties
Creation Date4/27/2010 10:32 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows621840
Data Space Used73,072.00 KB
Index Space Used352.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key guidExternalSourceGUID of the low-level zone.Binary16   
Primary Key intWeightTypeId

Identifier for the weight type. 

For a complete list of weight types, see TblAreaWeightType Table.

Integer4   
Primary Key intGridIdDefaultHighest weighted level for this zone and weight type.BigInt8   
 strCurrency

Code that represents the currency type. 

For a complete list of codes, see tCurrency Table

Char3   
 dblMinCovAMinimum replacement cost for Coverage A (buildings).Double9  
 dblMinCovBMinimum replacement cost for Coverage B (other structures).Double9  
 dblMinCovCMinimum replacement cost for Coverage  C(contents).Double9  
 dblMinCovDMinimum replacement cost for Coverage D (time element).Double9  
Objects that TblSourceDefaultTarget_Xref depends on
 Database ObjectObject TypeDescriptionDep Level
TblAreaExternal tableTblAreaExternalTableStored valid area information.1
TblAreaWeightType tableTblAreaWeightTypeTableDefines the area weight type. Used by airsp_DistributeCrestaLocations.1
See Also

Related Objects

AIRGeography Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.