Table Name:	close_case
Table Number:	115
Group:	Support
Description:	Close case object which records case or subcase closure activity and contains the case/subcase metrics
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

select * from table_close_case

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
actl_bill_exp	DECIMAL	decimal (19,4)				CURRENCY	Actual billable expenses for the case. Not displayed/used by CeFO client. Used by the Case BO to to calculate the total for the tot_actl_bill field	Search (3)
actl_nonbill	DECIMAL	decimal (19,4)				CURRENCY	Actual non-billable expenses for the case. Not displayed/used by CeFO client. Used by the Case BO to to calculate the total for the tot_actl_nonb field	Search (3)
actl_phone_time	LONG	int				DIRECT	Actual elapsed time spent on the phone for the case or subcase; entered by user if different from captured phone time in seconds	Search (3)
actl_rsrch_time	LONG	int				DIRECT	Actual elapsed time spent doing research for the case or subcase; entered by user if different from captured research time in seconds	Search (3)
bill_time	LONG	int				DIRECT	Calculated billable time for the case/subcase; calculated from T&E log time items in seconds	Search (3)
calc_bill_exp	DECIMAL	decimal (19,4)				CURRENCY	Calculated billable expenses for the case; calculated from T&E logs	Search (3)
calc_nonbill	DECIMAL	decimal (19,4)				CURRENCY	Calculated non-billable expenses for the case; calculated from T&E logs	Search (3)
calc_phone_time	LONG	int				DIRECT	Time spent on the phone for the case or subcase; calculated from phone logs	Search (3)
calc_rsrch_time	LONG	int				DIRECT	Elapsed time spent doing research for the case or subcase; calculated from research logs in seconds	Search (3)
close_date	CLK_TIME	datetime	1				Case close date and time	Search (3)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
nonbill_time	LONG	int				DIRECT	Calculated non-billable time for the case/subcase; calculated from T&E log time items in seconds	Search (3)
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
previous_closed	CLK_TIME	datetime					Date/time case/subcase was last closed; earlier than close date if the case has been closed before	Search (3)
summary	CHAR	varchar		255			Close case summary
tot_actl_bill	DECIMAL	decimal (19,4)				CURRENCY	Total actual billable expenses for the case and all subcases; not displayed/used
tot_actl_nonb	DECIMAL	decimal (19,4)				CURRENCY	Total actual non-billable expenses for the case and all subcases; not displayed/used
tot_actl_phone_time	LONG	int				DIRECT	Total actual elapsed time spent on the phone, including both captured and added time, for the case and all its subcases in seconds
tot_actl_rsrch_time	LONG	int				DIRECT	Total elapsed time spent doing research for the case and all its subcases in seconds
used_unit	FLOAT	real					Number of contract units used

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Used in Views
close_case2act_entry	OTOP	act_entry	act_entry2close_case	Activity log entry	Search (2)
last_close2case	OTOP	case	last_close2close_case	Case for which this is a close case entry
closer2employee	MTO	employee	closer2close_case	Employee who closed case
close_rsolut2gbst_elm	MTO	gbst_elm	resolution2close_case	Resolution code for close case entry; defined as a Clarify-defined pop up list item
cls_old_stat2gbst_elm	MTO	gbst_elm	old_status2close_case	Status before the case was closed
cls_new_stat2gbst_elm	MTO	gbst_elm	new_status2close_case	Status after the case was closed
close_case2subcase	MTO	subcase	subcase2close_case	Subcase closed by the activity	Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_close_case2act_entry	close_case2act_entry	nonclustered located on PRIMARY
ind_close_case2subcase	close_case2subcase, objid	nonclustered, unique located on PRIMARY
ind_close_date	close_date	nonclustered located on PRIMARY
ind_close_rsolut2gbst_elm	close_rsolut2gbst_elm	nonclustered located on PRIMARY
ind_closer2employee	closer2employee	nonclustered located on PRIMARY
ind_cls_new_stat2gbst_elm	cls_new_stat2gbst_elm	nonclustered located on PRIMARY
ind_cls_old_stat2gbst_elm	cls_old_stat2gbst_elm	nonclustered located on PRIMARY
ind_last_close2case	last_close2case	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
179	case2sub_cls	case, close_case, subcase
180	case2dfe_cls	case, close_case, disptchfe
181	case2case_cls	case, close_case

My Recent Objects

close_case

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