tObjectType Table

CEDE 8.0 Database Reference

tObjectType Table

Collapse All

AIRReference Database : tObjectType Table

Description

A generic table to hold objects like templates and widgets which are added through the object management screen in administration console.

Properties

Creation Date	1/6/2014 1:33 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	26
Data Space Used	8.00 KB
Index Space Used	40.00 KB

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	ObjectTypeCode	Code that represents the object type. ADJST = Non Cat Loss Cost Adjustment Factor Template ADMINBOUND = Admin Boundary AIR_MapLegend = AIR MapLegend AIR_SPTL_Group = AIR Spatial Group AIR_SPTL_LYR = AIR Spatial Layer BURST_POLICY = Burst Policy CLSH_TMPLT = Clash Template CSTM = Non Cat Custom Calculator Template CSTM_MapLegend = Custom MapLegend CSTM_SPTL_Group = Custom Spatial Group CSTM_SPTL_LYR = Custom Spatial Layer DQ_TMPLT = Data Quality Template EBAF_FILE_SET = Event Based Adjustment Factor Set ECA_TMPLT = Geospatial Template HAZ_TMPLT = Hazard Template HAZ_WDGT = Hazard Widget IMPACT_ABPERIL = Marginal Impact Administrative Boundary and Peril Set Code Combination IMPACT_WDGT = Marginal Impact Widget LOSS_MOD_TMPLT = Detailed Loss Mod Template LOSS_TMPLT = Detailed Loss Template LOSS_WDGT = Loss Widget PGM_TMPLT = Aggregate Program Analysis Template PRT_TMPLT = Aggregate Portfolio Analysis Template USERGEOMATCH_MAPPINGSET = User Geocode Match Mapping Set WEB_SPTL_LYR = Web Map Layer ZONESET = Zone Set	varchar	25
	ObjectType	Name of the object type. Corresponds to the code in ObjectTypeCode.	varchar	40
	Description	Description of the object type.	varchar	1024
	IsDefaultAvailable	Indicates whether the object type is the default. 1 = Yes (default) 0 = No (not default)	bit	1		dbo.D_0
	ObjectBUDefinitionCode	Code that identifies the object associated with a business unit. For a complete list of codes, see tObjectBUDefinition Table.	int	4		((1))
	IsGlobal	Indicates whether the object type can be shared across business units. 1 = Yes (global) 0 = No (not global)	bit	1		((0))

Check Constraints

Name	Description	Expression
CKC_ISDEFAULTAVAILABL_TOBJECTT		([IsDefaultAvailable] IS NULL OR [IsDefaultAvailable]>=(0) AND [IsDefaultAvailable]<=(1))

See Also

Related Objects

AIRReference Database