[Home] [Help]
View: BSC_SYS_PERIODICITIES_VL
| Product: | BSC - Balanced Scorecard (Obsolete) |
|---|
| Description: | View of BSC_SYS_PERIODICITIES and BSC_SYS_PERIODICITIES_TL. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT B.PERIODICITY_ID
, B.NUM_OF_PERIODS
, B.SOURCE
, B.NUM_OF_SUBPERIODS
, B.PERIOD_COL_NAME
, B.SUBPERIOD_COL_NAME
, B.YEARLY_FLAG
, B.EDW_FLAG
, B.CALENDAR_ID
, B.EDW_PERIODICITY_ID
, B.CUSTOM_CODE
, B.DB_COLUMN_NAME
, B.PERIODICITY_TYPE
, L.MEANING AS NAME
FROM BSC_SYS_PERIODICITIES B
, BSC_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'BSC_PERIODICITY'
AND B.PERIODICITY_TYPE = L.LOOKUP_CODE UNION SELECT B.PERIODICITY_ID
, B.NUM_OF_PERIODS
, B.SOURCE
, B.NUM_OF_SUBPERIODS
, B.PERIOD_COL_NAME
, B.SUBPERIOD_COL_NAME
, B.YEARLY_FLAG
, B.EDW_FLAG
, B.CALENDAR_ID
, B.EDW_PERIODICITY_ID
, B.CUSTOM_CODE
, B.DB_COLUMN_NAME
, B.PERIODICITY_TYPE
, TL.NAME
FROM BSC_SYS_PERIODICITIES B
, BSC_SYS_PERIODICITIES_TL TL
WHERE B.PERIODICITY_ID = TL.PERIODICITY_ID
AND TL.LANGUAGE = USERENV('LANG')
AND (B.EDW_FLAG <> 0 OR B.CUSTOM_CODE <> 0)
Columns
| Name |
| PERIODICITY_ID |
| NUM_OF_PERIODS |
| SOURCE |
| NUM_OF_SUBPERIODS |
| PERIOD_COL_NAME |
| SUBPERIOD_COL_NAME |
| YEARLY_FLAG |
| EDW_FLAG |
| CALENDAR_ID |
| EDW_PERIODICITY_ID |
| CUSTOM_CODE |
| DB_COLUMN_NAME |
| PERIODICITY_TYPE |
| NAME |