View: GHR_BREAKDOWN_V

Product:	GHR - US Federal Human Resources
Description:	This view is used by Break Down form.
Implementation/DBA Data:	APPS.GHR_BREAKDOWN_V

View Text

SELECT BREAKDOWN_CRITERIA_ID
, FOR_CLAUSE
, WITHIN_CLAUSE
, BY_CLAUSE
, LINE
, COUNT(DECODE(LINE
, '#'
, 1
, NULL)) TOTAL_ALL
, COUNT(DECODE(RSLT.SEX
, 'F'
, 1
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) TOTAL_WOMEN
, COUNT( DECODE(RSLT.SEX
, 'M'
, 1
, NULL)) / DECODE( LINE
, '#'
, 1
, COUNT(*) / 100 ) TOTAL_MEN
, COUNT(DECODE(RSLT.SEX
, 'F'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'E'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) WHITE_WOMEN
, COUNT(DECODE(RSLT.SEX
, 'M'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'E'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) WHITE_MEN
, COUNT(DECODE(RSLT.SEX
, 'F'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'C'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) BLACK_WOMEN
, COUNT(DECODE(RSLT.SEX
, 'M'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'C'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) BLACK_MEN
, COUNT(DECODE(RSLT.SEX
, 'F'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'D'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) HISPANIC_WOMEN
, COUNT(DECODE(RSLT.SEX
, 'M'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'D'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) HISPANIC_MEN
, COUNT(DECODE(RSLT.SEX
, 'F'
, DECODE(INSTR('BFGHIJKLMNPQ'
, NVL(RSLT.ETHNIC_ORIGIN
, '*'))
, 0
, NULL
, 1)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) PAC_ISLANDER_WOMEN
, COUNT(DECODE(RSLT.SEX
, 'M'
, DECODE(INSTR('BFGHIJKLMNPQ'
, NVL(RSLT.ETHNIC_ORIGIN
, '*'))
, 0
, NULL
, 1)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) PAC_ISLANDER_MEN
, COUNT(DECODE(RSLT.SEX
, 'F'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'A'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) AMERINDIAN_ALASKAN_WOMEN
, COUNT(DECODE(RSLT.SEX
, 'M'
, DECODE(RSLT.ETHNIC_ORIGIN
, 'A'
, 1
, NULL)
, NULL)) / DECODE(LINE
, '#'
, 1
, COUNT(*) / 100) AMERINDIAN_ALASKAN_MEN
FROM GHR_BREAKDOWN_RESULTS RSLT
, (SELECT '#' LINE
FROM DUAL UNION SELECT '%' LINE
FROM DUAL)
WHERE RSLT.SESSION_ID = USERENV('SESSIONID') GROUP BY BREAKDOWN_CRITERIA_ID
, FOR_CLAUSE
, WITHIN_CLAUSE
, BY_CLAUSE
, LINE

Columns