View: EDWBV_HR_AGE_AGE_BAND_LCV

Product:	HRI - Human Resources Intelligence
Description:
Implementation/DBA Data:	APPS.EDWBV_HR_AGE_AGE_BAND_LCV

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ TO_CHAR(BNDS.BAND_MIN_MONTHS) || '-' || NVL(TO_CHAR(BNDS.BAND_MAX_MONTHS)
, 'NA_EDW') || '-' || INST.INSTANCE_CODE AGE_BAND_PK
, INST.INSTANCE_CODE INSTANCE
, 'ALL' ALL_FK
, RTRIM(DECODE(BNDS.BAND_MIN_MONTHS
, 0
, '0 '
, NULL) || DECODE(BNDS.AGE_MIN_YEARS
, 0
, NULL
, 1
, BNDS.AGE_MIN_YEARS || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'Y') || ' '
, BNDS.AGE_MIN_YEARS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'Y') || ' ') || DECODE(BNDS.AGE_MIN_MONTHS
, 0
, NULL
, 1
, BNDS.AGE_MIN_MONTHS || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'M') || ' '
, BNDS.AGE_MIN_MONTHS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'M') || ' ') || ' - ' || DECODE(BNDS.AGE_MAX_YEARS
, TO_NUMBER(NULL)
, NULL
, 0
, NULL
, 1
, BNDS.AGE_MAX_YEARS || ' ' || HR_GENERAL.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_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'M') || ' '
, BNDS.AGE_MAX_MONTHS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'M') || ' ')) NAME
, RTRIM(DECODE(BNDS.BAND_MIN_MONTHS
, 0
, '0 '
, NULL) || DECODE(BNDS.AGE_MIN_YEARS
, 0
, NULL
, 1
, BNDS.AGE_MIN_YEARS || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'Y') || ' '
, BNDS.AGE_MIN_YEARS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'Y') || ' ') || DECODE(BNDS.AGE_MIN_MONTHS
, 0
, NULL
, 1
, BNDS.AGE_MIN_MONTHS || ' ' || HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'M') || ' '
, BNDS.AGE_MIN_MONTHS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'M') || ' ') || ' - ' || DECODE(BNDS.AGE_MAX_YEARS
, TO_NUMBER(NULL)
, NULL
, 0
, NULL
, 1
, BNDS.AGE_MAX_YEARS || ' ' || HR_GENERAL.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_GENERAL.DECODE_LOOKUP('FREQUENCY'
, 'M') || ' '
, BNDS.AGE_MAX_MONTHS || ' ' || HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, 'M') || ' ')) AGE_BAND_DP
, 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
, NVL(BNDS.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY')) LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY') CREATION_DATE
FROM EDW_LOCAL_INSTANCE INST
, (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
, AGB.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM HRI_AGE_BANDS AGB ) BNDS

Columns