SELECT I.INCIDENT_ID AS RECORD_ID, I.INC_REPORT_NUMBER AS RECORD_NUMBER, I.SUMMARY, 'INCIDENTS' as RECORD_TYPE, I.START_DATE as RECORD_DATE, A.LATITUDE, A.LONGITUDE, I.AGNCY_CD_AGENCY_CODE AS AGENCY_CODE, AC.AGENCY_DESC, P.MASTER_PERSON_ID, IPR.ROLE_TYPE, RC.ROLE_DESC FROM INCIDENTS I INNER JOIN INCIDENT_ADDRESSES IA ON I.INCIDENT_ID = IA.INCIDENT_ID INNER JOIN ADDRESSES A ON IA.ADDRESS_ID =A.ADDRESS_ID INNER JOIN AGENCY_CODES AC ON I.AGNCY_CD_AGENCY_CODE = AC.AGENCY_CODE INNER JOIN INCIDENT_PEOPLE IP ON I.INCIDENT_ID = IP.INC_INCIDENT_ID INNER JOIN INCIDENT_PERSON_ROLES IPR ON IP.INC_PER_ID = IPR.INC_PER_ID INNER JOIN ROLE_CODES RC ON IPR.ROLE_TYPE = RC.ROLE_TYPE INNER JOIN PEOPLE P ON IP.PER_PERSON_ID = P.PERSON_ID WHERE A.GEOCODED_FLAG = 'Y' UNION SELECT FI.FLDINT_ID AS RECORD_ID, TO_CHAR(FI.FLDINT_ID), FI.SUMMARY, 'FIELDINTERVIEWS' as RECORD_TYPE, FI.FLDINT_DATE as RECORD_DATE, A.LATITUDE, A.LONGITUDE, FI.AGENCY_CODE, AC.AGENCY_DESC, P.MASTER_PERSON_ID, RC.ROLE_TYPE, RC.ROLE_DESC FROM FIELD_INTERVIEWS FI INNER JOIN FLDINT_ADDRESSES FA ON FI.FLDINT_ID = FA.FLDINT_ID INNER JOIN ADDRESSES A ON FA.ADDRESS_ID = A.ADDRESS_ID INNER JOIN AGENCY_CODES AC ON FI.AGENCY_CODE = AC.AGENCY_CODE INNER JOIN FLDINT_PEOPLE FP ON FI.FLDINT_ID = FP.FLDINT_ID INNER JOIN EJS_CODES EC ON FI.FLDINT_TYPE = EC.CODE AND FI.FLDINT_TYPE_TYPE = EC.CODE_TYPE INNER JOIN ROLE_CODES RC ON FP.ROLE_TYPE = RC.ROLE_TYPE INNER JOIN PEOPLE P ON FP.PERSON_ID = P.PERSON_ID WHERE A.GEOCODED_FLAG = 'Y'