Touchstone 4.0 Database Documentation
TblAreaExternal Table
Description
Stored valid area information.
Properties
Creation Date12/10/2008 9:17 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows3846227
Data Space Used613,192.00 KB
Index Space Used4,445,840.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key guidExternalGUID of the record.Binary16   
 guidInternalGUID of the record, reserved for internal use only. Binary16  
 intYearYear of the data.SmallInt2  
 tuidSchemePathIdentifier for the area scheme path.SmallInt2   
 intLevel

Geographic level for the record.

  • 0 = Region
  • 1 = Country
  • 2 = Area
  • 3 = Subarea
  • 4 = Postal
UnsignedTinyInt1  
 intSortIndexSort index, for internal use only.Integer4  
 intLevel0Region identifierUnsignedTinyInt1  
 intLevel1Country identifier.SmallInt2  
 strLevel2Area or CRESTA identifier.VarChar15  
 strLevel3Subarea identifier.VarChar15  
 strLevel4Postal code identifier.VarChar15  
 fltGeoLatLatitude coordinate.  Values will be positive for locations north of the equator and negative south of the equator.Single4
((0.0))
 
 fltGeoLongLongitude coordinate. Values will be negative for locations west of the prime meridian up to the international date line. They will be positive for locations east of the prime meridian.Single4
((0.0))
 
 strNameName of the area.VarChar60  
 strBriefNameBrief name of the area.VarChar10  
 guidExternalModelThe corresponding model GUID for the non-modeled postal code, if applicable.VarBinary16  
 strL1NameCountry name.VarChar60  
 strL2NameArea or CRESTA name.VarChar60  
 strL3NameSubarea name, if applicable.VarChar60  
 strL4NamePostal name, if applicable.VarChar60  
 strL1BriefNameBrief name for the US for the United States.VarChar60  
 strL2BriefNameBrief name for the area, such as U.S. state abbreviation.VarChar60  
 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

Integer4  
Objects that depend on TblAreaExternal
 Database ObjectObject TypeDescriptionDep Level
TblAreaDistribution_xref tableTblAreaDistribution_xrefTable

System reference table used by airsp_EA_PagingPrepare to retrieve the highest weighted areas. This value is used to assign values to areas that do not have a high enough weight.

1
TblSourceDefaultTarget_Xref tableTblSourceDefaultTarget_XrefTableSystem 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.1
TblSourceDefaultTargetWc_Xref tableTblSourceDefaultTargetWc_XrefTable

System reference table used by airsp_EA_PagingPrepare to retrieve the highest weighted regions for Workers' Compensation. This value is used to assign values to regions that do not have a high enough weight.

1
TblSourceTargetMap_ANZ tableTblSourceTargetMap_ANZTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Australia and New Zealand, as well as the weight for each of those locations.1
TblSourceTargetMap_BRA tableTblSourceTargetMap_BRATable

Maps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Brazil, as well as the weight for each of those locations.

1
TblSourceTargetMap_CAM tableTblSourceTargetMap_CAMTable

Maps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Central America, as well as the weight for each of those locations.

1
TblSourceTargetMap_CAN tableTblSourceTargetMap_CANTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Canada, as well as the weight for each of those locations.1
TblSourceTargetMap_CHI tableTblSourceTargetMap_CHITableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in China, as well as the weight for each of those locations.1
TblSourceTargetMap_EUR tableTblSourceTargetMap_EURTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Europe, as well as the weight for each of those locations.1
TblSourceTargetMap_IND tableTblSourceTargetMap_INDTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in India, as well as the weight for each of those locations.1
TblSourceTargetMap_JAP tableTblSourceTargetMap_JAPTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Japan, as well as the weight for each of those locations.1
TblSourceTargetMap_MEU tableTblSourceTargetMap_MEUTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated mid-European locations, as well as the weight for each of those locations.1
TblSourceTargetMap_MEX tableTblSourceTargetMap_MEXTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Mexico, as well as the weight for each of those locations.1
TblSourceTargetMap_SAM tableTblSourceTargetMap_SAMTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in South America, as well as the weight for each of those locations.1
TblSourceTargetMap_SEA tableTblSourceTargetMap_SEATableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Southeast Asia, as well as the weight for each of those locations.1
TblSourceTargetMap_SEU tableTblSourceTargetMap_SEUTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated southern-European locations, as well as the weight for each of those locations.1
TblSourceTargetMap_US tableTblSourceTargetMap_USTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in the United States, as well as the weight for each of those locations.1
TblSourceTargetMapWC_JAP tableTblSourceTargetMapWC_JAPTableUsed for Workers' Compensation. Maps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Japan, as well as the weight for each of those locations. 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.