Touchstone 2022 Database Reference
tDataChangeTracking Table
AIRProject Database : tDataChangeTracking Table
Description
Stores all the RowVersion information needed to determine if any of the data associated with a particular Touchstone activity has changed since the activity completed.
Properties
Creation Date4/4/2022 3:02 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 RowNumberUnique integer identifier for the row.int4   
 TargetTypeType of activity on which the RowVersion information is based.varchar10   
 RootSID

Unique system-generated sequential identifier for the primary table of the Target Type.

int4   
 DataSourceSID

Unique system-generated sequential identifier for the data source record.

For a complete list of records, see tDataSource Table.

int4  
 ExposureSetSID

Unique system-generated sequential identifier for the exposure set record.

For a complete list of records, see tExposureSet Table.

int4  
 TableNameTable from which MaxRowVersion and SumRowVersion was extracted.varchar128  
 MaxRowVersionMaximum RowVersion for all records in the [TableName] related to the TargetType and RootSID.bigint8  
 SumRowVersionSum of RowVersion for all records in the [TableName] related to the TargetType and RootSID.bigint8  
See Also

Related Objects

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