tExecutionPlan Table

Touchstone 2022 Database Reference

tExecutionPlan Table

Collapse All

AIRReference Database : 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 Date	6/8/2012 1:42 PM
File Group	PRIMARY
Text File Group	PRIMARY
System Object
Published for Replication
Rows	18
Data Space Used	128.00 KB
Index Space Used	32.00 KB

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	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)	int	4
	ActivityTypeCode	Code that represents the activity type. For a complete list of codes, see tActivityType Table.	varchar	10
	ExecutionType	Brief name for the type execution. Corresponds to the code in ExecutionPlanSID.	varchar	40
	Name	Name of the execution plan. Corresponds to the code in ExecutionPlanSID.	varchar	255
	ExecutionPlan	XML string that defines the steps of the execution plan. In this case, the steps to delete the locations.	xml	0
	Description	Description of the execution plan.	varchar	1024
	EnteredDate	Date the execution plan was entered.	datetime	4		(getutcdate())
	EditedDate	Date the execution plan was last modified.	datetime	4		(getutcdate())

Objects that tExecutionPlan depends on

	Database Object	Object Type	Description	Dep Level
	tActivityType	Table	Stores codes that represent types of activities.	1

See Also

Related Objects

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