View slot9.WORLD.TSTA.TDEX_RMS_INCIDENT_VW
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
HEADER char 2  √  null
ACTION varchar2 0  √  null
LABEL varchar2 0  √  null
UPDATE_DATE date 7  √  null
UPDATE_TIME varchar2 4  √  null
AGENCY varchar2 9  √  null
INCIDENT_NUMBER varchar2 20
CASE_NUMBER varchar2 20  √  null
CASE_AGENCY_ORI varchar2 9  √  null
REPORT_DATE_TIME varchar2 15  √  null
OCCURRED_FROM_DATE_TIME varchar2 15  √  null
OCCURRED_TO_DATE_TIME varchar2 15  √  null
INCIDENT_STATUS varchar2 30
INCIDENT_AGENCY_STATUS varchar2 0  √  null
INCIDENT_AGENCY_DISPOSITION varchar2 0  √  null
EXCEPTIONAL_CLEARANCE varchar2 0  √  null
REPORTING_AGENCY_ORI varchar2 9  √  null
REPORTING_AGENCY_NAME varchar2 40  √  null
INCIDENT_LOCATION varchar2 80  √  null
INCIDENT_ADDRESS varchar2 50  √  null
INCIDENT_ADDRESS_CITY varchar2 40  √  null
INCIDENT_ADDRESS_STATE varchar2 30  √  null
INCIDENT_ADDRESS_ZIP_CODE varchar2 12  √  null
GPS_LONGITUDE varchar2 30  √  null
GPS_LATITUDE varchar2 30  √  null
OFFENSE_TRACT varchar2 0  √  null
DOMESTIC_INCIDENT_INDICATOR varchar2 1  √  null
EVIDENCE_INDICATOR varchar2 0  √  null
INCIDENT_FACTOR varchar2 0  √  null
INCIDENT_TYPE varchar2 30  √  null
INCIDENT_DESCRIPTION varchar2 255  √  null
INCIDENT_SYSTEM_NUMBER number 0
COURT_CASE_AGENCY_NAME varchar2 0  √  null
COURT_CASE_AGENCY_STATE varchar2 0  √  null
METHOD_OF_DESCRIPTION varchar2 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT DISTINCT 'IN' HEADER, NULL ACTION, NULL LABEL, isup.updator_date UPDATE_DATE, TO_CHAR (isup.updator_date, 'HH24MI') UPDATE_TIME, ac1.ori_number AGENCY, inc.inc_report_number INCIDENT_NUMBER, --ic.inc_case_number CASE_NUMBER, --19237 --ac1.ori_number CASE_AGENCY_ORI, --19237 (SELECT inc_case_number FROM incident_cases ic2, inc_case_incidents ici2 WHERE ic2.inc_case_id = ici2.inc_case_id AND ici2.incident_id = isup.inc_incident_id AND ici2.supp_seq = isup.supp_seq AND ROWNUM = 1) CASE_NUMBER, --19237 (SELECT ori_number FROM agency_codes ac2, incident_cases ic2, inc_case_incidents ici3 WHERE ac2.agency_code = ic2.agency_code AND ici3.incident_id = isup.inc_incident_id AND ici3.supp_seq = isup.supp_seq AND ic2.inc_case_id = ici3.inc_case_id AND ROWNUM = 1) CASE_AGENCY_ORI, --19237 TO_CHAR (isup.supp_report_date, 'MM/DD/YYYY HH24MI') REPORT_DATE_TIME, TO_CHAR (inc.start_date, 'MM/DD/YYYY') || ' ' || TO_CHAR (inc.start_time, 'HH24MI') OCCURRED_FROM_DATE_TIME, TO_CHAR (inc.end_date, 'MM/DD/YYYY') || ' ' || TO_CHAR (inc.end_time, 'HH24MI') OCCURRED_TO_DATE_TIME, isup.isc_status_code INCIDENT_STATUS, NULL INCIDENT_AGENCY_STATUS, NULL INCIDENT_AGENCY_DISPOSITION, NULL EXCEPTION_CLEARANCE, ac1.ori_number REPORTING_AGENCY_ORI, ac1.agency_desc REPORTING_AGENCY_NAME, acn.common_place_name INCIDENT_LOCATION, SUBSTRB (ejs_addresses.full_street_summary (addr.address_id), 1, 50) INCIDENT_ADDRESS, addr.city INCIDENT_ADDRESS_CITY, addr.state_cd_state_code INCIDENT_ADDRESS_STATE, SUBSTRB (addr.zip5 || '-' || addr.zip4, 1, 12) INCIDENT_ADDRESS_ZIP_CODE, addr.longitude GPS_LONGITUDE, addr.latitude GPS_LATITUDE, NULL OFFENSE_TRACT, NVL (isup.notify_dv, 'N') DOMESTIC_INCIDENT_INDICATOR, NULL EVIDENCE_INDICATOR, NULL INCIDENT_FACTOR, --inc.itc_code INCIDENT_TYPE, --18230 it.itc_code INCIDENT_TYPE, --18230 --substrb(inc.summary,1,255) INCIDENT_DESCRIPTION, SUBSTRB (REPLACE (REPLACE (inc.summary, CHR (13)), CHR (10)), 1, 255) INCIDENT_DESCRIPTION, inc.incident_id INCIDENT_SYSTEM_NUMBER, NULL COURT_CASE_AGENCY_NAME, NULL COURT_CASE_AGENCY_STATE, NULL METHOD_OF_DESCRIPTION FROM incident_supplements isup, incidents inc, incident_types it, --18230 --inc_case_incidents ici, --19237 --incident_cases ic, --19237 agency_codes ac1, incident_addresses ia, addresses addr, address_common_names acn WHERE inc.incident_id = it.incident_id(+) --18230 AND inc.incident_id = isup.inc_incident_id --AND ici.incident_id(+) = isup.inc_incident_id --19237 --AND ici.supp_seq(+) = isup.supp_seq --19237 --AND ic.inc_case_id = ici.inc_case_id --19237 --AND ac1.agency_code = ic.agency_code --19237 AND ac1.agency_code = inc.agncy_cd_agency_code AND ia.incident_id(+) = isup.inc_incident_id AND addr.address_id = ia.address_id AND acn.addr_address_id(+) = ia.address_id AND isup.isc_status_code = 'A'
 
Possibly Referenced Tables/Views:
ADDRESS_COMMON_NAMES ADDRESSES AGENCY_CODES INC_CASE_INCIDENTS INCIDENT_ADDRESSES INCIDENT_CASES INCIDENT_SUPPLEMENTS INCIDENT_TYPES INCIDENTS