Model: Cash Planning - Specifications for Dimension Table: PROJECT ACTIVITY
Attributes
| Attribute |
Description (where applicable) |
| Activity Code |
Represents the Activity Code |
| Activity Descr |
Represents the Activity Description |
| Activity No |
Represents the Activity Number |
| Activity Responsible |
Represents the Activity Responsible |
| Activity ShortName |
Represents the Activity Short Name |
| Activity Status |
Represents the Activity Status |
| ID |
Project activity ID |
| SubprojectKey |
Sub Project ID |
USED BY MODEL(S)
Data source Information
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 |
| PROJECT ACTIVITY |
DIM_ACTIVITY_TM |
DIM_ACTIVITY_BI |
DIM_ACTIVITY |
On Line |