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

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.

 

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
 CLAUpgradeLogSIDUnique system-generated sequential identifier for the CLA upgrade log,int4  
 CLAUpgradeListSIDUnique system-generated sequential identifier for the list of upgraded CLA records.int4  
 SliceIDIdentifier for the slice operation.int4  
 StartDateDate and time when the upgrade was initiated. datetime24  
 EndDateDate and time when the upgrade was completed.datetime24  
 ActualUpgradeRecordsCode that represents the number of upgraded records.int4  
 DurationMinuteDuration of upgrade.int4 
(datediff(minute,[StartDate],[EndDate]))
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.