Touchstone Re 2022 Database Reference
tCLEXPORT_NNNN_AAAA Table
AIRCompanyLoss Database : tCLEXPORT_NNNN_AAAA Table
Description

Stores the losses from a company loss file (CLF) set that a user exported from Touchstone to Touchstone Re.

Touchstone may create several tables for each export job, for example:

  • tCLEXPORT_NNNN_AAAA
  • tCLEXPORT_MAOL_NNNN_AAAA
  • tCLEXPORT_TREATY_TTTT_NNNN_AAAA

The first table stores losses for various financial perspectives, for example, ground-up and gross losses. The second table stores Maximum Any One Life (MAOL) losses. The remaining tables store ground-up losses by treaty.

NNNN represents the acitivity SID (sequential identifier). You can use the activity SID to view the log for the export job in the Touchstone Activity Monitor.

AAAA represents the analysis SID. You can use the analysis SID to view the analysis options associated with the exported data in tCLEXPORT_LossAnalysisOption Table.

TTTT represents the treaty name.

Properties
Creation Date4/4/2022 3:03 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
 

Identifier for the year in the catalog that generated the losses.

Rows with the same YearID represent different event occurrences in the same year.

int4   
 

Code that represents the AIR model associated with the losses.

For a complete list of codes, see tModel Table.

int4   
 

Code that represents the type of catalog that generated the losses, for example, stochastic.

For a complete list of codes, see tCatalogType Table.

varchar10   
 For internal use only.varbinary28  
 Loss for the gross financial perspective.varbinary160  
 Loss for the ground-up financial perspective.varbinary160  
 Loss for the net of pre-catastrophe financial perspective.varbinary160  
 Loss for the post-catastrophe net financial perspective.varbinary160  
 Loss for the total CAT reinsurance recovery financial perspective.varbinary160  
 Loss for the total reinsurance recovery financial perspective.varbinary160  
 Loss for the total risk reinsurance recovery financial perspective.varbinary160  
See Also

Related Objects

AIRCompanyLoss Database