Touchstone Re 2022 Database Reference
tMultiYearMap Table
AIRIndustry Database : tMultiYearMap Table
Description

Reserved for future use.

Stores information that Touchstone Re uses to create multi-year iterations from each set of 10,000 simulations in each model event catalog.

For each model, the table stores the mappings between years in the catalog and years in the multi-year iteration. Each Yearx column identifies one out of 10,000 simulated years.

Properties
Creation Date7/7/2017 11:57 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows430000
Data Space Used13,624.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
 

Code that represents the catastrophe model associated with the year data.

For a complete list of codes, see dbo.tModel Table.

smallint2   
 Year in the stochastic catalog that the application uses as the first year in a multi-year iteration.smallint2   
 Year in the stochastic catalog that the application uses as the second year in a multi-year iteration.smallint2   
 Year in the stochastic catalog that the application uses as the third year in a multi-year iteration.smallint2   
 Year in the stochastic catalog that the application uses as the fourth year in a multi-year iteration.smallint2   
 Year in the stochastic catalog that the application uses as the fifth year in a multi-year iteration.smallint2   
 Year in the stochastic catalog that the application uses as the sixth year in a multi-year iteration.smallint2   
 Year in the stochastic catalog that the application uses as the seventh year in a multi-year iteration.smallint2   
 Year in the stochastic catalog that the application uses as the eighth year in a multi-year iteration.smallint2   
 Year in the stochastic catalog that the application uses as the ninth year in a multi-year iteration.smallint2   
 Year in the stochastic catalog that the application uses as the tenth year in a multi-year iteration.smallint2   
See Also

Related Objects

AIRIndustry Database