View Name:fc_rqst_view
View Number:9886
Group:Process Manager Forecasting
Description:Reads forecast items for a process instance that are associated with an action (service request)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
parent_group_objidparent_group(func_group)objidInternal record number of parent func_group 
parent_group_idparent_group(func_group)idId string of parent group 
proc_inst_objidproc_instobjidInternal record number of owning process instabce 
forecast_objidproc_forecastobjidInternal record number of forecast for the process instance 
func_objidfunctionobjidInternal record number of the child function 
svc_rqst_objidsvc_rqstobjidInternal record number of service request 
svc_rqst_idsvc_rqstidFunction ID 
durationsvc_rqstdurationMaximum duration (number of seconds before timeout) 
objidproc_fc_itemobjidInternal record number of the forecast item 3 (UNIQUE)
planned_startproc_fc_itemfc_startForecast start time 
planned_endproc_fc_itemfc_endForecast end time 
overrideproc_fc_itemoverride0=ignore override dates, 1 = use override dates 
ov_startproc_fc_itemov_startOverride start time - set by user to reset forecast dates 
ov_endproc_fc_itemov_endOverride end time - set by user to reset forecast dates 
seqnofunctionseqnoSequence number for serial functions 
parent_group_typeparent_group(func_group)typeGroup type of the parent - 1=Serial, 2=Parallel, 3=Conditional 
cond_expectedfunctioncond_expectedIndicates which function is used for forecasting when parent = conditional 
iter_seqnoproc_fc_itemiter_seqnoIteration sequence no of the Group 
actual_startproc_fc_itemactual_startActual start time from proc_fc_item 
actual_endproc_fc_itemactual_endActual end time from proc_fc_item 
use_elapsedsvc_rqstuse_elapsedFor forecasting - 0=use calendar if set, 1=use elapsed time/24 hour calendar 
subproc_owner_funcproc_fc_itemsubproc_owner_funcFunction that calls the closest associated subprocess further up the tree 
parent_fc_item_objidparent_fc_item(proc_fc_item)objidParent Forecast Item Objid 

Joins:

Join FromJoin To
(function).belongs2func_groupparent_group(func_group).contains2function
(function).function2svc_rqst(svc_rqst).svc_rqst2function
(proc_fc_item).fc_item2svc_rqst(svc_rqst).svc_rqst2proc_fc_item
(proc_fc_item).fc_item2proc_forecast(proc_forecast).fc2proc_fc_item
(proc_forecast).fc2proc_inst(proc_inst).proc_inst2proc_forecast
(proc_fc_item).fc_item2fc_item_parentparent_fc_item(proc_fc_item).fc_item2fc_item_children
My Recent Objects
fc_rqst_view