[Home] [Help]
View: EDWBV_HR_AGE_AGE_BAND_LCV
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_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
Name |
AGE_BAND_PK |
INSTANCE |
ALL_FK |
NAME |
AGE_BAND_DP |
AGE_MIN |
AGE_MIN_MONTHS |
AGE_MIN_YEARS |
AGE_MAX |
AGE_MAX_MONTHS |
AGE_MAX_YEARS |
LAST_UPDATE_DATE |
CREATION_DATE |