View: GHR_CLAIM_SOURCE_V

Product:	GHR - US Federal Human Resources
Description:	This view is used by the EEOC Claims Form
Implementation/DBA Data:	APPS.GHR_CLAIM_SOURCE_V

View Text

SELECT CMP.EEOC_HEARING_DOCKET_NUM SOURCE
, 'HEARING' TYPE
, CMP.COMPLAINT_ID
FROM GHR_COMPLAINTS2 CMP
WHERE CMP.EEOC_HEARING_DOCKET_NUM IS NOT NULL UNION ALL SELECT APC.DOCKET_NUM SOURCE
, 'APPEAL' TYPE
, APC.COMPLAINT_ID COMPLAINT_ID
FROM GHR_COMPL_APPEALS APC
WHERE APC.DOCKET_NUM IS NOT NULL UNION ALL SELECT 'COMPLAINANT' SOURCE
, 'COMPLAINANT' TYPE
, CMP2.COMPLAINT_ID COMPLAINT_ID
FROM GHR_COMPLAINTS2 CMP2 ORDER BY COMPLAINT_ID

Columns