| Table Name: | proc_fc_item |
| Table Number: | 9769 |
| Group: | Process Manager |
| Description: | Records forecast times for a group instance or an action instance |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| actual_end | CLK_TIME | datetime | Actual end time, copied from relevent instance on completion | Search (4) | ||||
| actual_start | CLK_TIME | datetime | Actual start time, copied from relevent instance on creation | Search (5) | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| fc_end | CLK_TIME | datetime | Forecast end time | Search (4) | ||||
| fc_start | CLK_TIME | datetime | Forecast start time | Search (4) | ||||
| id | CHAR | varchar | 80 | Id from definition or instance - updated at actual end time | Search (1) | |||
| is_milestone | LONG | int | DIRECT, ALLOW_NULL | 0 = No, 1 = Completion of this group is a milestone in the process | Search (1) | |||
| iter_seqno | LONG | int | DIRECT | Sequence number of this sequential iteration group | Search (4) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (4) | ||
| ov_end | CLK_TIME | datetime | Override end time - set by user to reset forecast dates | Search (4) | ||||
| ov_start | CLK_TIME | datetime | Override start time - set by user to reset forecast dates | Search (4) | ||||
| override | LONG | int | DIRECT | 0=ignore override dates, 1 = use override dates | Search (4) | |||
| subproc_owner_func | LONG | int | DIRECT | Function that calls the closest associated subprocess further up the tree | Search (4) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| fc_item2func_group | MTO | func_group | func_group2proc_fc_item | For group forecasts, the related definition | Search (2) | ||
| fc_item2group_inst | OTOP | group_inst | group_inst2proc_fc_item | For group forecasts, the related instanace | |||
| fc_item2fc_item_parent | MTO | proc_fc_item | fc_item2fc_item_children | The related Forecast Item Parent | Search (4) | ||
| fc_item2fc_item_children | OTM | proc_fc_item | fc_item2fc_item_parent | The related Forecast Item Children | |||
| fc_item2proc_forecast | MTO | proc_forecast | fc2proc_fc_item | The related forecast instance | Search (4) | ||
| top2proc_forecast | OTOF | proc_forecast | top2proc_fc_item | The forecast for the top level func group | |||
| fc_item2rqst_inst | OTOP | rqst_inst | rqst_inst2proc_fc_item | For action forecasts, the related instance | |||
| fc_item2svc_rqst | MTO | svc_rqst | svc_rqst2proc_fc_item | For action forecasts, the related definition | Search (2) |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| fi2fg9769 | fc_item2func_group | nonclustered located on PRIMARY |
| fi2sr9769 | fc_item2svc_rqst | nonclustered located on PRIMARY |
| fi3pf9769 | fc_item2proc_forecast | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 9882 | proc_fc_item_view | proc_fc_item, proc_forecast, proc_inst |
| 9885 | fc_group_view | func_group, function, proc_fc_item, proc_forecast, proc_inst |
| 9886 | fc_rqst_view | func_group, function, proc_fc_item, proc_forecast, proc_inst, svc_rqst |
| 9887 | fc_subproc_view | func_group, function, proc_fc_item, proc_forecast, proc_inst, process |
| 9890 | inst_dependent_field | proc_fc_item, svc_fld, svc_rqst |
| proc_fc_item | |||