Touchstone 2022 Database Reference
TblSourceDefaultTarget_Xref Table
AIRGeography Database : TblSourceDefaultTarget_Xref Table
Description
Stores information that the application uses in the airsp_EA_PagingPrepare stored procedure to retrieve the highest weighted regions and 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
Rows1254242
Data Space Used89,592.00 KB
Index Space Used432.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key guidExternalSourceGUID of the low-level zone.dbo.GUID16   
Primary Key intWeightTypeId

Identifier for the weight type. 

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

int4   
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).float9  
 dblMinCovBMinimum replacement cost for Coverage B (other structures).float9  
 dblMinCovCMinimum replacement cost for Coverage  C(contents).float9  
 dblMinCovDMinimum replacement cost for Coverage D (time element).float9  
Objects that TblSourceDefaultTarget_Xref depends on
 Database ObjectObject TypeDescriptionDep Level
TblAreaExternal tableTblAreaExternalTableStores valid area information.1
TblAreaWeightType tableTblAreaWeightTypeTableStores a list of supported area weight types.1
See Also

Related Objects

AIRGeography Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.