Touchstone 4.0 Database Documentation
What's New?
What's New in Touchstone 4.0.0

The following database changes have been introduced in Touchstone 4.0.0, including:

New Tables

AIR has added the following database tables for Touchstone 4.0.0.

Table Details

[AIRExposureSummary].[dbo].[tRRRR_LOSS_AnnualEP_ByModel]

Stores annual exceedance probability losses by model.

[AIRExposureSummary].[dbo].[tRRRR_LOSS_AnnualEP_ByPeril]

Stores annual exceedance probability losses by peril.

[AIRExposureSummary].[dbo].[tRRRR_LOSS_AnnualEPSummary_ByPerilModel]

Stores annual exceedance probability summary losses for both peril and model.

[AIRExposureSummary].[dbo].[tRRRR_LOSS_ByGeoPerilAAL]

Stores average annual losses, at the peril- and geography-level, from a detailed Loss analysis. This table is created when the user selects "Save Loss By Peril" and also selects a geographic area from the "Geography" drop-down box in the analysis Output Options.

[AIRProject].[dbo].[tShrinkQueue]

Reserved for internal use.  Stores records that were shrunk using functionality built into SQL Server.

[AIRExposureSummary].[dbo].[tRRRR_LOSS_ByLocationPerilAAL]

Stores average annual losses, at the peril- and location-level, from a detailed Loss analysis. This table is created when the user specifies both "Save Loss By Peril" and "Save Loss By Location" in the analysis Output Options.

[AIRReference].[dbo].[tCascadeDeleteOption]

Stores data types that are removed for each delete option.

[AIRReference].[dbo].[tComponent]

Stores custom models that are integrated into Touchstone.

[AIRReference].[dbo].[tDateFormat]

Stores date formats that can be used in .csv export files.

[AIRReference].[dbo].[tExposureTargetType]

Stores the possible exposure types that are valid for import.  These codes are used for import validation error messaging.

[AIRReference].[dbo].[tValidationError]

Stores import validation error codes, validation rules, and error messages. When a validation error occurs, the error is written to the import log file using the following format: ERROR CODE | Contract ID: XXX Location ID XXX | Summary Message..

[AIRResult].[dbo].[tRRRR_LOSS_AnnualEP_ByModel]

Stores annual exceedance probability losses by model.

[AIRResult].[dbo].[tRRRR_LOSS_AnnualEP_ByPeril]

Stores annual exceedance probability losses by peril.

[AIRResult].[dbo].[tRRRR_LOSS_AnnualEPSummary_ByPerilModel]

Stores annual exceedance probability summary losses for both peril and model.

[AIRResult].[dbo].[tRRRR_LOSS_ByGeoPerilAAL]

Stores average annual losses, at the peril- and geography-level, from a detailed Loss analysis. This table is created when the user selects "Save Loss By Peril" and also selects a geographic area from the "Geography" drop-down box in the analysis Output Options.

[AIRResult].[dbo].[tRRRR_LOSS_ByLocationPerilAAL]

Stores average annual losses, by peril and location-level, from a detailed Loss analysis. This table is created when the user specifies both "Save Loss By Peril" and "Save Loss By Location" in the analysis Output Options.

Modified Tables

AIR has made modifications to the following database tables for Touchstone 4.0.0.

 

Table Details

AIRDQIndustry

No change to database documentation.  

Database content has been updated to reflect the updated industry data.

[AIRExposureSummary].[dbo].[tLossAnalysisOption]

Added columns: ComponentCode, SaveSummaryByPeril, and SaveSummaryByModel.

[AIRExposureSummary].[dbo].[tRRRR_EC_ByAccumulator]

Added columns: Employees, DayShiftEmployees, EveningShiftEmployees, and NightShiftEmployees.

[AIRExposureSummary].[dbo].[tRRRR_EC_ByContract]

Added columns: Employees, DayShiftEmployees, EveningShiftEmployees, and NightShiftEmployees.

[AIRExposureSummary].[dbo].[tRRRR_EC_ByLayer]

Added columns: Employees, DayShiftEmployees, EveningShiftEmployees, and NightShiftEmployees.

