[Home] [Help]
View: FIIBV_PROJ_CLS1_LCV
| Product: | FII - Financial Intelligence (Obsolete) |
|---|
| Description: | FIIBV_PROJ_CLS1_LCV is the Class 1 base view for the Project dimension in EDW |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT CLASS_CODE || '-' || ELI.INSTANCE_CODE
, CLASS_CODE
, CLASS_CODE
, CLASS_CATEGORY || '-' || ELI.INSTANCE_CODE
, ELI.INSTANCE_CODE
, CL.LAST_UPDATE_DATE
, '_DF:PA:PA_CLASS_CODES_DESC_FLEX:CL'
FROM PA_CLASS_CODES CL
, EDW_LOCAL_SYSTEM_PARAMETERS CT
, EDW_LOCAL_INSTANCE ELI
WHERE CL.CLASS_CATEGORY = CT.CLASS_CATEG1
Columns
| Name |
| PROJ_CLS1_PK |
| NAME |
| PROJECT_CLASS1 |
| PROJ_CATEG1_FK |
| INSTANCE |
| LAST_UPDATE_DATE |
| "_DF:PCL:_EDW" |