tModelCountryXref Table

Description

System reference table used to determine the countries that are covered by the model.

Properties

Creation Date	7/5/2012 3:19 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	404
Data Space Used	8.00 KB
Index Space Used	24.00 KB

Columns

Column Name	Description	Datatype	Length	Default
ModelCode	Code that represents the model in Touchstone. If you have a valid Touchstone licensing contract, go to the Touchstone Database Reference in Developer Zone to check out the tModel Table for a complete list of model codes.	smallint	2
CountryCode	ISO 2-character code for the country associated with the model. For a complete list of codes, see tCountry Table.	varchar	15
IsPreviousVersionModel	Indicates whether the model version corresponds to the current or previous version of the AIR models. 1 = Yes (previous version) 0 = No (current version) Not used by Touchstone Re.	bit	1	((0))

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

ModelCode

Code that represents the model in Touchstone.

If you have a valid Touchstone licensing contract, go to the Touchstone Database Reference in Developer Zone to check out the tModel Table for a complete list of model codes.

smallint

CountryCode

ISO 2-character code for the country associated with the model.

For a complete list of codes, see tCountry Table.

varchar

IsPreviousVersionModel

Indicates whether the model version corresponds to the current or previous version of the AIR models.

1 = Yes (previous version)
0 = No (current version)

Not used by Touchstone Re.

bit

((0))

Related Objects

AIRReference Database

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