Touchstone 4.0 Database Documentation
tActivityType Table
Description
Defines the type of activity.
Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows46
Data Space Used8.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ActivityTypeCode

Code that represents the activity type.

  • ARP = Associate result to project
  • AZ_DEPROV = Azure Cloud Deprovisioning
  • AZ_PROV = Azure Cloud Provisioning
  • CATLOSS = CAT Loss Treaty
  • CLOUD_USE = Cloud Usage Report 
  • CLSH = Clash Analysis
  • CMPLOSS =  Comparative Loss               
  • CMPLOSSEXP = Comparative Loss Export to CSV
  • DBEXPORT = Export to database
  • DELETE = Delete
  • DEXPORT = Exposure Export to CSV
  • DQ = Data Quality
  • DQ_AMB = Rating Agency
  • DQ_AUG = Augmentation
  • DQ_DVA = Validation
  • DQ_IDB = Benchmark
  • DQ_IDR = Industry Exposure
  • DQ_RPT = Data Quality Reports
  • DQ_SCR = Scoring
  • DS_ATC = Database Attach
  • DS_CRT = Database Create
  • DS_DLT = Database Delete
  • DS_DTC = Database Detach
  • DS_INC = Incompatible
  • DS_REG = Database Register
  • DS_UPG = Database Upgrade
  • EC = Geospatial
  • EXPS = Exposure Summary
  • HAZ = Hazard Analysis
  • IMPACT = Impact Analysis
  • IMPORT = Import
  • LEXPORT = Company Loss File (CLF) Export
  • LGRP = Detailed Loss Group
  • LOSS = Detailed Loss
  • LOSS_MOD = Modified Detailed Loss
  • LTEXP = Loss Cost Templates Export
  • LTIMP = Loss Cost Templates Import
  • OLAP = OLAP service
  • REGEO = Geocode
  • REXPORT = Results Export to CSV
  • RSPEXPORT = Reinsurance Submission Package Export
  • RSPIMPORT = Reinsurance Submission Package Import
  • SHP_IMPORT = GIS Shape File Import
  • SPTL = Batch Spatial
  • UNASSIGNED = Unassigned
  • UW_RPT = Underwriting Report Generation
VarChar10   
 ActivityType

Name of the activity type.

Corresponds to the code in ActivityTypeCode.

VarChar40  
 ActivityTypeSeqNum

Defines the sequential execution order for a set of activities. This field is only applicable for Data Quality activities.

Data Quality analysis activities are numbered as follows:

  • 1 – Augmentation 
  • 2 – Validation
  • 3 – Scoring
  • 4 – Industry Exposure
  • 5 – Benchmark
  • 6 – Rating Agency
UnsignedTinyInt1  
 ParentActivityTypeCode

Code that represents the parent's activity type.

Codes are identified in ActivityTypeCode.

VarChar10  
 Description
Description of the activity type.
VarChar1024  
 IsEnabled

Indicates whether the activity type is capable of assignment by the HPC Worker Host, thereby making it visible in the Activity Monitor on the user interface.

  • 1 = Yes (assignable)
  •  0 = No (not assignable)
Boolean1 dbo.D_0 
 IsDistributable

Indicates whether the activity type can be distributed to more than one HPC Worker Host core.

  • 1 = Yes (distributable to more than one core)
  • 0 = No (limited to one core)
Boolean1 dbo.D_1 
 ISSystem Boolean1 
((0))
 
Objects that depend on tActivityType
 Database ObjectObject TypeDescriptionDep Level
tActivityTypeActivityStageXref tabletActivityTypeActivityStageXrefTableSystem reference table used by the Activity Monitor to determine the current stage of the activity.1
tExecutionPlan tabletExecutionPlanTable

Table used internally by SQL Server. When a user deletes data from Touchstone, this table identifies which information is to be deleted.

1
tFilterAttributeActivityTypeXref tabletFilterAttributeActivityTypeXrefTableSystem reference table used to determine the possible activities that can be applied to specific filter attributes.1
See Also

Related Objects

AIRReference Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.