Table Name:condition
Table Number:36
Group:Workflow Mgr
Description:Used to specify the current state of a task
Flags:CACHEOBJIDS 
Baseline/Custom:Baseline
select * from table_condition
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
conditionLONGint   DIRECT Code number for condition type Search (59)
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
dispatch_timeCLK_TIMEdatetime    Reserved; not used Search (8)
first_resp_timeCLK_TIMEdatetime    Reserved; not used  
objidLONGint3  DIRECT Internal record number Search (21)
queue_timeCLK_TIMEdatetime    Date and time task was dispatched to queue Search (15)
sequence_numLONGint   DIRECT Tracks sequence number of a subcase  
titleCHARvarchar280  Title of condition Search (98)
wipbin_timeCLK_TIMEdatetime    Date and time task was accepted into WIPbin Search (21)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
bug_condition2bugOTOFbugbug_condit2conditionChange request having the condition    
case_condition2caseOTOFcasecase_state2conditionCase having the condition    
condition2contractOTOFcontractcontract2conditionContract having the condition    
condition2demand_dtlOTOFdemand_dtldemand_dtl2conditionPart request detail object having the condition    
condition2dialogueOTOFdialoguedialogue2conditionDialogue having the condition    
cond_custsts2gbst_elmMTOgbst_elmcust_status2conditionReserved; not used    
job_condition2jobOTOFjobjob_state2conditionJob having the condition    
opp_condition2opportunityOTOFopportunityopp_state2conditionOpportunity having the condition    
condition2phone_logOTOPphone_logphone_log2conditionPhone entry for the condition. Only the initial phone log is related to the condition object    
condition2probdescOTOFprobdescprobdesc2conditionSolution having the condition    
subc_conditn2subcaseOTOFsubcasesubc_state2conditionSubcase having the condition    
task_condition2taskOTOFtasktask_state2conditionTask having the condition    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
Indexes (Defined in Database):
Index NameFieldsAdditional Information
ind_cond_custsts2gbst_elmcond_custsts2gbst_elmnonclustered located on PRIMARY
ind_condition2phone_logcondition2phone_lognonclustered located on PRIMARY
ind_objid_titleobjid, titlenonclustered, unique located on PRIMARY
ind_titletitle, objidnonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
3ship_sum condition, demand_dtl, gbst_elm, ship_dtl, ship_parts, site
56wipelm_case case, condition, gbst_elm, site, user, wipbin, workaround
57wipelm_subcase condition, gbst_elm, site, subcase, user, wipbin
58wipelm_dtl condition, demand_dtl, gbst_elm, mod_level, part_num, user, wipbin
59queelm_case case, condition, gbst_elm, queue, site, user, workaround
60queelm_subcase condition, gbst_elm, queue, site, subcase, user
61queelm_dtl condition, demand_dtl, gbst_elm, mod_level, part_num, queue, user
96wipelm_fnl condition, probdesc, wipbin
97queelm_fnl condition, probdesc, queue
116cls_case_view case, condition, contact, employee, site, user, wipbin
121case2wip_sub case, condition, subcase, wipbin
148extactcase case, condition, contact, gbst_elm, site
149intactcase case, condition, employee, gbst_elm, site
158case_view case, condition, contact, gbst_elm, user
159monelm_case case, condition, gbst_elm, monitor, user
160subcase_view case, condition, contact, gbst_elm, subcase, user
161monelm_subcase condition, gbst_elm, monitor, subcase, user
162dfe_view case, condition, contact, disptchfe, gbst_elm, user
165monelm_fnl condition, monitor, probdesc, user
166cls_sub_view case, condition, contact, employee, site, subcase, user, wipbin
167cls_dfe_view case, condition, contact, disptchfe, employee, site, user, wipbin
168num_sub_cls case, condition, subcase
169num_dfe_cls case, condition
189v_cls_case case, condition, contact, site
190v_cls_subc case, condition, contact, site, subcase
191v_cls_dfe case, condition, contact, disptchfe, site
195wipelm_bug bug, condition, gbst_elm, part_num, wipbin
196queelm_bug bug, condition, gbst_elm, part_num, queue
198bug_view bug, condition, gbst_elm, user
199monelm_bug bug, condition, gbst_elm, monitor, user
208qry_case_view case, condition, contact, gbst_elm, site, user
209qry_bug_view bug, condition, gbst_elm, part_num, user
215qry_bug bug, condition, gbst_elm, part_num, user
238req_sum condition, demand_dtl, demand_hdr, gbst_elm, mod_level, part_num, user
247probdesc2bug bug, condition, gbst_elm, probdesc
248qry_subcase_view condition, contact, gbst_elm, site, subcase, user
272list_subcase case, condition, gbst_elm, subcase, user
295assoc_bugs bug, condition, gbst_elm, user
296master_bug bug, condition, gbst_elm, user
311qry_finale_view condition, probdesc, user
341user_case_load case, condition, gbst_elm, user
378subc_lst condition, contact, subcase, user
381wip_element case, condition, demand_dtl, gbst_elm, mod_level, part_num, wipbin
382que_element case, condition, demand_dtl, gbst_elm, mod_level, part_num, queue
391queued_case_dfe case, condition, disptchfe, queue, user
392subcase_queued_dfe condition, disptchfe, queue, subcase, user
398rep_bugs bug, condition, gbst_elm, user
4603assoc_bugs_master bug, condition, gbst_elm, user
4604rep_bugs_master bug, condition, gbst_elm, user
4615fc_case_view bus_org, bus_site_role, case, condition, contact, gbst_elm, site, user
4621fc_acct_task_view bus_org, condition, gbst_elm, task, user
4628fc_wipelm_task condition, gbst_elm, task, wipbin
4629fc_queelm_task condition, gbst_elm, queue, task
4650fc_user_case_view case, condition, contact, employee, gbst_elm, queue, site, user, wipbin, workaround
4651fc_user_subcase_view case, condition, contact, employee, gbst_elm, queue, site, subcase, user, wipbin
4652fc_user_solution_view condition, employee, probdesc, queue, user
4663tagged_cases case, condition, tag, user
4664tagged_subcases condition, subcase, tag, user
4665tagged_solutions condition, probdesc, tag, user
4666tagged_part_requests condition, demand_dtl, tag, user
4667tagged_action_items condition, tag, task, user
4678tagged_crs bug, condition, tag, user
5037wipelm_contr condition, contract, gbst_elm, wipbin
5038queelm_contr condition, contract, gbst_elm, queue
5039wipelm_opp condition, gbst_elm, opportunity, wipbin
5044queelm_opp condition, gbst_elm, opportunity, queue
5050qry_ccn_hdr_view bus_org, condition, contact, contract, gbst_elm, user
5063contr_sp_chk condition, contr_itm, contr_schedule, contract, mod_level, site, site_part
5073opp_view condition, cycle_stage, opportunity, user
5077task_con bus_org, condition, contact, gbst_elm, opportunity, task, user
5087wipelm_task condition, gbst_elm, task, wipbin
5088queelm_task condition, gbst_elm, queue, task
5109ccn_bill_view bus_org, condition, contr_schedule, contract, currency, site, user
5144victimcase case, condition, contact, gbst_elm, site
5145supercasev case, condition, contact, gbst_elm, site
5166web_usrcas case, condition, gbst_elm, user
5182site_svc_itm condition, contr_itm, contr_schedule, contract, site
5183prod_svc_itm condition, contr_itm, contr_schedule, contract, site_part
5187task_preview cls_factory, condition, contact, gbst_elm, task, user
5221sitepartcase case, condition, contact, gbst_elm, site_part
5222servicecase case, condition, contact, gbst_elm, prt_prt_role, site_part
5223prodcase case, condition, contact, gbst_elm, prt_prt_role, site_part
5232ai2oltsk_apt condition, contact, gbst_elm, task, task_desc, user
5319wipelm_dlg condition, dialogue, gbst_elm, wipbin
5329queelm_dlg condition, dialogue, gbst_elm, queue
5332req_demand condition, demand_dtl, demand_hdr, gbst_elm, mod_level, user
5338case_display case, condition, contact, gbst_elm, site
5356sfa_opp_wk_v condition, gbst_elm, opportunity, queue, user, wipbin
5358sfa_tsk_wk_v condition, gbst_elm, queue, task, user, wipbin
5372v_e_order condition, contact, contract, gbst_elm
5397select_dialog condition, dialogue, gbst_elm, user
5462wap_case_info address, case, condition, contact, contract, employee, gbst_elm, queue, site, site_part, user, wipbin
5478sales_quote_v bus_org, condition, contact, contract, currency, gbst_elm, opportunity, user
5547sfa_task_cond_v condition, gbst_elm, task, user
5597iclient_opp_view condition, currency, cycle_stage, opportunity, user
5679subcase_list case, condition, gbst_elm, subcase, user
5680case_list case, condition, contact, gbst_elm, site, user
5681prev_case case, condition, gbst_elm, user
5688af_case_list case, condition, gbst_elm, user
5731vw_case_billing blg_argmnt, case, condition, contact, fin_accnt, gbst_elm, pay_channel, site
5739case_overview address, case, condition, contact, contact_role, contract, country, gbst_elm, mod_level, queue, site, site_part, user, workaround
5740case_more_info address, case, condition, contact, country, gbst_elm, queue, site, user, wipbin
5741subcase_overview case, condition, contact, gbst_elm, queue, subcase, user, wipbin
5783order_list_v bus_org, condition, contact, contract, gbst_elm
6025wipelm_demanddtl condition, demand_dtl, gbst_elm, wipbin
6026queueelm_demanddtl condition, demand_dtl, gbst_elm, queue
6031sp_orders_v bus_org, condition, contact, contract, gbst_elm, order_action, order_line, site_part
My Recent Objects
condition      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user