[Home] [Help]
View: EDW_HR_AGE_BAND_FKV
Product: | HRI - Human Resources Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ TO_CHAR(BNDS.BAND_MIN_TOTAL_MONTHS) || '-' || NVL(TO_CHAR(BNDS.BAND_MAX_TOTAL_MONTHS)
, 'NA_EDW') || '-' || INST.INSTANCE_CODE AGE_BAND_PK
, BNDS.BAND_MAX_TOTAL_MONTHS AGE_MAX
, BNDS.BAND_MIN_TOTAL_MONTHS AGE_MIN
FROM EDW_LOCAL_INSTANCE INST
, HRI_AGE_BANDS BNDS
Columns
Name |
AGE_BAND_PK |
AGE_MAX |
AGE_MIN |