Table Name:	phone_log
Table Number:	28
Group:	Workflow Mgr
Description:	Object which contains the details of a phone call for a case or subcase
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_phone_log

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
action_type	CHAR	varchar	49	40			Action type for the log: This is a user-defined pop up with default name Phone Log Action Type	Search (1)
commitment	CHAR	varchar	42	80			Title of commitment made during the activity. This is a user-defined popup with default name COMMITMENT
creation_time	CLK_TIME	datetime	1				Date and time the phone conversation began	Search (4)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
due_date	CLK_TIME	datetime	43				Date and time commitment made on the phone log is due
internal	CHAR	varchar	33	255			For-internal-use-only phone notes	Search (1)
notes	CHAR	text	23			ALLOW_NULL	Text of phone notes	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
site_time	CLK_TIME	datetime					Local date and time at customer site location
stop_time	CLK_TIME	datetime	6				Date and time user hung up the phone	Search (4)
x_is_internal	LONG	int				USER_DEFINED	Internal phone log indicator

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
phone_log2act_entry	OTM	act_entry	act_entry2phone_log	Activity log entry for phone call
case_phone2case	MTO	case	case_phone2phone_log	Case for the phone log entry
phone_log2condition	OTOF	condition	condition2phone_log	Phone log involved in the condition of a focus object- only the initial phone log is related to the condition object
phone_custmr2contact	MTO	contact	caller2phone_log	Customer contact for the phone log entry
contr_phone2contract	MTO	contract	contract2phone_log	Contract for the phone log entry
phone_empl2employee	MTO	employee	intcontact2phone_log	Employee who initiated the phone log entry
old_phone_stat2gbst_elm	MTO	gbst_elm	old_cas_stat2phone_log	Old status prior to changes made for the activity
new_phone_stat2gbst_elm	MTO	gbst_elm	new_cas_stat2phone_log	New status based on changes made in the activity
opp_phone2opportunity	MTO	opportunity	opp_phone2phone_log	Opportunity for the phone log entry
subc_phone2subcase	MTO	subcase	subc_phcall2phone_log	Subcase for the phone log entry
task_phone2task	MTO	task	task_phone2phone_log	Task for the phone log entry
phone_owner2user	MTO	user	originator2phone_log	User that initiated the phone log entry

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_case_phone2case	case_phone2case, objid	nonclustered, unique located on PRIMARY
ind_contr_phone2contract	contr_phone2contract, objid	nonclustered, unique located on PRIMARY
ind_creation_time	creation_time	nonclustered located on PRIMARY
ind_opp_phone2opportunity	opp_phone2opportunity, objid	nonclustered, unique located on PRIMARY
ind_phone_owner2user	phone_owner2user	nonclustered located on PRIMARY
ind_subc_phone2subcase	subc_phone2subcase, objid	nonclustered, unique located on PRIMARY
ind_task_phone2task	task_phone2task, objid	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
118	case2cnvlg	act_entry, case, phone_log
175	subcase2cnvlg	act_entry, phone_log, subcase
177	dfe2cnvlg	disptchfe, phone_log
4625	fc_acct_phone_view	act_entry, gbst_elm, participant, phone_log, user

My Recent Objects

phone_log

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user