Touchstone 4.0 Database Documentation
tRRRR_CMPLOSS_EventKey Table
Description

Stores information about the events used during the Comparative Loss analysis.    

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key EventRowIDSystem-assigned table row identifier for the event.BigInt8   
 CatalogTypeCode

Code that represents the catalog type.

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

VarChar10   
 ModelCode

Code that represents the model.

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

UnsignedTinyInt1   
 EventIDSystem-generated identifier for the event used during the comparative analysis.Integer4  
 YearIDUnique identifier that tracks the scenario. In multi-year catalogs, each scenario actually consists of five modeled years.Integer4  
 PerilSetCode

Numeric code for the single peril or set of perils.

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

Integer4   
Objects that depend on tRRRR_CMPLOSS_EventKey
 Database ObjectObject TypeDescriptionDep Level
tRRRR_TTTT_CMPLOSS_AnnualEP tabletRRRR_TTTT_CMPLOSS_AnnualEPTable

Stores the deltas for the aggregate annual exceedance probability losses that are calculated during a Comparative Loss analysis.

tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.
1
tRRRR_TTTT_CMPLOSS_ByEvent tabletRRRR_TTTT_CMPLOSS_ByEventTable

Stores the deltas for the aggregate event losses that are calculated during a Comparative Loss analysis.

tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.
1
See Also

Related Objects

AIRExposureSummary 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.