[Home] [Help]
View: BIC_STANDARD_VALUES_V
| Product: | BIC - Customer Intelligence (obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT S.MEASURE_CODE
, S.PERIOD_START_DATE
, S.STD_VALUE
, M.NAME MEASURE_NAME
, M.DESCRIPTION MEASURE_DESCRIPTION
, T.ACT_PERIOD_NAME
, T.START_DATE
, T.ACT_PERIOD_START_DATE
, T.ACT_PERIOD_END_DATE
, T.ACT_YEAR
, T.ACT_PERIOD_NUM
, T.ACT_QUARTER
, T.ACT_HALF_YEAR
, T.ACT_YEAR_START_DATE
, T.ACT_QUARTER_START_DATE
FROM BIC_STANDARD_VALUES S
, BIC_MEASURES_ALL M
, BIC_DIMV_TIME T
WHERE S.MEASURE_CODE = M.MEASURE_CODE
AND S.PERIOD_START_DATE = T.START_DATE WITH READ ONLY
Columns
| Name |
| MEASURE_CODE |
| PERIOD_START_DATE |
| STD_VALUE |
| MEASURE_NAME |
| MEASURE_DESCRIPTION |
| ACT_PERIOD_NAME |
| START_DATE |
| ACT_PERIOD_START_DATE |
| ACT_PERIOD_END_DATE |
| ACT_YEAR |
| ACT_PERIOD_NUM |
| ACT_QUARTER |
| ACT_HALF_YEAR |
| ACT_YEAR_START_DATE |
| ACT_QUARTER_START_DATE |