tCLAUpgradeLog Table

Description

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.

Properties

Creation Date	4/4/2022 3:03 AM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	0
Data Space Used	0.00 KB
Index Space Used	0.00 KB

Columns

Column Name	Description	Datatype	Length	Formula
CLAUpgradeLogSID	Unique system-generated sequential identifier for the upgrade log associated with the company loss association file.	int	4
CLAUpgradeListSID	Unique system-generated sequential identifier for the list of updgraded CLA records.	int	4
CLADatabaseName	Name of the database for the CLA record.	sysname	128
CLATableName	Name of the table for the CLA record.	sysname	128
ModelCode	Code that represents the model in Touchstone Re associated with the CLA record.	int	4
Outcome	User-supplied description.	varchar	100
YearMax	Maximum number of simulated years in the catalog associated with the CLA record.	int	4
OldModelVersion	Version of the model associated with the legacy area and line of business combination.	varchar	20
NewModelVersion	Version of the model associated with the new area and line of business combination.	varchar	20
CurrencyCode	ISO 3-character code for the currency.	varchar	3
CLFAreaLobIndex	Identifier for the area and line of business associated with the CLF record. For a complete list of records, see tCLFUpgradeDetails table.	int	4
DistctMappingAreas	Code that represents the mapping areas.	int	4
ActualUpgradeRecords	Code that represents the count of CLA records ready for upgrade.	int	4
AreaCodeOldCountBefore	Code that represents the count of the legacy area before upgrade.	int	4
AreaCodeOldCountAfter	Code that represents the count of the new area after upgrade.	int	4
AreaCodeOldCountUpgraded	Code that represents the difference in number of areas before and after the upgrade.	int	4	([AreaCodeOldCountBefore]-[AreaCodeOldCountAfter])
AreaCodeNewCountBefore	Code that represents the count of new area before the upgrade.	int	4
AreaCodeNewCountAfter	Code that represents the count of new area after the upgrade.	int	4
AreaCodeNewCountDiff	Code that represents the difference in number of new areas before and after the upgrade.	int	4	([AreaCodeNewCountAfter]-[AreaCodeNewCountBefore])
StartDate	Date of initiation of the database upgrade associated with the CLA record.	datetime2	4
EndDate	Date of completion of the datebase upgrade associated with the CLA record.	datetime2	4
PhysicalTableName	System-generated name of the table associated with the CLA record.	sysname	128
DurationMinute	Duration of the database upgrade.	int	4	(datediff(minute,[StartDate],[EndDate]))

Related Objects

AIRCompanyLoss Database