[AIRExposureSummary].[dbo].[tRRRR_EC_ByLocation]

Added columns: Employees, DayShiftEmployees, EveningShiftEmployees, and NightShiftEmployees.

[AIRExposureSummary].[dbo].[tRRRR_EC_DimLocation]

Added columns: Employees, DayShiftEmployees, EveningShiftEmployees, and NightShiftEmployees.

[AIRExposureSummary].[dbo].[tRRRR_HAZ_Detail]

Added columns: SSStormSurgeZoneCode, SSShortestDistanceto100YearStormSurge, SSShortestDistanceto250YearStormSurge, SSShortestDistanceto500YearStormSurge, SSDepthFor100YearStormSurge, SSDepthFor250YearStormSurge, and SSDepthFor500YearStormSurge.

[AIRExposureSummary].[dbo].[tRRRR_HAZ_Intensity]

Added column:  ModelCode.

[AIRExposureSummary].[dbo].[tRRRR_LOSS_DimEvent]

Added columns: CountryCode, CRESTACode, and SubAreaCode.

[AIRExposureSummary].[dbo].[tRRRR_LOSS_DimLocation]

Added column: ExposureCurrencyCode.

AIRGeography

No change to database documentation.  

Database content has been updated to reflect the current geographic information.

AIRIndustry

No change to database documentation.  

Database content has been updated to reflect the updated industry data.

[AIRProject].[dbo].[tActivity]

Added column: ModifiedDate.

[AIRProject].[dbo].[tExposureConcentrationAnalysisOption]

Added column: IsWorkersComSelected.

[AIRProject].[dbo].[tLossAnalysisOption]

Added columns: ComponentCode, SaveSummaryByPeril, and SaveSummaryByModel.

[AIRReference].[dbo].[tAIRConstOccRegionConstXref]

Added the following AIR construction codes to region code SEA (southeast Asia):

  • 102
  • 103
  • 104
  • 115
  • 117
  • 118
  • 119
  • 134
  • 135
  • 136
  • 154
  • 155
  • 204
  • 205
  • 206
  • 211
  • 212
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 260
  • 262
  • 263
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 700
  • 2010
  • 2011
  • 2012
  • 2013
  • 2015
  • 2016
  • 2021
  • 2022
  • 2031
  • 2131
  • 2132
  • 2141
  • 2142
  • 2150
  • 2151
  • 2152
  • 2210
  • 2211
  • 2221
  • 2231
  • 2232
  • 2233
  • 2241
  • 2242
  • 2243
  • 2251
  • 2252
  • 2253
  • 2261
  • 2262
  • 2263
  • 2270
  • 2271
  • 2272
  • 2273
  • 2274
  • 2275
  • 2276
  • 2281
  • 2282
  • 2283
  • 2284
  • 2285
  • 2286

[AIRReference].[dbo].[tAIRConstOccRegionCountryXref]

Added the following country codes to region code SEA (southeast Asia):

  • BN = Brunei
  • GU = Guam
  • MO = Macau
  • MP = Saipan
  • MY = Malaysia
  • SG = Singapore
  • TH = Thailand
  • VN = Vietnam

[AIRReference].[dbo].[tAIRConstOccRegionOccXref]

Added the following AIR occupancy codes to region code SEA (southeast Asia):

  • 366
  • 374
  • 400
  • 401
  • 402
  • 403
  • 404
  • 405
  • 406
  • 407
  • 408
  • 409
  • 414
  • 415
  • 416
  • 417
  • 418
  • 419
  • 420
  • 421
  • 422
  • 423
  • 424
  • 425
  • 429
  • 430
  • 431
  • 432
  • 433
  • 434
  • 438
  • 439
  • 440
  • 441
  • 442
  • 443
  • 444
  • 445
  • 446
  • 449
  • 450
  • 451
  • 452
  • 455
  • 456
  • 457
  • 458
  • 459
  • 460
  • 463
  • 464
  • 465
  • 470
  • 471
  • 472
  • 473
  • 474
  • 475
  • 476
  • 477
  • 479
  • 480
  • 481
  • 482

