[Home] [Help]
View: FIIBV_PROJ_TOP_TASK_LCV
| Product: | FII - Financial Intelligence (Obsolete) |
|---|
| Description: | FIIBV_PROJ_TOP_TASK_LCV is the Project Top Task level base view for the Project dimension in EDW |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT T.TASK_ID || '-' || ELI.INSTANCE_CODE
, T.TASK_NAME || '
, ' || PA.SEGMENT1
, T.TASK_NAME
, T.TASK_NUMBER
, T.PROJECT_ID || '-' || ELI.INSTANCE_CODE || '-' || 'PJ'
, ELI.INSTANCE_CODE
, T.START_DATE
, T.COMPLETION_DATE
, T.SERVICE_TYPE_CODE
, T.LABOR_COST_MULTIPLIER_NAME
, T.LAST_UPDATE_DATE
, '_DF:PA:PA_TASKS_DESC_FLEX:T'
FROM PA_TASKS T
, PA_PROJECTS_ALL PA
, EDW_LOCAL_INSTANCE ELI
WHERE T.TASK_ID = T.TOP_TASK_ID
AND T.PROJECT_ID = PA.PROJECT_ID UNION ALL SELECT PA.PROJECT_ID || '-' || ELI.INSTANCE_CODE || '-PJ-PRJ'
, PA.SEGMENT1
, PA.NAME
, PA.SEGMENT1
, PA.PROJECT_ID || '-' || ELI.INSTANCE_CODE || '-PJ'
, ELI.INSTANCE_CODE
, TO_DATE( NULL )
, TO_DATE( NULL )
, TO_CHAR( NULL )
, TO_CHAR( NULL )
, PA.LAST_UPDATE_DATE
, '_DF:_DUMMY:PA:PA_TASKS_DESC_FLEX:T'
FROM PA_PROJECTS_ALL PA
, EDW_LOCAL_INSTANCE ELI UNION ALL SELECT SB.PROJECT_ID || '-' || ELI.INSTANCE_CODE || '-PJ-PRJ'
, SB.PROJECT_NUMBER
, SB.PROJECT_NAME
, SB.PROJECT_NUMBER
, SB.PROJECT_ID || '-' || ELI.INSTANCE_CODE || '-PJ'
, ELI.INSTANCE_CODE
, TO_DATE( NULL )
, TO_DATE( NULL )
, TO_CHAR( NULL )
, TO_CHAR( NULL )
, SB.LAST_UPDATE_DATE
, '_DF:_DUMMY:PA:PA_TASKS_DESC_FLEX:T'
FROM PJM_SEIBAN_NUMBERS SB
, EDW_LOCAL_INSTANCE ELI
Columns
| Name |
| TOP_TASK_PK |
| NAME |
| TOP_TASK |
| TASK_NUMBER |
| PROJECT_FK |
| INSTANCE |
| TASK_START_DATE |
| TASK_END_DATE |
| SERVICE_TYPE_CODE |
| LABOR_COST_MULT |
| LAST_UPDATE_DATE |
| "_DF:TSK:_EDW" |