View Name:fc_group_view
View Number:9885
Group:Process Manager Forecasting
Description:Reads forecast items for a process instance that are associated with a function group
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 instance 
forecast_objidproc_forecastobjidInternal record number of forecast for the process instance 
func_objidfunctionobjidInternal record number of the child function 
func_group_objidfunc_groupobjidObjid of the child function group 
func_group_idfunc_groupidId string of the child group 
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 
iter_expectedfunc_groupiter_expectedExpected iterations for forecasting 
iter_typefunc_groupiterType of iteration - No Iteration, Normal Iteration and Sequential Iteration 
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 
is_milestonefunc_groupis_milestone0 = No, 1 = Completion of this group is a milestone in the process 
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).function2func_group(func_group).func_group2function
(proc_fc_item).fc_item2func_group(func_group).func_group2proc_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_group_view