Stores information about database upgrades associated with the company loss association (CLA) records.

The Touchstone Re company upgrade process will now support both legacy and the latest geographies and its corresponding line of business for each company loss file (CLF). The UI update is in conjuction with Model 27 update for Carribean countries where a peril could span across multiple countries. For example, a peril could start from the Florida coastline and then traverse across various Caribbean countries.

The tCLAUpgradeLog table stores old and new area information for each CLF record. Enabling you to track the legacy and new geographies as well as the line of businesses before and after the database upgrade for the company loss files.

Stores information about each upgrade activity, including the unique sequential identifiers and duration of upgrade for CLA records.

When CLA upgrade runs in parallel, Touchstone Re generates the tCLAUpgradeLogTiming table to record the performance of the upgrade. The Touchstone Re Company Import upgrade enables you to copy specific CLF for a selected company or automatically copy all the CLFs available in the source folder. Touchstone Re generates the CLAUpgradeLogTiming table to monitor the performance of CLA upgrade process. You can use the information in the table to analyze the duration and results of upgraded records.

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.

Stores metadata about company loss files (CLF) that users exported from Touchstone to Touchstone Re.

The metadata includes information about the event catalogs associated with each CLF.

Stores relationships between company loss file (CLF) sets and companies for CLF sets exported from Touchstone to Touchstone Re.

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.

Contains a list of all SID tables and the last SID value in use for each table.  After each insert operation, the SID value will update.