[Home] [Help]
View: HRI_CL_AGE_BAND_X_V
View Text
SELECT TO_CHAR(BNDS.BAND_MIN_MONTHS) || '-' || NVL(TO_CHAR(BNDS.BAND_MAX_MONTHS)
, 'NA_EDW') ID
, RTRIM(DECODE(BNDS.BAND_MIN_MONTHS
, 0
, '0 '
, NULL) || DECODE(BNDS.AGE_MIN_YEARS
, 0
, NULL
, 1
, BNDS.AGE_MIN_YEARS || ' ' || HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, 'Y') || ' '
, BNDS.AGE_MIN_YEARS || ' ' || HR_BIS.BIS_DECODE_LOOKUP('QUALIFYING_UNITS'
, 'Y') || ' ') || DECODE(BNDS.AGE_MIN_MONTHS
, 0
, NULL
, 1
, BNDS.AGE_MIN_MONTHS || ' ' || HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, 'CM') || ' '
, BNDS.AGE_MIN_MONTHS || ' ' || HR_BIS.BIS_DECODE_LOOKUP('QUALIFYING_UNITS'
, 'M') || ' ') || ' - ' || DECODE(BNDS.AGE_MAX_YEARS
, TO_NUMBER(NULL)
, NULL
, 0
, NULL
, 1
, BNDS.AGE_MAX_YEARS || ' ' || HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, 'Y') || ' '
, BNDS.AGE_MAX_YEARS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'Y') || ' ') || DECODE(BNDS.AGE_MAX_MONTHS
, TO_NUMBER(NULL)
, NULL
, 0
, NULL
, 1
, BNDS.AGE_MAX_MONTHS || ' ' || HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, 'CM') || ' '
, BNDS.AGE_MAX_MONTHS || ' ' || HR_BIS.BIS_DECODE_LOOKUP('QUALIFYING_UNITS'
, 'M') || ' ')) VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, HR_GENERAL.END_OF_TIME DATE_TO
, BNDS.BAND_MIN_MONTHS AGE_MIN
, BNDS.AGE_MIN_MONTHS AGE_MIN_MONTHS
, BNDS.AGE_MIN_YEARS AGE_MIN_YEARS
, BNDS.BAND_MAX_MONTHS AGE_MAX
, BNDS.AGE_MAX_MONTHS AGE_MAX_MONTHS
, BNDS.AGE_MAX_YEARS AGE_MAX_YEARS
, BNDS.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM (SELECT FLOOR(AGB.BAND_MIN_TOTAL_MONTHS/12) AGE_MIN_YEARS
, MOD(AGB.BAND_MIN_TOTAL_MONTHS
, 12) AGE_MIN_MONTHS
, FLOOR(AGB.BAND_MAX_TOTAL_MONTHS/12) AGE_MAX_YEARS
, MOD(AGB.BAND_MAX_TOTAL_MONTHS
, 12) AGE_MAX_MONTHS
, AGB.BAND_MIN_TOTAL_MONTHS BAND_MIN_MONTHS
, AGB.BAND_MAX_TOTAL_MONTHS BAND_MAX_MONTHS
, ROUND(AGB.BAND_MIN_TOTAL_MONTHS*365/12) BAND_MIN_DAYS
, ROUND(AGB.BAND_MAX_TOTAL_MONTHS*365/12) BAND_MAX_DAYS
, AGB.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM HRI_AGE_BANDS AGB ) BNDS WITH READ ONLY
Columns
Name |
ID |
VALUE |
DATE_FROM |
DATE_TO |
AGE_MIN |
AGE_MIN_MONTHS |
AGE_MIN_YEARS |
AGE_MAX |
AGE_MAX_MONTHS |
AGE_MAX_YEARS |
LAST_UPDATE_DATE |