View slot9.WORLD.TSTA.INCIDENT_ADDRESS_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
INCIDENT_ID number 0  √  null
INCIDENTS.INCIDENT_ID Implied Constraint R
INC_REPORT_NUMBER varchar2 20  √  null
AGNCY_CD_AGENCY_CODE varchar2 30  √  null
REPORT_DATE date 7  √  null
START_DATE date 7  √  null
END_DATE date 7  √  null
STATUS varchar2 30  √  null
STATUS_TYPE varchar2 30  √  null
SUPP_SEQ number 0  √  null
RESPONSIBLE_USER_ID varchar2 100  √  null
AGENCY_ONLY varchar2 1  √  null
CID varchar2 1  √  null
SECURITY_LEVEL number 38  √  null
SUMMARY varchar2 1000  √  null
ADDRESS_ID number 0  √  null
ADDRESSES.ADDRESS_ID Implied Constraint R
STREET_NUMBER varchar2 10  √  null
DIRCT_CD_DIRECTION_CODE varchar2 30  √  null
DIRCT_CD_DIRECTION_CODE_TYPE varchar2 30  √  null
DIRCT_DESC varchar2 4000  √  null
STREET_NAME varchar2 40  √  null
STREET_CD_STREET_TYPE_CODE_COD varchar2 30  √  null
STREET_TYPE_CODE_TYPE varchar2 30  √  null
STREET_TYPE_DESC varchar2 4000  √  null
ADDR_SC_ADDRESS_SUBTYPE_CODE varchar2 30  √  null
SUB_NUMBER varchar2 50  √  null
INTRSECT1_STREET_NUMBER varchar2 10  √  null
INTRSECT1_DIR varchar2 30  √  null
INTRSECT1_NAME varchar2 40  √  null
INTRSECT1_STREET_TYPE_CODE varchar2 30  √  null
INTRSECT1_DIR_SUFFIX varchar2 30  √  null
ADDITIONAL_INFO varchar2 255  √  null
BEAT varchar2 30  √  null
SUB_BEAT varchar2 30  √  null
LONGITUDE varchar2 30  √  null
LATITUDE varchar2 30  √  null
CITY varchar2 40  √  null
GEO_CITY varchar2 40  √  null
STATE_CD_STATE_CODE varchar2 30  √  null
ZIP5 varchar2 30  √  null
ZIP4 number 0  √  null
DIRECT_SUFFIX varchar2 30  √  null
INTERNAL_INCIDENT varchar2 1  √  null
COMMON_PLACE_NAME varchar2 80  √  null
COUNTY_OF_OCCURRENCE_CODE varchar2 30  √  null
COUNTY_OF_OCCURRENCE_DESC varchar2 4000  √  null
LOC_AGENCY_CODE varchar2 30  √  null
APPROVING_AGENCY_CODE varchar2 30  √  null
APPROVAL_DATE date 7  √  null
LOC_TYPE_CODE varchar2 30  √  null
LOC_TYPE_DESC varchar2 4000  √  null
INC_DISP_CODE varchar2 30  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT DISTINCT i.incident_id, i.inc_report_number, isupp.supp_agency_code "AGNCY_CD_AGENCY_CODE", i.report_date, i.start_date, i.end_date, isupp.isc_status_code "STATUS", isupp.isc_status_code_type, isupp.supp_seq, isupp.responsible_user_id, isupp.agency_only, isupp.cid, isupp.security_level, i.summary, a.address_id, a.street_number, a.dirct_cd_direction_code, a.dirct_cd_direction_code_type, (SELECT EDR.DESCRIPTION FROM EJS_CODES EDR WHERE EDR.CODE_TYPE = A.DIRCT_CD_DIRECTION_CODE_TYPE AND EDR.Code = A.DIRCT_CD_DIRECTION_CODE), a.street_name, a.street_cd_street_type_code, a.street_cd_street_type_cod_type, (SELECT EST.DESCRIPTION FROM EJS_CODES EST WHERE EST.CODE_TYPE = A.STREET_CD_STREET_TYPE_COD_TYPE AND EST.CODE = A.STREET_CD_STREET_TYPE_CODE), a.addr_sc_address_subtype_code, a.sub_number, a.intrsect1_street_number, a.intrsect1_dir, a.intrsect1_name, a.intrsect1_street_type_code, a.intrsect1_dir_suffix, ia.inc_addr_comment, a.beat, a.sub_beat, a.longitude, a.latitude, initcap(a.city), initcap(a.geo_city), a.state_cd_state_code, a.zip5, a.zip4, a.direct_suffix, i.internal_incident, acn.common_place_name, IA.COUNTY_CODE AS COUNTY_OF_OCCURRENCE_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = IA.COUNTY_CODE_TYPE AND EC.CODE = IA.COUNTY_CODE) AS COUNTY_OF_OCCURRENCE_DESC, IA.LOC_AGENCY_CODE, isupp.APPROVING_AGENCY_CODE, isupp.APPROVAL_DATE, '_INC_LOC_', 'Incident Location', i.inc_disp_code FROM addresses a, incidents i, incident_supplements isupp, incident_addresses ia, address_common_names acn WHERE ia.incident_id = i.incident_id AND ia.address_id = a.address_id AND isupp.inc_incident_id = i.incident_id AND a.address_id = acn.addr_address_id(+) UNION SELECT DISTINCT i.incident_id, i.inc_report_number, isupp.supp_agency_code "AGNCY_CD_AGENCY_CODE", i.report_date, i.start_date, i.end_date, isupp.isc_status_code "STATUS", isupp.isc_status_code_type, isupp.supp_seq, isupp.responsible_user_id, isupp.agency_only, isupp.cid, isupp.security_level, i.summary, a.address_id, a.street_number, a.dirct_cd_direction_code, a.dirct_cd_direction_code_type, (SELECT EDR.DESCRIPTION FROM EJS_CODES EDR WHERE EDR.CODE_TYPE = A.DIRCT_CD_DIRECTION_CODE_TYPE AND EDR.Code = A.DIRCT_CD_DIRECTION_CODE), a.street_name, a.street_cd_street_type_code, a.street_cd_street_type_cod_type, (SELECT EST.DESCRIPTION FROM EJS_CODES EST WHERE EST.CODE_TYPE = A.STREET_CD_STREET_TYPE_COD_TYPE AND EST.CODE = A.STREET_CD_STREET_TYPE_CODE), a.addr_sc_address_subtype_code, a.sub_number, a.intrsect1_street_number, a.intrsect1_dir, a.intrsect1_name, a.intrsect1_street_type_code, a.intrsect1_dir_suffix, ia.inc_addr_comment, a.beat, a.sub_beat, a.longitude, a.latitude, initcap(a.city), initcap(a.geo_city), a.state_cd_state_code, a.zip5, a.zip4, a.direct_suffix, i.internal_incident, acn.common_place_name, IA.COUNTY_CODE AS COUNTY_OF_OCCURRENCE_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = IA.COUNTY_CODE_TYPE AND EC.CODE = IA.COUNTY_CODE) AS COUNTY_OF_OCCURRENCE_DESC, IA.LOC_AGENCY_CODE, isupp.APPROVING_AGENCY_CODE, isupp.APPROVAL_DATE, IL.LOC_TYPE_CODE, LC.DESCRIPTION, i.inc_disp_code FROM addresses a, incidents i, incident_supplements isupp, incident_addresses ia, incident_locations il, address_common_names acn, ejs_codes lc WHERE ia.incident_id = i.incident_id AND isupp.inc_incident_id = il.incident_Id AND isupp.supp_seq = il.supp_seq AND il.address_id = a.address_id AND isupp.inc_incident_id = i.incident_id AND a.address_id = acn.addr_address_id(+) and IL.LOC_TYPE_CODE_TYPE = lc.code_type and IL.LOC_TYPE_CODE = lc.code
 
Possibly Referenced Tables/Views:
ADDRESS_COMMON_NAMES ADDRESSES EJS_CODES INCIDENT_ADDRESSES INCIDENT_LOCATIONS INCIDENT_SUPPLEMENTS INCIDENTS 


Close relationships: