SELECT FI.FLDINT_ID, FI.AGENCY_CODE, AC.AGENCY_DESC AS AGENCY_DESC, FI.AGENCY_ONLY_YN AS AGENCY_ONLY, FI.FLDINT_DATE, FI.FLDINT_DATE AS SORT_DATE, FI.FLDINT_TYPE AS FLDINT_TYPE, EC.DESCRIPTION AS FLDINT_TYPE_DESC, FI.INTELL_ONLY_YN AS INTEL_ONLY, FI.NOTE_ID AS NOTE_ID, FI.SECURITY_LEVEL AS SECURITY_LEVEL, (SELECT ISLC.INC_SEC_LEVEL_DESC FROM INCIDENT_SECURITY_LEVEL_CODES ISLC WHERE ISLC.INC_SEC_LEVEL_CODE = FI.SECURITY_LEVEL) AS SECURITY_DESC, FI.SUMMARY AS SUMMARY, CASE WHEN CFI.CASE_ID IS NOT NULL THEN 'Y' ELSE 'N' END AS IS_ASSOCIATED_TO_CASE, B.BUSINESS_NAME AS BUSINESS_NAME, (SELECT ECODE.DESCRIPTION FROM EJS_CODES ECODE WHERE ECODE.CODE_TYPE = B.BTC_TYPE_CODE_TYPE AND ECODE.CODE = B.BTC_TYPE_CODE ) AS BUSINESS_TYPE, B.BTC_TYPE_CODE AS BUSINESS_TYPE_CODE, B.BUSINESS_NUMBER AS BUSINESS_NUM, B.BUSINESS_ID AS BUSINESS_ID FROM FIELD_INTERVIEWS FI INNER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = FI.AGENCY_CODE INNER JOIN EJS_CODES EC ON EC.CODE_TYPE = FI.FLDINT_TYPE_TYPE AND EC.CODE = FI.FLDINT_TYPE INNER JOIN FLDINT_BUSINESSES FB ON FB.FLDINT_ID = FI.FLDINT_ID INNER JOIN BUSINESSES B ON B.BUSINESS_NUMBER = FB.BUSINESS_NUMBER LEFT OUTER JOIN CASE_FIELD_INTS CFI ON CFI.FLDINT_ID = FI.FLDINT_ID