Table Name:	dt_notice
Table Number:	4661
Group:	Dovetail
Description:	System notifications.
Flags:
Baseline/Custom:	Custom

Fields
Relations
Indexes
Referenced in Views

select * from table_dt_notice

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
availability	CHAR	varchar		255		USER_DEFINED	Availability. Shared to Workgroups, Shared to Everyone
end_date	CLK_TIME	datetime				USER_DEFINED	When the notice stops being active.
message	CHAR	text				USER_DEFINED	Body of notice
modify_stmp	CLK_TIME	datetime				USER_DEFINED	When the notice was last modified.
objid	LONG	int	3			USER_DEFINED	Internal record number
priority	LONG	tinyint				USER_DEFINED	Notice priority level: 1=urgent.
start_date	CLK_TIME	datetime				USER_DEFINED	When the notice becomes active.
title	CHAR	varchar		255		USER_DEFINED	Title of notice

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
dt_notice2workgroup	MTM	hgbst_elm	workgroup2dt_notice	Workgroups that this notice has been shared to	USER_DEFINED	mtm_hgbst_elm3_ dt_notice1
dt_notice2user	MTM	user	user2dt_notice	When relation to user exists this notice has been read by that user.	USER_DEFINED	mtm_user134_ dt_notice0

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

dt_notice

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user