[AIRReference].[dbo].[tAIRConstruction]

Added codes:

  • 262: 4 Wheeler
  • 263: 2 Wheeler
  • 700: Uninsurable construction, used only in Research model code (internal use only)

For code 800, modified the AIRConstruction and Description fields to "Offshore: Unknown".

[AIRReference].[dbo].[tAIROccupancy]

Added code:

  • 366: Warehouse

For code 900, modified the AIROccupancy and Description fields to Offshore: Unknown.

[AIRReference].[dbo].[tAIROccupancyWeightTypeXref]

Added the following AIR occupancy code to weight type code 2 (commercial):

  • 366

[AIRReference].[dbo].[tCLFIndustryLOB]

Added the following table rows:

  • 1162 - 1185: new for country code GU (Guam)
  • 1187-1189, 1192, 1194, 1197, 1199, 1201, 1204-1207, 1213, 1215, 1217-1220, 1224-1227, 1229, 1233-1241: new for country code HK (Hong Kong)
  • 1301-1315: new for country code ID (Indonesia)
  • 1776-1815: new for country code MO (Macau)
  • 1816-1839: new for country code MP (Saipan)
  • 2082-2085, 2088, 2090, 2091, 2094, 2096, 2098, 2099, 2102-2105, 2107, 2112, 2114-2120, 2125-2128, 2133-2144: new for country code PH (Philippines)
  • 2333-2356: new for country code SG (Singapore)
  • 2551-2554, 2557, 2559, 2560, 2563, 2565, 2567, 2568, 2571-2574, 2576, 2581, 2583-2589, 2594-2597, 2602-2613: new for country code TW (Taiwan)
  • 2784-2823: new for country code VN (Vietnam)

The following table identifies the modified values, by table row.

Table Row CTPerilSetCode INFVersion IndustryLineofBusinessCode IndustryLOBOrder
1022 Was 4, now 10
1026 Was 4, now 10
1186 Was 3, now 5 Was 5, now 1
1190 Was 3, now 5 Was 6, now 22 Was 2, now 3
1191 Was 3, now 5 Was 8, now 23
1193 Was -1, now 1 Was 3, now 5 Was 13, now 1 Was 3, now 1
1195 Was 5, now 11 Was 1, now 2
1196 Was 6, now 17 Was 2, now 6
1198 Was 8, now 23
1200 Was 1, now 2 Was 13, now 1 Was 3, now 1
1202 was 5, now 11 Was 1, now 2
1203 Was 6, now 17 Was 2, now 6
1208 Was 2, now 3 Was 8, now 4 Was 4, now 8
1209 Was 2, now 3 Was 13, now 11 Was 3, now 2
1210 Was 5, now 17 Was 1, now 6
1211 Was 6, now 22 Was 2, now 3
1212 Was 8, now 23
1214 Was 3, now 4 Was 13, now 1 Was 3, now 1
1216 Was 256, now 4 Was 5, now 11 Was 1, now 2
1221 Was 6, now 1 Was 2, now 1
1222 Was 8, now 4 Was 4, now 8
1223 Was 13, now 11 Was 3, now 2
1228 was 5, now 1
1230 Was 6,now 11
1231 Was 8, now 17 Was 4, now 6
1232 Was 13, now 22
1297 was 5, now 1
1298 Was 6, now 11
1299 Was 8, now 22 Was 4, now 3
1230 Was 13, now 23 Was 3, now 4
2081 Was 3, now 5 Was 5, now 1
2086 Was 3, now 5 Was 6, now 22 Was 2, now 3
2087 Was 3, now 5 Was 8, now 23
2089 Was -1, now 1 Was 3, now 5 Was 13, now 1 Was 3, now 1
2092 Was 5, now 11 Was 1, now 2
2093 Was 6, now 17 Was 2, now 6
2095 Was 8, now 23
2097 Was 1, now 2 Was 13, now 1 Was 3, now 1
2100 Was 5, now 11 Was 1, now 2
2101 Was 6, now 17 Was 2, now 6
2106 Was 2, now 3 Was 8, now 4 Was 4, now 8
2108 Was 2, now 3 Was 13, now 11 Was 3, now 2
2109 Was 5, now 17 Was 1, now 6
2110 Was 6, now 22 Was 2, now 3
2111 Was 8, now 23
2113 Was 3, now 4 Was 13, now 1 Was 3, now 1
2121 Was 5, now 1
2122 Was 6, now 4 Was 2, now 8
2123 Was 4, now 7
2124 Was 13, now 11 Was 3, now 2
2129 Was 5, now 1
2130 Was 6, now 4 Was 2, now 8
2131 Was 4, now 7
2132 Was 13, now 11 Was 3, now 2
2550 Was 3, now 5 Was 5, now 1
2555 Was 3, now 5 Was 6, now 22 Was 2, now 3
2556 Was 3, now 5 Was 8, now 23
2558 Was -1, now 1 Was 3, now 5 Was 13, now 1 Was 3, now 1
2561 Was 5, now 11 Was 1, now 2
2562 Was 6, now 17 Was 2, now 6
2564 Was 8, now 23
2566 Was 1, now 2 Was 13, now 1 Was 3, now 1
2569 Was 5, now 11 Was 1, now 2
2570 Was 6, now 17 Was 2, now 6
2575 Was 2, now 3 Was 8, now 4 Was 4, now 8
2577 Was 2, now 3 Was 13, now 11 Was 3, now 2
2578 Was 5, now 17 Was 1, now 6
2579 Was 6, now 22 Was 2, now 3
2580 Was 8, now 23
2582 Was 3, now 4 Was 13, now 1 Was 3, now 1
2590 Was 5, now 1
2591 Was 6, now 4 Was 2, now 8
2592 Was 4, now 7
2593 Was 13, now 11 Was 3, now 2
2598 Was 5, now 1
2599 Was 6, now 4 Was 2, now 8
2600 Was 4, now 7
2601 Was 13, now 11 Was 3, now 2
                       

