Touchstone 4.0 Database Documentation
tRRRR_CMPLOSS_AnnualEPKey Table
Description
Stores annual exceedance probability losses to be used a Comparative Loss analysis. This table is created for each comparative Loss analysis. By default, for each year in the analysis that experienced loss, the table will contain at most one Aggregate row and one Occurrence row per financial perspective for the Standard EP curve. But if losses for a particular financial perspective in that year were 0, no row is generated. The table may contain additional rows if the user requests additional EP curves for subsets of the results.
Properties
Creation Date5/31/2016 9:45 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 AnnualEPRowIDSystem-assigned table row identifier for the annual EP. Integer4   
 EPAnnualTypeCode

Code that indicates whether the corresponding losses are based on all events that occurred during a year (aggregate) or on the single largest loss caused by all events in a year (occurrence).

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

VarChar10   
 EPCurveTypeCode

Code that indicates whether the losses are based on AIR’s default EP curve or on user-specified loss uncertainty percentiles.

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

VarChar10   
 FinancialPerspectiveCode

Code that represents the financial perspective used to display the losses.

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

VarChar10   
 EPTargetTypeCode

Code that represents the target of the analysis for which losses were produced.

For a complete list of codes, see tEPTargetType Table.

VarChar10   
 ExposureDataSourceSID

Unique system-generated sequential identifier for the exposure data source record in which the EPTargetSID can be found .

For a complete list of records, see tDataSource Table.

Integer4  
 EPTargetSID

Unique system-generated sequential identifier for the target  record for which the losses were aggregated

For example, if the EP target type is Contract, then this is the ContractSID.

Integer4  
Objects that depend on tRRRR_CMPLOSS_AnnualEPKey
 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_AnnualEPSummary tabletRRRR_TTTT_CMPLOSS_AnnualEPSummaryTable

Stores the deltas for the aggregate annual exceedance probability summary 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

AIRResult
Locating Results for a Specific Analysis

 

 


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.