View Definition:
SELECT i.incident_id,
i.inc_report_number,
i.report_date,
i.report_time,
i.start_date,
i.end_date,
i.summary "INCIDENT_SUMMARY",
i.dispatch_date,
i.onscene_date,
i.clear_date,
i.inc_disp_code,
i.agncy_cd_agency_code "INC_AGENCY_CODE",
isupp.supp_seq,
isupp.isc_status_code,
isupp.supp_report_date,
isupp.supp_report_time,
isupp.responsible_user_id,
isupp.approval_date,
isupp.approval_user_id,
isupp.supp_agency_code,
isupp.security_level,
isupp.unk_no_offenders,
isupp.supervisor_note,
offs.offense_number,
offs.arrest_charge_code,
offs.place_place_code "PLACE_CODE",
offs.offnse_cd_offense_status_code "OFFENSE_STATUS_CODE",
offs.fec_forced_entry_code,
offs.premises,
offs.remarks,
offs.campus_code,
offs.charge_code,
offs.bias_code,
offs.ac_code,
offs.offns_cd_offense_code "OFFENSE_CODE",
oc.offense_desc,
nc.nibrs_code,
nc.nibrs_desc,
nc.offense_group_code,
nct.crime_against_code,
offr.officer_id,
offr.agncy_cd_agency_code "OFFICER_AGENCY_CODE",
offr.lname,
offr.fname,
offr.mname,
TRIM( offr.fname
|| ' '
|| DECODE (offr.mname, NULL, '', ' ')
|| offr.lname)
"OFFICER_NAME_FML",
TRIM (offr.lname || ', ' || fname || ' ' || offr.mname)
"OFFICER_NAME_LFM",
offr.internal_id,
offr.user_id,
orc.role_code,
orc.role_desc,
addr.address_id,
addr.street_number,
addr.dirct_cd_direction_code "DIRECTION_CODE",
addr.street_name,
addr.street_cd_street_type_code "STREET_TYPE_CODE",
addr.direct_suffix,
addr.addr_sc_address_subtype_code "ADDRESS_SUBTYPE_CODE",
addr.sub_number,
addr.city,
addr.state_cd_state_code "STATE_CODE",
addr.zip5,
addr.zip4,
addr.longitude,
addr.latitude,
ia.beat,
ia.sub_beat
FROM incident_addresses ia,
incident_supplements isupp,
incidents i,
nibrs_codes nc,
nibrs_crime_targets nct,
nibrs_offenses noff,
offense_codes oc,
offenses offs,
officer_incidents oi,
officer_role_codes orc,
officers offr,
addresses addr
WHERE ( (ia.incident_id = i.incident_id)
AND (isupp.inc_incident_id = i.incident_id)
AND (nct.nibrs_code = nc.nibrs_code)
AND (noff.nibrs_code = nc.nibrs_code)
AND (noff.offense_code = oc.offense_code)
AND (offs.inc_incident_id = i.incident_id)
AND (offs.offns_cd_offense_code = oc.offense_code)
AND (oi.supp_seq = isupp.supp_seq
AND oi.inc_incident_id = isupp.inc_incident_id)
AND (oi.orc_role_code = orc.role_code)
AND (oi.off1_officer_id = offr.officer_id)
AND (ia.address_id = addr.address_id))
