Table Name:gbst_elm
Table Number:79
Group:Policy Mgr
Description:Defines a Clarify (Global String) element; Defines the ClearSupport and ClearQuality status Code and pop up list items <does not include user-defined pop up lists>; used with object 78, which defines the lists themselves
Flags: 
Baseline/Custom:Baseline
select * from table_gbst_elm
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
addnl_infoCHARvarchar 255  Additional application-specific control data used to process the element  
descriptionCHARvarchar 255  Long description of the item  
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
objidLONGint3  DIRECT Internal record number Search (31)
rankLONGint9  DIRECT Position of the item in the list; important in tracking scheduled/unscheduled and config time for service interuption report Search (33)
stateLONGint   DIRECT State/status of the item; i.e., 0=Active, 1=inactive, 2=Default Search (1)
titleCHARvarchar280  Name of the item/element Search (154)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
act_name2act_entryOTMact_entryentry_name2gbst_elmType of activity log    
object2anls_objectOTManls_objectobject2gbst_elmObject's type    
appt_type2apptOTMappointmentappt2appt_typeAppointments of the type    
sub_type2apptOTMappointmentappt2sub_typeAppointments of the subtype    
bug_type2bugOTMbugbug_type2gbst_elmType of a change request    
priority2bugOTMbugbug_priority2gbst_elmPriority of a change request    
severity2bugOTMbugbug_sevrity2gbst_elmReproducibility of a defect Change Request    
status2bugOTMbugbug_sts2gbst_elmStatus of a change request    
domain2bugOTMbugbug_domain2gbst_elmLife cycle phase of a change request    
class2bugOTMbugbug_class2gbst_elmTest class of a change request    
call_type2caseOTMcasecalltype2gbst_elmType of a case    
resp_priority2caseOTMcaserespprty2gbst_elmResponse priority of a case    
resp_severity2caseOTMcaserespsvrty2gbst_elmProblem severity of a case    
case_status2caseOTMcasecasests2gbst_elmStatus of a case    
old_status2close_bugOTMclose_bugclbg_oldstat2gbst_elmStatus before a change request was closed    
new_status2close_bugOTMclose_bugclbg_newstat2gbst_elmStatus after a change request was closed    
old_status2close_caseOTMclose_casecls_old_stat2gbst_elmStatus before a case was closed    
new_status2close_caseOTMclose_casecls_new_stat2gbst_elmStatus after a case was closed    
resolution2close_caseOTMclose_caseclose_rsolut2gbst_elmResolution indicated in a close case activity    
priority2commit_logOTMcommit_logcmit_prirty2gbst_elmReserved; not used    
cond_name2commit_logOTMcommit_logcmit_name2gbst_elmCondition of a commitment log    
resp2communicationOTMcommunicationcmcn_respons2gbst_elmCommunications assigned the requested response type    
cust_status2conditionOTMconditioncond_custsts2gbst_elmReserved; not used    
contact_role2contact_roleOTMcontact_rolecontact_role2gbst_elmReserved; not used    
status2contractOTMcontractstatus2gbst_elmContracts having the status    
csc_entry2csc_activityOTMcsc_activitycsc_entry2gbst_elmCSC activities having the activity code. Reserved; not used    
status2cycle_stageOTMcycle_stagestage_status2gbst_elmCycle stages assigned the status    
status2data_setOTMdata_setdata_set2gbst_elmData set status    
status2demand_dtlOTMdemand_dtldmnd_dtl_sts2gbst_elmPart request objects having the status    
dialogue_sts2dialogueOTMdialoguedialogue_sts2gbst_elmDialogues assigned the status    
dialogue_pty2dialogueOTMdialoguedialogue_pty2gbst_elmDialogues assigned the priority    
analysis2dm_analysisOTMdm_analysisanalysis2gbst_elmAnalysis Type    
lg_type2ds_calc_fldOTMds_calc_fldfld_lg_type2gbst_elmColumn's logical type    
ph_type2ds_calc_fldOTMds_calc_fldfld_ph_type2gbst_elmColumn's physical type    
param_st2ds_param_stOTMds_param_stds_params2gbst_elmParameter type    
type2edaOTMedaeda2gbst_elmEDA type    
attr_type2eda_attrOTMeda_attreda_attr2gbst_elmType of attribute    
measure_type2eda_graphOTMeda_graphmeasure_type2gbst_elmEDA graph's measuring type    
old_cas_stat2email_logOTMemail_logold_email_stat2gbst_elmCase status before the email was sent    
new_cas_stat2email_logOTMemail_lognew_email_stat2gbst_elmCase status after the email was sent    
type2eval_graphOTMeval_grapheval_graph2gbst_elmEvaluation graph type    
gbst_elm2fc_loc_elmOTMfc_loc_elmfc_loc_elm2gbst_elmGBST Element for this locale string USER_DEFINED   
old_status2fix_bugOTMfix_bugfxbg_oldstat2gbst_elmChange request status before a declared fix    
new_status2fix_bugOTMfix_bugfxbg_newstat2gbst_elmChange request status after a declared fix    
type2frcst_grpOTMfrcst_grpfgrp_type2gbst_elmForecast groups having the type    
status2frcst_targetOTMfrcst_targetfrcst_stat2gbst_elmForecast target objects having the status. Reserved; future    
gbst_elm2gbst_lstMTOgbst_lstgbst_lst2gbst_elmGlobal String list to which the element belongs   Search (7)
job_status2jobOTMjobjob_sts2gbst_elmJobs having the status    
send_type2lit_reqOTMlit_reqlit_send2gbst_elmLiterature requests using the send type; i.e., email, fax, or hard copy    
status2lit_reqOTMlit_reqlit_status2gbst_elmLiterature having the status    
status2log_lineOTMlog_linelog_line2gbst_elmLog line's status     
lr_params2md_lr_paramOTMmd_lr_paramlr_params2gbst_elmLogistic regression model's mode    
gbst_elm2mediumOTOFmediummedium2gbst_elmRelates medium to application list element    
status2modelOTMmodelmod_status2gbst_elmModel's status    
type2modelOTMmodelmodel_type2gbst_elmModel's type    
verb2msg_verboseOTMmsg_verbosemsg_verb2gbst_elmMessage's verbosity level    
old_cas_stat2notes_logOTMnotes_logold_notes_stat2gbst_elmCase status before a notes log entry    
new_cas_stat2notes_logOTMnotes_lognew_notes_stat2gbst_elmCase status after a notes log entry    
lg_type2obj_columnOTMobj_columncol_lg_type2gbst_elmColumns data type    
status2opportunityOTMopportunityopp_sts2gbst_elmOpportunity objects having the status    
old_cas_stat2phone_logOTMphone_logold_phone_stat2gbst_elmCase status before a phone log entry    
new_cas_stat2phone_logOTMphone_lognew_phone_stat2gbst_elmCase status after a phone log entry    
pref_type2preferenceOTMpreferencepref_type2gbst_elmCommunications assigned the requested response type    
status2processOTMprocessprocess_status2gbst_elmProcesses with this status code    
old_cas_stat2resrch_logOTMresrch_logold_resrch_stat2gbst_elmCase status before a research log entry    
new_cas_stat2resrch_logOTMresrch_lognew_resrch_stat2gbst_elmCase status after a research log entry    
status2rule_setOTMrule_setrule_set2gbst_elmRule set's status    
status2score_partOTMscore_partscore_part2gbst_elmPartial scoring SQL's status    
resp_type2script_qstnOTMscript_qstnresp_type2gbst_elmScript questions using the response type    
state2se_sessionOTMse_sessionsession2gbst_elmSession's state    
stfunc2server_statsOTMserver_statsst_func2gbst_elmVarious statistical function    
stunit2server_statsOTMserver_statsst_unit2gbst_elmVarious units. e.g. hours, minutes, seconds    
type2stage_taskOTMstage_tasktask_type2gbst_elmStage tasks having the implementation type    
status2stage_taskOTMstage_tasktask_status2gbst_elmStage task definitions having the status    
curr_stat2status_chgOTMstatus_chgc_status_chg2gbst_elmStatus after a change status transaction    
prev_stat2status_chgOTMstatus_chgp_status_chg2gbst_elmStatus before a change status transaction    
priority2subcaseOTMsubcasesubc_priorty2gbst_elmResponse priority of a subcase    
severity2subcaseOTMsubcasesubc_svrity2gbst_elmProblem severity of a subcase    
case_status2subcaseOTMsubcasesubc_casests2gbst_elmStatus of a subcase    
status2taskOTMtasktask_sts2gbst_elmTask objects having the status    
priority2taskOTMtasktask_priority2gbst_elmTask objects having the priority    
type_task2taskOTMtasktype_task2gbst_elmTask objects having the type    
from_state2transitionOTMtransitionfrom_state2gbst_elmPrior state in a state change transaction    
to_state2transitionOTMtransitionto_state2gbst_elmSubsequent state in a state change transaction    
status2tree_setOTMtree_settree_set2gbst_elmTree set's status    
type2weightOTMweightweight2gbst_elmWeight's type    
resolutn2workaroundOTMworkaroundresolution2gbst_elmResolution type of a workaround    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
Indexes (Defined in Database):
Index NameFieldsAdditional Information
ind_gbst_elm2gbst_lstgbst_elm2gbst_lstnonclustered located on PRIMARY
ind_rankrank, titlenonclustered located on PRIMARY
ind_titletitle, ranknonclustered 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
37case_alst act_entry, case, gbst_elm, user
38fnl_alst act_entry, gbst_elm, probdesc, user
39subcase_al act_entry, gbst_elm, gbst_lst, subcase, user
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
80cas_cmitl case, commit_log, gbst_elm, user
81subc_cmitl commit_log, gbst_elm, subcase, user
82dfe_cmitl commit_log, disptchfe, gbst_elm, user
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
187pinst_alst act_entry, gbst_elm, site_part, user
188location_alst act_entry, gbst_elm, site, user
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
207bug_alst act_entry, bug, gbst_elm, 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
235act_cmitl commit_log, gbst_elm
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
277biz_cal_alst act_entry, biz_cal_hdr, gbst_elm, user
278schedule_alst act_entry, gbst_elm, schedule, user
281appt_schedule appointment, gbst_elm, schedule
293site_svc_appt appointment, gbst_elm, schedule, site, site_part
295assoc_bugs bug, condition, gbst_elm, user
296master_bug bug, condition, gbst_elm, user
301trans_view gbst_elm, gbst_lst, transition
341user_case_load case, condition, gbst_elm, user
355dtl_alst act_entry, demand_dtl, gbst_elm, 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
398rep_bugs bug, condition, gbst_elm, user
409part_inst_alst act_entry, gbst_elm, part_inst, part_trans, 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
4617fc_gen_alst act_entry, gbst_elm, participant, user
4619fc_bug_view bug, bus_org, bus_site_role, case, gbst_elm, mod_level, part_num, probdesc, site, workaround
4621fc_acct_task_view bus_org, condition, gbst_elm, task, user
4624fc_acct_notes_view act_entry, gbst_elm, notes_log, participant, user
4625fc_acct_phone_view act_entry, gbst_elm, participant, phone_log, user
4626fc_acct_email_view act_entry, email_log, gbst_elm, participant, user
4627fc_quote_view bus_org, contact, contract, currency, gbst_elm, 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
5037wipelm_contr condition, contract, gbst_elm, wipbin
5038queelm_contr condition, contract, gbst_elm, queue
5039wipelm_opp condition, gbst_elm, opportunity, wipbin
5042contr_alst act_entry, contract, gbst_elm, user
5044queelm_opp condition, gbst_elm, opportunity, queue
5045opp_alst act_entry, gbst_elm, opportunity, user
5047sub_preview cls_factory, gbst_elm, subcase, user
5050qry_ccn_hdr_view bus_org, condition, contact, contract, gbst_elm, user
5070contact_alst act_entry, contact, gbst_elm, 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
5089task_alst act_entry, gbst_elm, task, user
5144victimcase case, condition, contact, gbst_elm, site
5145supercasev case, condition, contact, gbst_elm, site
5161exch_alst act_entry, exch_log, exchange, gbst_elm, user
5166web_usrcas case, condition, gbst_elm, user
5170qry_scasev case, contact, gbst_elm, site, user
5187task_preview cls_factory, condition, contact, gbst_elm, task, user
5194demand_site demand_dtl, demand_hdr, gbst_elm, mod_level, part_num, site
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
5229lit_req_view gbst_elm, lit_req, user
5231taskempl_view employee, gbst_elm, opportunity, task, user
5232ai2oltsk_apt condition, contact, gbst_elm, task, task_desc, user
5234subc2oltsk contact, gbst_elm, subcase, user
5289gen_alst act_entry, gbst_elm, participant, user
5319wipelm_dlg condition, dialogue, gbst_elm, wipbin
5328act_view act_entry, gbst_elm, user
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
5342sfa_task_v gbst_elm, task, user
5343sfa_quote_v bus_org, contact, contract, currency, gbst_elm, user
5347sfa_target bus_org, currency, frcst_target, gbst_elm, territory, user
5355sfa_stage_v cycle_stage, gbst_elm, gbst_lst, life_cycle, stage_assign
5356sfa_opp_wk_v condition, gbst_elm, opportunity, queue, user, wipbin
5358sfa_tsk_wk_v condition, gbst_elm, queue, task, user, wipbin
5363sfa_pipeline currency, gbst_elm, gbst_lst, opportunity, user
5364subc_alst act_entry, case, gbst_elm, gbst_lst, subcase, user
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
5679subcase_list case, condition, gbst_elm, subcase, user
5680case_list case, condition, contact, gbst_elm, site, user
5681prev_case case, condition, gbst_elm, user
5682probdesc2case case, gbst_elm, probdesc, workaround
5688af_case_list case, condition, gbst_elm, user
5706act_vw act_entry, 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
5848open_script_v gbst_elm, process, user
5957se_session_view dm_analysis, gbst_elm, se_session, user
5958ds_attr_view data_set, gbst_elm, obj_column, struct_lst, structure
5966data_set_view anls_object, data_set, gbst_elm, structure
5968log_view gbst_elm, log, log_line
5969dataset_status_view data_set, gbst_elm, se_session
5970decisiontree_status data_set, gbst_elm, tree_set
5971ruleset_status_view data_set, gbst_elm, rule_set, tree_set
5972model_status_view data_set, gbst_elm, model, rule_set
5974session_status_view dm_analysis, gbst_elm, se_session, user
5975combined_model_view gbst_elm, model, weight
5976dt_attr_view data_set, gbst_elm, obj_column, struct_lst, structure, tree_set
5977dt_calc_attr_view data_set, ds_calc_fld, gbst_elm, struct_lst, structure, tree_set
5979rs_dt_status_view data_set, gbst_elm, rule_set, tree_set
5980rs_ds_status_view data_set, gbst_elm, rule_set
5985ds_clc_attr_view data_set, ds_calc_fld, gbst_elm, struct_lst, structure
5992model_subset_view data_set, eval_graph, gbst_elm, model, se_session, subset, tch_fld_inf
5998eda_attr_cont_view eda, eda_attr, eda_stats, eda_sts_cnt, gbst_elm
5999eda_attr_disc_view eda, eda_attr, gbst_elm
6002ds_se_view data_set, gbst_elm, se_session
6003dt_se_view data_set, gbst_elm, se_session, tree_set
6004rs_dt_se_view data_set, gbst_elm, rule_set, se_session
6005rs_ds_se_view data_set, gbst_elm, rule_set, se_session
6006model_rs_se_view data_set, gbst_elm, model, rule_set, se_session
6007model_ds_se_view data_set, gbst_elm, model, se_session
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
6039eda_context_view data_set, eda, gbst_elm, model, se_session, subset
6042se_scor_exec_log gbst_elm, log, log_line, se_session
6044ds_log_view data_set, gbst_elm, log, log_line, se_session
6045dt_log_view gbst_elm, log, log_line, se_session, tree_set
6046rs_log_view gbst_elm, log, log_line, rule_set, se_session
6047model_log_view gbst_elm, log, log_line, model, se_session
6056eda_attr_discrzed_vw eda, eda_attr, gbst_elm
6057model_rs_list_view data_set, gbst_elm, model, rule_set, se_session
6058model_rs_dt_ds_se_view data_set, gbst_elm, model, rule_set, se_session
6060weight_rule_view anls_rule, gbst_elm, model, weight, weight_set
6061weight_attr_cnt_view gbst_elm, model, weight, weight_set, wgt_att_cnt
6062weight_attr_dsc_view gbst_elm, model, sp_miss_vls, weight, weight_set, wgt_att_dsc
My Recent Objects
gbst_elm      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user