Table slot9.WORLD.TSTA.DS_ICR_ADDRESSES
This table stores Addresses Segment based on a given EXTERNAL_SYSTEM_CODES.CODE populated from DS_ICR Package when Incident is Approved in the application
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
HEADERID number 0
DS_ICR_HEADERS.HEADERID DSICRADD_DSICRHD_FK R
ADDRESS_ID number 0
ADDRESSES.ADDRESS_ID Implied Constraint R
Address ID Number of Address [Foreign Key: Incident_Addresses and Addresses]
ADDNO varchar2 255 Address Count [Should only be one address location for an incident- this may always be 1]
SUBMISSION_TYPE_CODE varchar2 255  √  null Submission Type Code [Identifies the type of Address. Currently the only accepted value is IN for Incident.]
STREET_PREFIX varchar2 255  √  null Data Element (Street Prefix)
STREET_NUMBER varchar2 255  √  null Data Element (Arrest Type)
STREET_NAME varchar2 255  √  null Data Element (Street Name)
STREET_SUFFIX varchar2 255  √  null Data Element (Street Suffix)
STREET_QUADRANT varchar2 255  √  null Data Element (Street Quadrant)
CROSS_STREET_NAME varchar2 255  √  null Data Element (Cross Steet Name)
UNIT_NUMBER varchar2 255  √  null Data Element (Apartment Number, Lot Number, PO Box Number)
UNIT_CODE varchar2 255  √  null Captures the code from addresses for the type of Unit Number. IE: APT, LOT, POB
UNIT_CODE_TYPE varchar2 255  √  null Captures the code type from addresses for the type of unit Number. (ejs_codes) IE: ADDRESS_SUB_TYPE_CODES
CITY varchar2 255  √  null Data Element (City)
STATE varchar2 255  √  null Data Element (State)
COUNTY_NUMBER varchar2 255  √  null Data Element (County Number)
ZIP5 varchar2 255  √  null Data Element (Zip Code)
ZIP4 varchar2 255  √  null Data Element (Zip Code)
LATITUDE varchar2 255  √  null Data Element (Latitude)
LONGITUDE varchar2 255  √  null Data Element (Longitude)
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
REC_ID number 0  √  null
CITY2 varchar2 255  √  null
STREET_TYPE varchar2 30  √  null
SUB_NUMBER varchar2 255  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ADDNO" IS NOT NULL DSICRADD_ADDNO_NN
"ADDRESS_ID" IS NOT NULL DSICRADD_ADDRESSID_NN
"HEADERID" IS NOT NULL DSICRADD_HEADERID_NN

Indexes:
Column(s) Type Sort Constraint Name
HEADERID + ADDRESS_ID + ADDNO Primary key Asc/Asc/Asc DSICRADD_PK
HEADERID Performance Asc DSICRADD_DSICRHD_FK_I

Close relationships  within of separation: