Touchstone 4.0 Database Documentation
tExecutionPlan Table
Description

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

Properties
Creation Date6/8/2012 1:42 PM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows18
Data Space Used128.00 KB
Index Space Used32.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ExecutionPlanSID

Unique system-generated sequential identifier for the execution plan record.

  • 0 =  DEL_EXPVIEWRESULTS (Delete ExpsoureView Results)
  • 1 = DEL_LOCATION  (Delete Locations)
  • 2 = DEL_CONTRACT (Delete Contracts)
  • 3 = DEL_PROJECTS (Delete Projects)
  • 4 = DEL_PROJEXPSETS (Delete Project ExposureSets)
  • 5 = DEL_PROJEXPVIEW (Delete Project ExposureViews)
  • 6 = DEL_PROJRESULTS (Delete Project ResultSets)
  • 7 = DEL_REINSPROGRAM (Delete Reinsurance Program)
  • 8 = DEL_REINTREATY (Delete Reinsurance Treaty)
  • 9 = DEL_RESULTS (Delete ResultsSets)
  • 10 = DEL_ACTIVITY (Delete Activities)
  • 11 = DEL_DATASOURCE (Delete DataSources)
  • 12 = DEL_EXPSETS (Delete ExposureSets)
  • 13 = DEL_EXPVIEW (Delete ExposureViews)
  • 14 = DEL_EXPVIEWEXPSETS (Delete ExposureView ExposureSets)
  • 15 = DEL_NAMEDDATASOURCE (Delete Named DataSources)
  • 16 = DEL_PROJREINSPROGRAM (Delete Project Reinsurance Program)
  • 17 = DEL_CONTRACTRESULTS (Delete Contract Results)
Integer4   
 ActivityTypeCode

Code that represents the activity type.

For a complete list of codes, see tActivityType Table.

VarChar10   
 ExecutionType

Brief name for the type execution.

Corresponds to the code in ExecutionPlanSID.

VarChar40   
 Name

Name of the execution plan.

Corresponds to the code in ExecutionPlanSID.

VarChar255  
 ExecutionPlan

XML string that defines the steps of the execution plan. In this case, the steps to delete the locations.

Xml16   
 Description

Description of the execution plan.

VarChar1024  
 EnteredDateDate the execution plan was entered.DBTimeStamp4 
(getutcdate())
 
 EditedDateDate the execution plan was last modified.DBTimeStamp4 
(getutcdate())
 
Objects that tExecutionPlan depends on
 Database ObjectObject TypeDescriptionDep Level
tActivityType tabletActivityTypeTableDefines the type of activity.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.