Table Name:	task
Table Number:	5080
Group:	Sales Mgr
Description:	Contains information describing an action item; i.e., a task to be performed
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

select * from table_task

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
active	LONG	tinyint			1	DIRECT	Indicates whether the task currently being used; i.e., 0=inactive, 1=active, default=1	Search (2)
arch_ind	LONG	int				DIRECT, ALLOW_NULL	When set to 1, indicates the object is ready for purge/archive
comp_date	CLK_TIME	datetime					Actual completion date of the task	Search (6)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
due_date	CLK_TIME	datetime					Required completion date of the task	Search (6)
notes	CHAR	text				ALLOW_NULL	Notes about the task	Search (2)
objid	LONG	int	3			DIRECT	Internal record number	Search (17)
reminder_period	LONG	int				DIRECT	Elapsed time in seconds before due_date
start_date	CLK_TIME	datetime					Desired start date of the task	Search (11)
task_id	CHAR	varchar	4	25			System-generated task ID number	Search (15)
title	CHAR	varchar	2	80			Title of the task	Search (14)
update_stamp	CLK_TIME	datetime	46			ALLOW_NULL	Date/time of last update to the task

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views	Set Name	Type ID Stored in	Objid Stored In
								Exclusive Set Relations
task2act_entry	OTM	act_entry	act_entry2task	Events for the task
task_for2bus_org	MTO	bus_org	receiver_org2task	Account/organization which the task supports			Search (3)
ex_task2cls_factory	OTOF	cls_factory	factory2task	Template which uses the task in auto subcase generation
task_gen2cls_factory	MTO	cls_factory	fct_gen2task	Class factory which generated the task			Search (1)
task_state2condition	OTOP	condition	task_condition2task	The condition of task			Search (11)
task2contact	MTO	contact	primary_contact2task	Primary contact to be used for the task			Search (4)
sm_task2contract	MTO	contract	contract2task	Contract which the task supports. Reserved; future
task2doc_inst	OTM	doc_inst	doc_inst2task		USER_DEFINED
task_email2email_log	OTM	email_log	task_email2task	Task email logs
task_priority2gbst_elm	MTO	gbst_elm	priority2task	Priority of the task: This is a Clarify-defined pop up list			Search (9)
type_task2gbst_elm	MTO	gbst_elm	type_task2task	Type of the task: This is a Clarify-defined pop up list			Search (5)
task_sts2gbst_elm	MTO	gbst_elm	status2task	Status of the task. This is a Clarify-defined popup list			Search (12)
task2lead	MTO	lead	lead2task	Related lead			Search (1)
task2lit_req	MTO	lit_req	lit_req2task	Related literature request template			Search (1)
task2notes_log	OTM	notes_log	task_notes2task	Notes about the task
sm_task2opportunity	MTO	opportunity	opp_task2task	Opportunity which the task supports			Search (3)
task_phone2phone_log	OTM	phone_log	task_phone2task	Task phone logs
task_currq2queue	MTO	queue	queue2task	Queue to which the task has been dispatched			Search (3)
task_prevq2queue	MTO	queue	prevq2task	Queue to which the task was previously dispatched
task2r_rqst	OTM	r_rqst	r_rqst2task	Routing requests for the task				route_for	source_type	source_lowid
task_rej2reject_msg	OTM	reject_msg	reject_msg2task	Reject messages for a task that has been rejected
task2scr_run	OTM	scr_run	scr_run2task	Script runs initiated by the action item
task2status_chg	OTM	status_chg	status_chg2task	Status changes for the task
task2tag	MTM	tag	tag2task		USER_DEFINED	mtm_tag6_ task30
task2task_desc	OTOP	task_desc	task_desc2task	Additional discription or comments about the task			Search (1)
task2task_participant	OTM	task_participant	task_participant2task	Participants in the fact represented by the task
task2topic	OTM	topic	topic2task	Action item related to this topic				interaction_for	focus_type	focus_lowid
task_originator2user	MTO	user	originator2task	User that created the task
task_owner2user	MTO	user	owner2task	User that currently owns the task			Search (9)
task2user_touch	OTM	user_touch	user_touch2task	Last user touches for the task				touched_by	source_type	source_lowid
task_wip2wipbin	MTO	wipbin	wipbin2task	WIPbin into which the task has been accepted			Search (3)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
task_ind	task_id	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_sm_task2opportunity	sm_task2opportunity	nonclustered located on PRIMARY
ind_task_currq2queue	task_currq2queue, objid	nonclustered, unique located on PRIMARY
ind_task_wip2wipbin	task_wip2wipbin, objid	nonclustered, unique located on PRIMARY
ind_task2contact	task2contact	nonclustered located on PRIMARY
ind_title	title	nonclustered located on PRIMARY
ind_update_stamp	update_stamp, objid	nonclustered, unique located on PRIMARY
o2u5080	task_owner2user	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
t2lr5080	task2lit_req, task2lead	nonclustered located on PRIMARY
task_ind	task_id	nonclustered, unique located on PRIMARY
tf2bo5080	task_for2bus_org	nonclustered located on PRIMARY
ts2c5080	task_state2condition, task_sts2gbst_elm, task2contact, type_task2gbst_elm, task_priority2gbst_elm, task_owner2user, task_gen2cls_factory	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
4621	fc_acct_task_view	bus_org, condition, gbst_elm, task, user
4628	fc_wipelm_task	condition, gbst_elm, task, wipbin
4629	fc_queelm_task	condition, gbst_elm, queue, task
4667	tagged_action_items	condition, tag, task, user
5077	task_con	bus_org, condition, contact, gbst_elm, opportunity, task, user
5087	wipelm_task	condition, gbst_elm, task, wipbin
5088	queelm_task	condition, gbst_elm, queue, task
5089	task_alst	act_entry, gbst_elm, task, user
5106	nlog_actitm	notes_log, task, user
5187	task_preview	cls_factory, condition, contact, gbst_elm, task, user
5217	ccc_rundsply	bug, bus_org, campaign, case, contact, contr_itm, contract, demand_dtl, employee, lead_source, opportunity, probdesc, scr_run, site, site_part, subcase, task
5231	taskempl_view	employee, gbst_elm, opportunity, task, user
5232	ai2oltsk_apt	condition, contact, gbst_elm, task, task_desc, user
5342	sfa_task_v	gbst_elm, task, user
5358	sfa_tsk_wk_v	condition, gbst_elm, queue, task, user, wipbin
5359	sfa_tsk_mto_v	bus_org, contact, lead, lit_req, opportunity, task
5547	sfa_task_cond_v	condition, gbst_elm, task, user

My Recent Objects

task

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog