Table Name:subcase
Table Number:24
Group:Support
Description:Subcase object which contains info on a task that is being delegated and commitment date for that task
Flags:CACHEOBJIDS, ALLOW_FLEX 
Baseline/Custom:Baseline
select * from table_subcase
Keyboard shortcuts available
Fields:

(double-click a column header to select column text)

Field Name
Common Type
Database Type
Generic Field ID
Array Size
Default
Flags
Comment
Field Used in Views
behaviorLONGint31  DIRECT Internal field indicating the behavior of the subcase type; i.e., 1=normal, 2=administrative subcase Search (6)
creation_timeCLK_TIMEdatetime1   The date and time the subcase was created Search (7)
descriptionCHARtext23  ALLOW_NULL, CHANGE_FIELD, DONT_DISTR_TO_CLIENT, DONT_DISTR_TO_SERVER Subcase description Search (3)
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
distLONGint  1 DIRECT Used by Task mgr for auto-generation preview; i.e., 0=inactive, 1=active, default=1 Search (1)
elapsed_timeLONGint6  DIRECT Elapsed time in seconds Search (2)
fcs_cc_notifyLONGint   DIRECT Reserved; custom  
id_numberCHARvarchar432  Unique ID number for the subcase; consists of case number-# Search (20)
modify_stmpCLK_TIMEdatetime48  CHANGE_DATE The date and time when object is saved Search (1)
objidLONGint3  DIRECT Internal record number Search (34)
ownership_stmpCLK_TIMEdatetime47   The date and time when ownership changes  
reopen_flagLONGint   DIRECT Reserved; not used  
required_dateCLK_TIMEdatetime43   Date and time task must be completed Search (7)
sub_typeCHARvarchar3220  Subcase type; general or administrative Search (9)
titleCHARvarchar280  Subcase title Search (13)
warning_timeCLK_TIMEdatetime    Date and time of commitment warning Search (3)
yank_flagLONGint   DIRECT Reserved; not used  
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
subcase_acd2acd_callOTMacd_callacd_call_subcase2subcaseRelated ACD calls       
aux_subcase2act_entryOTOPact_entryact_xentry2subcaseWhen a subcase is created there is a subcase-create activity log entry in the parent case. The entry is related to the subcase created       
subcase2act_entryOTMact_entryact_entry2subcaseSubcase activity log entries       
subcase2caseMTOcasecase2subcaseParent case   Search (19)   
subcase2close_caseOTMclose_caseclose_case2subcaseRelated subcase closure entry       
subcase2cls_factoryOTOFcls_factoryfactory2subcaseTemplate which uses the subcase for auto generation       
subc_gen2cls_factoryMTOcls_factoryfct_gen2subcaseTemplate from which the subcase was generated   Search (1)   
subc_cmit2commit_logOTMcommit_logsubc_commit2subcaseRelated subcase commitment logs       
subc_state2conditionOTOPconditionsubc_conditn2subcaseSubcase condition   Search (18)   
subcaseinfo2demand_hdrOTMdemand_hdrsubcaseinfo2caseReserved; not used. Use relation from parent case to demand_hdr instead       
subcase_onsite2disptchfeOTMdisptchfedisptchfe2subcaseFE dispatches for the subcase       
subcase_attch2doc_instOTMdoc_instdoc_inst2subcaseDocument attachment file instances for the subcase       
subc_email2email_logOTMemail_logsubc_email2subcaseEmail logs for the subcase       
subc_empl2employeeMTOemployeecreator2subcaseEmployee who created the subcase       
subcase2escalationOTMescalationsubc_escalate2subcaseReserved; obsolete       
subcase2fa_subcaseOTMfa_subcasefa_subcase2subcase       
subc_info2fcs_detailOTMfcs_detailused_by2subcaseReserved; custom       
subc_info2fcs_headerOTMfcs_headerreq_by2subcaseReserved; custom       
subc_casests2gbst_elmMTOgbst_elmcase_status2subcaseSubcase status; defined as a Clarify-defined pop up list associated with each type of condition   Search (10)   
subc_priorty2gbst_elmMTOgbst_elmpriority2subcaseSubcase priority; defined as a Clarify-defined pop up list   Search (8)   
subc_svrity2gbst_elmMTOgbst_elmseverity2subcaseSubcase severity; defined as a Clarify-defined pop up list   Search (6)   
subcase2jobMTOjobjob2subcaseJob which is tracking the subcase       
subc_view2monitorMTMmonitormonitor2subcaseReserved; obsolete  mtm_subcase21_
monitor7		    
subc_notes2notes_logOTMnotes_logsubc_notes2subcaseSubcase note logs       
subc_onsit2onsite_logOTMonsite_logsubc_onsite2subcaseSubcase T&E logs       
subc_phcall2phone_logOTMphone_logsubc_phone2subcaseSubcase phone logs       
subc_prevq2queueMTOqueueprevq2subcasePrevious queue; used in temporary accept to record previous queue subcase was in       
subc_currq2queueMTOqueuecurrq2subcaseQueue subcase is dispatched to   Search (7)   
subcase2r_rqstOTMr_rqstr_rqst2subcaseRouting requests for the subcase    route_for source_type source_lowid 
subcase2reject_msgOTMreject_msgreject_reason2subcaseReason for rejection of subcase       
subc_rsrch2resrch_logOTMresrch_logsubc_resrch2subcaseSubcase research logs       
subc_rip2ripbinMTOripbinsubc_ripbin2subcaseReserved; obsolete   Search (2)   
subcase2scr_runOTMscr_runscr_run2subcaseScript runs initiated by the subcase       
subcase2status_chgOTMstatus_chgsubc_stat_chg2subcaseSubcase status changes       
subcase2tagMTMtagtag2subcase USER_DEFINED mtm_subcase38_
tag1		    
subcase2topicOTMtopictopic2subcaseRelated topic for this subcase    interaction_for focus_type focus_lowid 
subc_orig2userMTOuseroriginator2subcaseUser that originated the subcase       
subc_owner2userMTOusercurr_owner2subcaseUser that owns subcase   Search (17)   
subc_wip2wipbinMTOwipbinwipbin2subcaseWIPbin that subcase is accepted into   Search (7)   
Indexes: (Defined in Clarify Schema)
Index Name
Fields
Flags
subcase_indexid_numberUNIQUE 
Indexes (Defined in Database):
Index Name
Fields
Additional Information
ind_aux_subcase2act_entryaux_subcase2act_entrynonclustered located on PRIMARY
ind_subc_currq2queuesubc_currq2queuenonclustered located on PRIMARY
ind_subc_empl2employeesubc_empl2employeenonclustered located on PRIMARY
ind_subc_orig2usersubc_orig2usernonclustered located on PRIMARY
ind_subc_owner2usersubc_owner2user, subc_wip2wipbinnonclustered located on PRIMARY
ind_subc_prevq2queuesubc_prevq2queuenonclustered located on PRIMARY
ind_subc_priorty2gbst_elmsubc_priorty2gbst_elmnonclustered located on PRIMARY
ind_subc_svrity2gbst_elmsubc_svrity2gbst_elmnonclustered located on PRIMARY
ind_subc_wip2wipbinsubc_wip2wipbinnonclustered located on PRIMARY
ind_subcase_titletitlenonclustered located on PRIMARY
ind_subcase2casesubcase2casenonclustered located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
sc2c0024subc_state2condition, subc_casests2gbst_elmnonclustered located on PRIMARY
sg2cf0024subc_gen2cls_factorynonclustered located on PRIMARY
subcase_indexid_numbernonclustered, unique located on PRIMARY
Referenced in Views:
View ID
View Name
Tables
39subcase_al act_entry, gbst_elm, gbst_lst, subcase, user
57wipelm_subcase condition, gbst_elm, site, subcase, user, wipbin
60queelm_subcase condition, gbst_elm, queue, site, subcase, user
81subc_cmitl commit_log, gbst_elm, subcase, user
121case2wip_sub case, condition, subcase, wipbin
160subcase_view case, condition, contact, gbst_elm, subcase, user
161monelm_subcase condition, gbst_elm, monitor, subcase, user
166cls_sub_view case, condition, contact, employee, site, subcase, user, wipbin
168num_sub_cls case, condition, subcase
172ripelm_subcase ripbin, subcase
175subcase2cnvlg act_entry, phone_log, subcase
176subcase2rsrch act_entry, resrch_log, subcase
179case2sub_cls case, close_case, subcase
182case2rip_sub case, ripbin, subcase
190v_cls_subc case, condition, contact, site, subcase
248qry_subcase_view condition, contact, gbst_elm, site, subcase, user
272list_subcase case, condition, gbst_elm, subcase, user
279list_sub_dfe disptchfe, subcase
360onsite_sub_lst onsite_log, subcase
368subc_attch doc_inst, doc_path, subcase
378subc_lst condition, contact, subcase, user
380subc_cmit commit_log, contact, subcase, user
392subcase_queued_dfe condition, disptchfe, queue, subcase, user
394dfe_subcase_user disptchfe, queue, subcase, user, wipbin
4651fc_user_subcase_view case, condition, contact, employee, gbst_elm, queue, site, subcase, user, wipbin
4664tagged_subcases condition, subcase, tag, user
5047sub_preview cls_factory, gbst_elm, subcase, user
5217ccc_rundsply bug, bus_org, campaign, case, contact, contr_itm, contract, demand_dtl, employee, lead_source, opportunity, probdesc, scr_run, site, site_part, subcase, task
5234subc2oltsk contact, gbst_elm, subcase, user
5364subc_alst act_entry, case, gbst_elm, gbst_lst, subcase, user
5679subcase_list case, condition, gbst_elm, subcase, user
5741subcase_overview case, condition, contact, gbst_elm, queue, subcase, user, wipbin
5988subc_cmit2 commit_log, contact, subcase, user
6019schdl_tracker_sub_v3 address, disptchfe, employee, hgsl2hgse, queue, site, subcase, user, wipbin
6051onsite_dfe_subc disptchfe, onsite_log, subcase
6052v_cls_subc2 contact, site, subcase
My Recent Objects
subcase      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user