On this page you will find the specifications regarding the Model: Project and Dimension Table: PROJ FCST CONN CCO.
This model dimension represents connected change order information in Project Budgeting and Forecasting based on the IFS Cloud dimension DIM_PROJ_FCST_CONN_CCO. All models that refers to this dimension will have the attributes and hierarchies as described below.
| Attribute | Description (where applicable) |
| Change Order State | Change Order State |
| Connection Type | Connection Type |
| Forecast Connected Change Order | Key. Displayed as PROJECT_ID + ' - ' + cast(FORECAST_ID as nvarchar) + ' - ' + CHANGE_OBJECT_ID + ' - ' + CHANGE_OBJECT_NAME |
| Forecast Connected Change Order Code | Change Object identity (CHANGE_OBJECT_ID) |
| Forecast Connected Change Order Name | Change Object name (CHANGE_OBJECT_NAME) |
| Forecast Id | Forecast identity |
| Project Id | Project identity |
| Sales Contract No | Sales Contract No |
| Sub Contract No | Sub Contract No |
| Model Name |
| Project |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| PROJ FCST CONN CCO | DIM_PROJ_FCST_CONN_CCO_TM | DIM_PROJ_FCST_CONN_CCO_BI | DIM_PROJ_FCST_CONN_CCO | On Line |