SELECT CC.ID AS COURT_CASE_ID, CC.CASE_NUMBER AS CASE_NUMBER, CASE_AGENCY.AGENCY_CODE AS AGENCY_CODE, CASE_AGENCY.AGENCY_DESC AS AGENCY_DESC, CC.FILED_DATE AS FILED_DATE, STATUS.CODE AS STATUS_CODE, STATUS.CODE_TYPE AS STATUS_CODE_TYPE, STATUS.DESCRIPTION AS STATUS_DESC, CC.COMMENTS AS COMMENTS, CC.CREATOR_ID AS CREATOR_ID, CC.CREATOR_DATE AS CREATOR_DATE, CC.UPDATOR_ID AS UPDATOR_ID, CC.UPDATOR_DATE AS UPDATOR_DATE, INCS.INCIDENT_ID AS INCIDENT_ID, INCS.INC_REPORT_NUMBER AS INC_REPORT_NUM, ARR.ARREST_ID AS ARREST_ID, ARR.ARREST_NUM AS ARREST_NUM, CMP.ID AS COMPLAINT_ID, CMP.CRIMINAL_COMPLAINT_NUM AS COMPLAINT_NUM, NAMES.PER_PERSON_ID AS PERSON_ID, MP.INDX_SEC_LEVEL_CODE, NAMES.FNAME AS PERSON_FNAME, NAMES.MNAME AS PERSON_MNAME, NAMES.LNAME AS PERSON_LNAME, PR.CODE AS PERSON_ROLE_CODE, PR.CODE_TYPE AS PERSON_ROLE_CODE_TYPE, PR.DESCRIPTION AS PERSON_ROLE_DESC, OFFS.OFFICER_ID AS OFFICER_ID, OFFS.FNAME AS OFFICER_FNAME, OFFS.MNAME AS OFFICER_MNAME, OFFS.LNAME AS OFFICER_LNAME, OFFS.INTERNAL_ID AS OFFICER_INTERNAL_ID FROM COURT_CASES CC LEFT OUTER JOIN AGENCY_CODES CASE_AGENCY ON CASE_AGENCY.AGENCY_CODE = CC.AGENCY_CODE LEFT OUTER JOIN EJS_CODES STATUS ON STATUS.CODE_TYPE = CC.STATUS_CODE_TYPE AND STATUS.CODE = CC.STATUS_CODE LEFT OUTER JOIN COURT_CASE_INCS CCI ON CCI.COURT_CASE_ID = CC.ID LEFT OUTER JOIN INCIDENTS INCS ON INCS.INCIDENT_ID = CCI.INC_INCIDENT_ID LEFT OUTER JOIN COURT_CASE_ARRESTS CCA ON CCA.COURT_CASE_ID = CC.ID LEFT OUTER JOIN ARRESTS ARR ON ARR.ARREST_ID = CCA.ARR_ARREST_ID LEFT OUTER JOIN COURT_CASE_COMPLAINTS CCC ON CCC.COURT_CASE_ID = CC.ID LEFT OUTER JOIN CRIMINAL_COMPLAINTS CMP ON CMP.ID = CCC.COMPLAINT_ID LEFT OUTER JOIN COURT_CASE_PEOPLE CCP ON CCP.COURT_CASE_ID = CC.ID LEFT OUTER JOIN EJS_CODES PR ON PR.CODE_TYPE = CCP.PERSON_ROLE_CODE_TYPE AND PR.CODE = CCP.PERSON_ROLE_CODE LEFT OUTER JOIN MASTER_NAMES NAMES ON NAMES.PER_PERSON_ID = CCP.PER_PERSON_ID AND NAMES.NAME_TYPE_CODE = 'P' LEFT OUTER JOIN PEOPLE P ON NAMES.PER_PERSON_ID = P.PERSON_ID LEFT OUTER JOIN MASTER_PEOPLE MP ON P.MASTER_PERSON_ID = MP.MASTER_PERSON_ID LEFT OUTER JOIN COURT_CASE_OFFS CCO ON CCO.COURT_CASE_ID = CC.ID LEFT OUTER JOIN OFFICERS OFFS ON OFFS.OFFICER_ID = CCO.OFFICER_ID