[AIRReference].[dbo],[tCLFINFVersion]

Added the following table rows:

  • 17: new for catalog type code HIST (historical events)
  • 37, 38, 40, 42, 43, 44: new for  catalog type code RDS (Lloyd's realistic disaster scenario)
  • 68: new for catalog type code STC (stochastic)

The following table identifies the modified values, by table row.

Table Row INFVersion IndustryLOBCount
15 Was 3, now 5 Was 4, now 8
18 Was 5, now 8
39 Was 5, now 8
66 Was 3, now 5 Was 4, now 8
69 Was 5, now 8

[AIRReference].[dbo].[tCountry]

Modified data as follows:

  • MP - Northern Mariana Islands renamed to Saipan and is now modeled
  • BN - Brunei Darussalam was changed to Brunei and is now modeled
  • GU - Guam is now modeled
  • MO - Macau is now modeled
  • MY - Malaysia  is now modeled
  • SG - Singapore is now modeled
  • TH - Thailand is now modeled
  • VN - Vietnam is now modeled
[AIRReference].[dbo].[tCountryCurrencyXref] Updated the table description to indicate that the table is reserved for internal use by Touchstone and is used for mapping currency to a county when exporting CLF and UNICEDE/2 files for CATRADER .

[AIRReference].[dbo][tConvertEDCCountry]

The following table identifies the modified values, by table row.

Table Row CountryCode IsModeled
241 EC Was True, now False
242 EC Was True, now False
243 EC Was True, now False
244 EC Was True, now False

[AIRReference].[dbo].[tCountryCurrencyXref]

Added currency codes for the following country codes:

  • BN - currency code USD
  • EE - currency code EEK
  • GU - currency code USD
  • MO - currency code MOP
  • MP - currency code USD

[AIRReference].[dbo].[tCountryIndustryLOBXref]

Added industry line of business codes for the following country codes:

  • GB - added LOB codes 4, 5
  • GU - added LOB codes 1, 4, 11, 17, 22, 23, 24
  • HK - added LOB code 1, 4, 17, 22, 23, 24
  • ID - added LOB code 1, 4, 17, 22, 23, 24
  • MO - added LOB code 1, 4, 8, 11, 17, 22, 23, 24
  • MP - added LOB code 1, 4,11, 17, 22, 23, 24
  • PH - added LOB code 1, 4, 11, 17, 22, 23, 24
  • SG - added LOB code 1, 4, 8, 11, 17, 22, 23, 24
  • TW -added  LOB code 1, 4. 11, 17, 22, 23, 24
  • VN - added LOB code 1, 4, 8, 11, 17, 22, 23, 24

Removed industry line of business codes for the following country codes:

  • HK - removed LOB codes 8, 13
  • ID - removed LOB code 13
  • PH - removed LOB code 13
  • TW - removed LOB code 13

[AIRReference].[dbo].[tCountryPerilXref]

Added peril set codes for the following country codes:

  • AU - 32 (terrorism)
  • BE - 32 (terrorism)
  • BN - 4 (earthquake shake), 8192 (tsunami)
  • BR - 32 (terrorism)
  • CA - 32 (terrorism)
  • CN - 32 (terrorism)
  • CO - 32 (terrorism)
  • DE - 32 (terrorism)
  • ES - 32 (terrorism)
  • FR - 32 (terrorism)
  • GB - 32 (terrorism)
  • GR - 32 (terrorism)
  • GU - 1 (wind), 4096 (precipitation flood)
  • HK - 4 (earthquake shake), 256 (storm surge), 4096 (precipitation flood), 8192 (tsunami)
  • ID - 1 (wind), 32 (terrorism), 4096 (precipitation flood), 8192 (tsunami)
  • IE - 32 (terrorism)
  • IL - 32 (terrorism)
  • IN - 4 (earthquake shake), 32 (terrorism)
  • IT - 32 (terrorism)
  • JP - 32 (terrorism)
  • KE - 32 (terrorism)
  • LB - 32 (terrorism)
  • MO - 1 (wind), 4 (earthquake shake), 4096 (precipitation flood), 8192 (tsunami)
  • MP - 1 (wind), 4096 (precipitation flood)
  • MX - 32 (terrorism)
  • MY - 4 (earthquake shake), 8192 (tsunami)
  • SG - 4 (earthquake shake)
  • NL - 32 (terrorism)
  • PH - 32 (terrorism), 256 (storm surge), 4096 (precipitation flood), 8192 (tsunami)
  • RU - 32 (terrorism)
  • SG - 32 (terrorism), 8192 (tsunami)
  • TH - 4 (earthquake shake), 32 (terrorism), 8192 (tsunami)
  • TR - 32 (terrorism)
  • TW - 256 (storm surge), 4096 (precipitation flood), 8192 (tsunami)
  • VN - 1 (wind), 4 (earthquake shake), 4096 (precipitation flood), 8192 (tsunami)
  • ZA - 32 (terrorism)

[AIRReference].[dbo].[tDemandSurgeRegion]

Added codes:

  • 20 = Saipan
  • 21 = Guam
  • 22 = Macau
  • 23 = Thailand
  • 24 = Malaysia
  • 25 = Vietnam
  • 26 = Brunei
  • 27 = Singapore

The following table identifies the modified values.

DemandSurgeRegionCode DemandSurgeRegion Models AsOfDate
1 Australia Was 2012-02-09, now 2015-10-07
17 Hong Kong Added 54
19 India Added 58 Was 2012-02-09, now 2016-01-11
                       

[AIRReference].[dbo].[tEventFilterTerrorismWeaponType]

Removed code 16 = Small Boat.

The following table identifies the modified values.

TerrorismWeaponTypeCode TerrorismWeaponCategory
17 Updated to Small Plane Crash
18 Updated to Large Plane Crash
                       

[AIRReference].[dbo].[tExecutionPlan]

Added ExecutionPlanSID 17.  Modified the execution plan for ExecutionPlanSIDs 0, 1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 169. 

[AIRReference].[dbo].[tFinancialPerspective]

Added  codes:

  • EMP = Employees
  • EMPD = DayShiftEmployees
  • EMPE = EveningShiftEmployees
  • EMPN = NightShiftEmployees

[AIRReference].[dbo].[tGeoMatchLevel]

Added code:

  • AREA = Area Centroid

[AIRReference].[dbo].[tHazardAttribute]

The following table identifies the modified values.

HazardAttributeCode HazardAttribute HazardFieldName
220 Was SS Flood Zone Category, now SS Storm Surge Category Was SSFloodZoneCode, now SSStormSurgeZoneCode
221 Was Shortest Distance to 100-year SSFlood Plain, now Shortest Distance to 100-year SS Storm Surge Was SSShortestDistanceTo100YearFloodPlain, now SSShortestDistanceTo100YearStormSurge
222 Was Shortest Distance to 250-year SS Flood Plain, now Shortest Distance to 250-year SS Storm Surge Was SSShortestDistanceTo250YearFloodPlain, now SSShortestDistanceTo250YearStormSurge
223 Was Shortest Distance to 500-year SS Flood Plain, now Shortest Distance to 500-year SS Storm Surge Was SSShortestDistanceTo500YearFloodPlain, now SSShortestDistanceTo500YearStormSurge
224 Was Depth For 100 Year Flood Plain, now Depth For 100 Year Storm Surge Was SSDepthFor100YearFloodPlain, now SSDepthFor100YearStormSurge
225 Was Depth For 250Year Flood Plain, now Depth For 250Year Storm Surge Was SSDepthFor250YearFloodPlain, now SSDepthFor250YearStormSurge
226 Was Depth For 500 Year Flood Plain, now Depth For 500 Year Storm Surge Was SSDepthFor500YearFloodPlain, now SSDepthFor500YearStormSurge
[AIRReference].[dbo],[tIndustryLineofBusiness]

Added codes:

  • 23 = Commercial & Industrial Buildings
  • 24 = Commercial & Industrial Contents

[AIRReference].[dbo].[tLandmarkType]

Added codes:

  • 24 = Post Office
  • 25 = School

[AIRReference].[dbo].[tModel]

Added table column "BriefName" and corresponding values.  See tModel for list of brief names.

Changed the name of ModelCode 01, from AIR Terrorism Loss Estimation Model to AIR Terrorism Model 

[AIRReference].[dbo].[tModelCountryXref]

Added country codes that are associated with the following model codes:

  • 54 - added country codes BN, HK, MO, MY, SG, TH, VN
  • 58 - added country code IN
  • 60 - Added country codes, GU, MO, MP, VN
[AIRReference].[dbo].[tModelCTGeoLevelMapping]

Added new area level mapping for the following model codes.

ModelCode AreaLevel1 Level1Mapping Level2Mapping Level3Mapping
54 51 1 3 0
54 52 1 3 0
54 80 1 3 0
54 132 1 3 0
54 135 1 3 0
54 194 1 3 0
54 207 1 3 0
58 113 0 1 0
60 105 1 3 0
60 132 1 3 0
60 161 1 3 0
60 194 1 3 0
64 105 1 3 0
64 132 1 3 0
64 161 1 3 0
64 194 1 3 0
                                               

Modified the area level mapping for the following model code

ModelCode Level1Mapping
68 Was 3, now 0

[AIRReference].[dbo].[tOutputTable]

Added table SIDs:

  • 52 - LOSS_AnnualEP_ByPeril
  • 53- LOSS_AnnualEP_ByModel
  • 54 - LOSS_AnnualEPSummary_ByPerilModel

[AIRReference].[dbo].[tOutputTableType]

Added codes:

  • MP = Model AnnualEP
  • PP = Peril AnnualEP
  • PS = Peril Model Summary

[AIRReference].[dbo].[tOutputTypeTableXref]

Added associations for output table SIDs 52, 53, and 54 to output types CON, CONGEOL, EA, EAGEOL,  GEOL, LOC, LYR, LYRGEOL, PORT.

[AIRReference].[dbo].[tRiskMeasure]

Added code:

  • EMP = Employees

[AIRReference].[dbo].[tSpatialAnalysisField]

Added table columns IsWorkersComp and IsProperty (true/false flags) and modified table rows accordingly.

Added new LocMeasure rows for DayShift, EveningShift, NightShift, and Total employees.

[AIRReference].[dbo].[tSpatialDataSetType]

Removed code:

  • LOSS = Loss

Added code:

  • HZRDBOUN = Hazard Boundary                   

[AIRReference].[dbo].[tTerrorismOption]

Removed codes:

  • CBBVE = Bacteria and Virus Exclusion
  • CBPE = Pollution Exclusion

Added codes:

  • CBBVEP = Bacteria and Virus Exclusion, Property
  • CBBVEWC = Bacteria and Virus Exclusion, Workers Compensation
  • CBPEP = Pollution Exclusion, Property
  • CBPEWC = Pollution Exclusion, Workers Compensation

[AIRReference].[dbo].[tUNICEDE2CountryAreaTagXref]

Added area-level associations for the new country codes.

AreaTagCode OldAreaLevel1 CountryCode AreaTagFormat StepLevel
10 135 MY intentionally blank 10
10 194 VN intentionally blank 7
10 207 TH intentionally blank 10
27 51 SG intentionally blank 10
27 105 GU intentionally blank 10
27 132 MO intentionally blank 10
27 161 MP intentionally blank 10

[AIRReference].[dbo].[tUNICEDE2CountryLOBXref]

Added country codes to the following UNICEDE2 line of business codes.

  • 6 - added country codes  GU, HK, ID, MO, MP, PH, SG, TW, VN
  • 16 - added country codes GU, MO, MP, SG, TW, VN
  • 19, 69, 70 - added country codes GU, HK, ID, MO, MP, PH, SG, TW, VN
  • 82, 86 - added country codes GU, HK, ID, MO, MP, PH, SG, TW, VN

Removed country codes from the following UNICEDE2 line of business codes.  

  • 75 - removed country codes HK, ID, PH, TW
[AIRReference].[dbo].[tUNICEDE2LineofBusiness]

Codes renamed.

  • 69 = Was Commercial Building, now Commercial & Industrial Buildings
  • 70 = Was Commercial Contents, now Commercial & Industrial Contents

[AIRResult].[dbo].[tLossAnalysisOption]

Added columns: ComponentCode, SaveSummaryByPeril, and SaveSummaryByModel.

[AIRResult].[dbo].[tRRRR_EC_ByAccumulator]

Added columns: Employees, DayShiftEmployees, EveningShiftEmployees, and NightShiftEmployees.

[AIRResult].[dbo].[tRRRR_EC_ByContract]

Added columns: Employees, DayShiftEmployees, EveningShiftEmployees, and NightShiftEmployees.

[AIRResult].[dbo].[tRRRR_EC_ByLayer]

Added columns: Employees, DayShiftEmployees, EveningShiftEmployees, and NightShiftEmployees.

[AIRResult].[dbo].[tRRRR_EC_ByLocation]

Added columns: Employees, DayShiftEmployees, EveningShiftEmployees, and NightShiftEmployees.

[AIRResult].[dbo].[tRRRR_EC_DimLocation]

Added columns: Employees, DayShiftEmployees, EveningShiftEmployees, and NightShiftEmployees.

[AIRResult].[dbo].[tRRRR_HAZ_Detail]

Added columns: SSStormSurgeZoneCode, SSShortestDistanceto100YearStormSurge, SSShortestDistanceto250YearStormSurge, SSShortestDistanceto500YearStormSurge, SSDepthFor100YearStormSurge, SSDepthFor250YearStormSurge, and SSDepthFor500YearStormSurge.

[AIRResult].[dbo].[tRRRR_HAZ_Intensity]

Added column:  ModelCode.

[AIRResult].[dbo].[tRRRR_LOSS_DimEvent]

Added columns: CountryCode, CRESTACode, and SubAreaCode.

[AIRResult].[dbo].[tRRRR_LOSS_DimLocation]

Added column: ExposureCurrencyCode.

[AIRUserSetting].[dbo].[tCatalogDetail]

Added columns: CountryCode, CRESTACode, SubAreaCode.

 

 


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.