View Name:com_to_template_view
View Number:234
Group:Policy Mgr
Description:Joins employee and com_template information for use in notifications and escalations
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_com_to_template_view
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
employee_idemployeeobjidEmployee internal record number 
com_templ_idcom_tmplteobjidCom_tmplte internal record number 
commitment_idtime_bombobjidTime bomb internal record number 3 (UNIQUE)
titletime_bombtitleTitle of the time bomb 
timetime_bombescalate_timeElapsed time until the time bomb is scheduled to fire in seconds 
focus_lowidtime_bombfocus_lowidLow ID of the time bomb's focus object 
focus_typetime_bombfocus_typeObject type of the time bomb's focus object 
suppl_infotime_bombsuppl_infoAdditional information for the time bomb 

Joins:

Join FromJoin To
(time_bomb).trckr_info2com_tmplte(com_tmplte).escal_msg2time_bomb
(time_bomb).cmit_creator2employee(employee).emp_cmits2time_bomb
My Recent Objects
com_to_template_view      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user