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, V.YEAR AS YEAR, (SELECT VMAK.VEHICLE_MAKE_DESC FROM VEHICLE_MAKES VMAK WHERE VMAK.VEHICLE_MAKE_CODE = V.VMA_VEHICLE_MAKE_CODE) AS MAKE, V.VMA_VEHICLE_MAKE_CODE AS MAKE_CODE, (SELECT VMOD.VEHICLE_MODEL_DESC FROM VEHICLE_MODELS VMOD WHERE VMOD.VMA_VEHICLE_MAKE_CODE = V.VMA_VEHICLE_MAKE_CODE AND VMOD.VEHICLE_MODEL_CODE = V.VMO_VEHICLE_MODEL_CODE) AS MODEL, V.VMO_VEHICLE_MODEL_CODE AS MODEL_CODE, V.VIN AS VIN, VDS.LIC_NUMBER AS LICENSE, FIL.VEHICLE_ID AS VEHICLE_ID, (SELECT ECOD.DESCRIPTION FROM EJS_CODES ECOD WHERE ECOD.CODE_TYPE = FIL.ROLE_CODE_TYPE AND ECOD.CODE = FIL.ROLE_CODE) AS ROLE, FIL.ROLE_CODE 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_VEHICLES FIL ON FIL.FLDINT_ID = FI.FLDINT_ID INNER JOIN VEHICLES V ON V.VEHICLE_ID = FIL.VEHICLE_ID INNER JOIN VEHICLE_DESCRIPTIONS VDS ON VDS.VEHICLE_ID = FIL.VEHICLE_ID LEFT OUTER JOIN CASE_FIELD_INTS CFI ON CFI.FLDINT_ID = FI.FLDINT_ID