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

Temporarily stores metadata that Touchstone uses to generate company loss files (CLFs). Touchstone creates the table prior to generating the CLFs. The metadata comes from the corresponding tCLEXPORT_NNNN_AAAA, tCLEXPORT_MAOL_NNNN_AAAA, and tCLEXPORT_TREATY_TTTT_NNNN_AAAA tables, where:

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

For example, for each batch of 100,000 loss records, the table specifies the number of events, year range, model code, and catalog type of the associated loss records in the corresponding tCLEXPORT_NNNN_AAAA instance.

After Touchstone generates the CLFs, the application deletes the table.

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
Primary Key BatchIDIdentifier for a batch of loss data included in the CLF set.int4   
Primary Key StartYearIDIdentifier for the first catalog year associated with the batch of loss data.int4   
 EndYearIDIdentifier for the last catalog year associated with the batch of loss data.int4  
 TotalCntNumber of catalog events associated with the batch of loss data.bigint8  
Primary Key ModelCode

Code that represents the AIR model associated with the losses.

For a complete list of codes, see tModel Table.

smallint2   
Primary Key CatalogTypeCode

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

For a complete list of codes, see tCatalogType Table.

varchar10   
Primary Key OptionType

Specifies the type of the losses.

  • LossBy = Losses by financial perspective
  • MAOL = Maximum Any One Life (MAOL) losses
  • Treaty = Losses by treaty
varchar50   
Primary Key ReInsuranceSID

Unique system-generated sequential identifier for a Touchstone reinsurance treaty associated with the batch of loss data.

int4   
 TreatyName

Name of the reinsurance treaty identified by the ReinsuranceSID.

varchar100  
See Also

Related Objects

AIRCompanyLoss Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.