Table Name:	dt_property_template
Table Number:	4675
Group:	Dovetail
Description:	Task Property Template
Flags:
Baseline/Custom:	Custom

Fields
Relations
Indexes
Referenced in Views

select * from table_dt_property_template

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
action	CHAR	varchar		255		USER_DEFINED	Task Action this property template applies to. i.e. Create Subcase
app_list_name	CHAR	varchar		255		USER_DEFINED	If the property maps to an application list, the Application List Name (gbst_lst)
data_type	CHAR	varchar		40		USER_DEFINED	Data Type
name	CHAR	varchar		255		USER_DEFINED	Property Name
objid	LONG	int	3			USER_DEFINED	Internal record number
save_to	CHAR	varchar		255		USER_DEFINED	When the property's value is saved to
user_defined_list_name	CHAR	varchar		255		USER_DEFINED	If the property maps to a user-defined list, the user-Defined List Name (hgbst_lst)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
dt_prop_tmpl2configured_prop	OTM	dt_configured_property	dt_configured_prop2prop_tmpl	Configured property based on this property template	USER_DEFINED

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
dt_prop_tmpl_index	action:name	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
dt_prop_tmpl_index	action, name	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

dt_property_template

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user