Table slot9.WORLD.TSTA.ADDRESSES
This table stores MASTER ADDRESSES entered in the application or through CAD imports
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
ADDRESS_ID number 0
ADDRESS_ASSOC_CNT_VW.ADDRESS_ID Implied Constraint R
ADDRESS_ATTACHMENTS.ADDRESS_ID ADDRATT_ADDR_FK C
ADDRESS_COMMON_NAMES.ADDR_ADDRESS_ID ADDRCN_ADDR_FK C
ADDRESS_COMMON_NAMES_VW.ADDRESS_ID Implied Constraint R
ADDRESS_IMAGES.ADDRESS_ID ADDIM_ADDR_FK R
ADDRESSES_NOT_DUPLICATES.ADDRESS_ID ADDNODUP_ADDR_FK R
ADDRESSES_NOT_DUPLICATES.NOT_DUP_ADDRESS_ID ADDNODUP_NOT_ADDR_FK R
ADDRESSES_SEARCH_VW.ADDRESS_ID Implied Constraint R
ALL_ADDRESS_COMMON_NAMES_VW.ADDRESS_ID Implied Constraint R
ARRESTS.ADDR_ADDRESS_ID ARR_ADDR_FK R
BUS_ADDR_ALARM_VW.ADDRESS_ID Implied Constraint R
BUS_ADDR_BUS_REL_VW.ADDRESS_ID Implied Constraint R
BUS_ADDR_EMP_VW.ADDRESS_ID Implied Constraint R
BUS_ADDR_PEOP_VW.ADDRESS_ID Implied Constraint R
BUS_ADDR_PERMIT_VW.ADDRESS_ID Implied Constraint R
BUSINESS_ADDRESS_VW.ADDRESS_ID Implied Constraint R
BUSINESS_ADDRESSES.ADDRESS_ID BUS_ADDR_ADDR_FK R
BUSINESS_RMS_SEARCH_VW.ADDRESS_ID Implied Constraint R
BUSINESS_VEHICLES_VW.ADDRESS_ID Implied Constraint R
CITATION_ADDRESS_VW.ADDRESS_ID Implied Constraint R
CITATION_ADDRESSES.ADDRESS_ID CIT_ADDR_ADDR_FK R
COURT_PAPER_LOGS.SERVE_LOCATION_ID CPAP_LOG_ADDR_FK R
COURT_PAPER_SERVICE_ADDRS.ADDRESS_ID CPSA_ADDR_FK R
CP_DELETE_SERVICE_ADDR.ADDRESS_ID CPDELSADDR_ADDR_FK R
CRIMINAL_COMPLAINTS.CRIMINAL_COMPLAINT_ADDR_ID CRMCMP_ADDR_CRMCMP_FK R
CRIMINAL_COMPLAINTS.PERSON_ADDRESS_ID CRMCMP_ADDR_FK R
DELIMITED_LOCATION_ALL.ADDRESS_ID Implied Constraint R
DELIMITED_LOCATION_INTERSECT.ADDRESS_ID Implied Constraint R
DS_ICR_ADDRESSES.ADDRESS_ID Implied Constraint R
DV_CRASH_INSURANCE_VW.ADDRESS_ID Implied Constraint R
DV_CRASH_REFERENCES_VW.ADDRESS_ID Implied Constraint R
DV_CRASH_SERVICE_RECORDS_VW.ADDRESS_ID Implied Constraint R
DV_CRASH_SERVICE_REPAIRS_VW.ADDRESS_ID Implied Constraint R
DV_CRASH_TOWS_VW.ADDRESS_ID Implied Constraint R
DV_CRASHES.ADDRESS_ID CRASH_ADDR_FK R
DV_CRASHES_VW.ADDRESS_ID Implied Constraint R
EMPLOYEE_ADDRESSES.ADDRESS_ID EMP_ADDR_ADDR_FK R
EMPLOYEE_CONTACTS.ADDRESS_ID EMPCONT_ADDR_FK R
FIELD_INT_SEARCH_LOCATION_VW.ADDRESS_ID Implied Constraint R
FLDINT_ADD_VW.ADDRESS_ID Implied Constraint R
FLDINT_ADDRESSES.ADDRESS_ID FI_ADDR_ADDR_FK R
GIS_TEMP.ADDRESS_ID Implied Constraint R
IMP_VEH_BUSINESSES_VW.ADDRESS_ID Implied Constraint R
IMPOUND_PEOPLE.ADDRESS_ID IMPP_ADDR_FK R
INC_CASE_INCIDENTS_VW.ADDRESS_ID Implied Constraint R
INC_FLD_CONTACT_ADDRESSES_VW.ADDRESS_ID Implied Constraint R
INCIDENT_ADDRESS_VW.ADDRESS_ID Implied Constraint R
INCIDENT_ADDRESSES.ADDRESS_ID INC_ADDR_ADDR_FK R
INCIDENT_BAIR_EXTRACT_VW.ADDRESS_ID Implied Constraint R
INCIDENT_CASE_OFFICERS_VW.ADDRESS_ID Implied Constraint R
INCIDENT_CRIME_TARGET_VW.ADDRESS_ID Implied Constraint R
INCIDENT_GIS_VW.ADDRESS_ID Implied Constraint R
INCIDENT_LOCATIONS.ADDRESS_ID INC_LOC_ADDR_FK R
INCIDENT_PERSON_OFFENSES_VW.ADDRESS_ID Implied Constraint R
INCIDENT_RECOVERY_VW.ADDRESS_ID Implied Constraint R
INCIDENT_VEHICLES.ADDRESS_ID INCVEH_ADDR_FK R
IX_PERSON_SUMMARY_VW.ADDRESS_ID Implied Constraint R
JS_FIELD_CONTACT_ADDRESS_VW.ADDRESS_ID Implied Constraint R
JS_FIELD_CONTACT_VW.ADDRESS_ID Implied Constraint R
JS_INCIDENT_ADDRESS_VW.ADDRESS_ID Implied Constraint R
JS_INCIDENT_CASE_SUMMARY_VW.ADDRESS_ID Implied Constraint R
JS_INCIDENT_CASE_VW.ADDRESS_ID Implied Constraint R
JS_INCIDENT_OFFENSE_VW.ADDRESS_ID Implied Constraint R
JS_INCIDENT_OFFNDR_EVIDENCE_VW.ADDRESS_ID Implied Constraint R
K9_DEPLOYMENT.ADDRESS_ID K9DEP_ADDR_FK R
K9_TRAINING.ADDRESS_ID K9TRN_ADDR_FK R
LEGAL_SEARCH_ADDRESSES.ADDRESS_ID LSA_ADDR_FK R
MAP_EVENT_VW.ADDRESS_ID Implied Constraint R
MAP_SHAPE_ADDRESSES.ADDRESS_ID MUSADDR_ADDR_FK C
N_INCIDENT_PERSON_OFFENSES_VW.ADDRESS_ID Implied Constraint R
PEOPLE_ADDRESS_VW.ADDRESS_ID Implied Constraint R
PEOPLE_COMBO_ADDR_PHONES_VW.ADDRESS_ID Implied Constraint R
PEOPLE_COMBO_ADR_PH_VW.ADDRESS_ID Implied Constraint R
PEOPLE_COMBO_ADR_VW.ADDRESS_ID Implied Constraint R
PEOPLE_COMBO_PH_VW.ADDRESS_ID Implied Constraint R
PEOPLE_COMBO_VW.ADDRESS_ID Implied Constraint R
PEOPLE_JAIL_SEARCH_VW.ADDRESS_ID Implied Constraint R
PEOPLE_SEARCH_ONEADDRESS_VW.ADDRESS_ID Implied Constraint R
PERSON_ADDR_HISTORY.ADDRESS_ID Implied Constraint R
PERSON_ADDR_PHONES.ADDRESS_ID Implied Constraint R
PERSON_ADDRESSES.ADDRESS_ID PER_ADDR_ADDR_FK R
PW_INCIDENT_ADDRESS_VW.ADDRESS_ID Implied Constraint R
USER_FIELD_ADDR_VALUES.ADDRESS_ID USRSCRN_UFAV_ADDR_FK R
WARRANT_ADDR_SEARCH_VW.ADDRESS_ID Implied Constraint R
WARRANT_PERSON_ADDR_VW.ADDRESS_ID Implied Constraint R
WARRANT_SERVICE_ADDRESSES.ADDRESS_ID WARSA_ADDR_FK R
Address ID number
ADDR_SC_ADDRESS_SUBTYPE_CODE varchar2 30  √  null
EJS_CODES.CODE ADDR_ADDR_SC_ADDRE_EJS_CODE_FK R
Subaddress type
CITY_CD_CITY_CODE varchar2 30  √  null
EJS_CODES.CODE ADDR_CITY_CD_CITY__EJS_CODE_FK R
City of the address
STATE_CD_STATE_CODE varchar2 30  √  null
EJS_CODES.CODE ADDR_STATE_CD_STAT_EJS_CODE_FK R
State of the address
CNTRY_CD_COUNTRY_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE ADDR_CNTRY_CD_COUN_EJS_CODE_FK R
The country of the address.
CNTY_CD_COUNTY_CODE varchar2 30  √  null
EJS_CODES.CODE ADDR_CNTY_CD_COUNT_EJS_CODE_FK R
DIRCT_CD_DIRECTION_CODE varchar2 30  √  null
EJS_CODES.CODE ADDR_DIRCT_CD_DIRE_EJS_CODE_FK R
STREET_NUMBER varchar2 10  √  null The street number of the address
STREET_NAME varchar2 40  √  null The street name of the address
ZIP4 number 0  √  null 4 Digit Zip Code Extension
BEAT varchar2 30  √  null Beat the address as assigned
SUB_BEAT varchar2 30  √  null Sub-beat address assigned
SUB_NUMBER varchar2 50  √  null Subaddress number
INTRSECT1_DIR varchar2 30  √  null
EJS_CODES.CODE ADDR_INTRSECT1_DIR_EJS_CODE_FK R
Direction from intersection to point of interest
INTRSECT1_NAME varchar2 40  √  null Intersecting Street name
CITY varchar2 40  √  null City Name
DISTANCE1 number 10,2  √  null Number of units from the intersection to the point of interest
UNITS1 varchar2 2  √  null Unit of measure (in, ft, yd, mi; cm, m, km )
INTRSECT2_DIR varchar2 30  √  null
EJS_CODES.CODE ADDR_INTRSECT2_DIR_EJS_CODE_FK R
Direction from the 2nd street
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null The date the address was received.
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
STREET_CD_STREET_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE ADDR_STREET_CD_STR_EJS_CODE_FK R
Street type. (Lane, Circle...)
VERIFY_STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE ADDR_VERIFY_STATUS_EJS_CODE_FK R
LONGITUDE varchar2 30  √  null
LATITUDE varchar2 30  √  null
VERIFY_DATE date 7  √  null
GEO_CITY varchar2 40  √  null
SSTREET_NAME varchar2 4  √  null
INTRSECT1_DIR_SUFFIX varchar2 30  √  null
EJS_CODES.CODE ADDR_INTRSECT1_SUF_EJS_CODE_FK R
Code for compass heading from known point
DIRECT_SUFFIX varchar2 30  √  null
EJS_CODES.CODE ADDR_DIRECT_SUFFIX_EJS_CODE_FK R
Code for compass heading from known point
INTRSECT1_STREET_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE ADDR_INTRSECT1_STR_EJS_CODE_FK R
Street type. (Lane, Circle...)
VERIFY_USER varchar2 15  √  null
INTRSECT1_STREET_NUMBER varchar2 10  √  null
INDX_SEC_LEVEL_CODE number 0  √  1
MASTER_INDEX_SECURITY_CODES.INDX_SEC_LEVEL_CODE ADDRESSES_MIS_CD_CD_FK R
INDX_SEC_LEVEL_ID varchar2 100  √  null
INDX_SEC_LEVEL_AGENCY varchar2 30  √  null
ACTIVE_SUBSCRIPTION varchar2 1  √  null
ADDR_SC_ADDRESS_SUBTYPE_C_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ADDR_ADDR_SC_ADDRE_EJS_CODE_FK R
CITY_CD_CITY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ADDR_CITY_CD_CITY__EJS_CODE_FK R
CNTRY_CD_COUNTRY_TYPE_COD_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ADDR_CNTRY_CD_COUN_EJS_CODE_FK R
CNTY_CD_COUNTY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ADDR_CNTY_CD_COUNT_EJS_CODE_FK R
DIRCT_CD_DIRECTION_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ADDR_DIRCT_CD_DIRE_EJS_CODE_FK R
DIRECT_SUFFIX_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ADDR_DIRECT_SUFFIX_EJS_CODE_FK R
INTRSECT1_DIR_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ADDR_INTRSECT1_DIR_EJS_CODE_FK R
INTRSECT1_DIR_SUFFIX_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ADDR_INTRSECT1_SUF_EJS_CODE_FK R
INTRSECT1_STREET_TYPE_COD_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ADDR_INTRSECT1_STR_EJS_CODE_FK R
INTRSECT2_DIR_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ADDR_INTRSECT2_DIR_EJS_CODE_FK R
STATE_CD_STATE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ADDR_STATE_CD_STAT_EJS_CODE_FK R
STREET_CD_STREET_TYPE_COD_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ADDR_STREET_CD_STR_EJS_CODE_FK R
VERIFY_STATUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ADDR_VERIFY_STATUS_EJS_CODE_FK R
INDX_TYPE_CODE varchar2 30  √  'KNOWN'
REC_ID number 0  √  null
LOADED_BY varchar2 100  √  null Interface that loaded this index record.
GEOCODED_FLAG varchar2 1  √  null
LAST_LOAD_DATE date 7  √  null
ZIP5 varchar2 30  √  null 5 Digit Zip Code

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ADDRESS_ID" IS NOT NULL ADDR_ADDRESS_ID_NN
GEOCODED_FLAG IN ('Y', 'N') CK_ADDR_GEO_FLAG

Indexes:
Column(s) Type Sort Constraint Name
ADDRESS_ID Primary key Asc ADDR_PK
ADDR_SC_ADDRESS_SUBTYPE_C_TYPE + ADDR_SC_ADDRESS_SUBTYPE_CODE Performance Asc/Asc ADDR_ADDR_SC_ADDRE_EJS_CODE_I
ADDR_SC_ADDRESS_SUBTYPE_CODE Performance Asc ADDR_ADDR_SC_FK_I
VERIFY_STATUS_CODE Performance Asc ADDR_AVSD_FK_I
CITY_CD_CITY_CODE_TYPE + CITY_CD_CITY_CODE Performance Asc/Asc ADDR_CITY_CD_CITY__EJS_CODE_I
CITY_CD_CITY_CODE Performance Asc ADDR_CITY_CD_FK_I
CNTRY_CD_COUNTRY_TYPE_COD_TYPE + CNTRY_CD_COUNTRY_TYPE_CODE Performance Asc/Asc ADDR_CNTRY_CD_COUN_EJS_CODE_I
CNTRY_CD_COUNTRY_TYPE_CODE Performance Asc ADDR_CNTRY_CD_FK_I
CNTY_CD_COUNTY_CODE_TYPE + CNTY_CD_COUNTY_CODE Performance Asc/Asc ADDR_CNTY_CD_COUNT_EJS_CODE_I
CNTY_CD_COUNTY_CODE Performance Asc ADDR_CNTY_CD_FK_I
DIRCT_CD_DIRECTION_CODE_TYPE + DIRCT_CD_DIRECTION_CODE Performance Asc/Asc ADDR_DIRCT_CD_DIRE_EJS_CODE_I
DIRCT_CD_DIRECTION_CODE Performance Asc ADDR_DIRCT_CD_FK_I
INTRSECT1_DIR Performance Asc ADDR_DIRCT_CD_INT1_DIR_FK_I
INTRSECT1_DIR_SUFFIX Performance Asc ADDR_DIRCT_CD_INT1_SUF_FK_I
INTRSECT2_DIR Performance Asc ADDR_DIRCT_CD_INT2_DIR_FK_I
DIRECT_SUFFIX Performance Asc ADDR_DIRCT_CD_SUFFIX_FK_I
DIRECT_SUFFIX_TYPE + DIRECT_SUFFIX Performance Asc/Asc ADDR_DIRECT_SUFFIX_EJS_CODE_I
GEOCODED_FLAG Performance Asc ADDR_GEO_FLAG_I
LATITUDE Performance Asc ADDR_GEO_LAT_I
LONGITUDE Performance Asc ADDR_GEO_LNG_I
INDX_SEC_LEVEL_CODE Performance Asc ADDR_INDX_SEC_LEVEL_CD_I
INTRSECT1_DIR_TYPE + INTRSECT1_DIR Performance Asc/Asc ADDR_INTRSECT1_DIR_EJS_CODE_I
INTRSECT1_STREET_TYPE_COD_TYPE + INTRSECT1_STREET_TYPE_CODE Performance Asc/Asc ADDR_INTRSECT1_STR_EJS_CODE_I
INTRSECT1_DIR_SUFFIX_TYPE + INTRSECT1_DIR_SUFFIX Performance Asc/Asc ADDR_INTRSECT1_SUF_EJS_CODE_I
INTRSECT2_DIR_TYPE + INTRSECT2_DIR Performance Asc/Asc ADDR_INTRSECT2_DIR_EJS_CODE_I
Performance ADDR_ST_NM_NM_LW_FB_I
STATE_CD_STATE_CODE Performance Asc ADDR_STATE_CD_FK_I
STATE_CD_STATE_CODE_TYPE + STATE_CD_STATE_CODE Performance Asc/Asc ADDR_STATE_CD_STAT_EJS_CODE_I
STREET_CD_STREET_TYPE_CODE Performance Asc ADDR_STREET_CD_FK_I
INTRSECT1_STREET_TYPE_CODE Performance Asc ADDR_STREET_CD_INT1_STC_FK_I
STREET_CD_STREET_TYPE_COD_TYPE + STREET_CD_STREET_TYPE_CODE Performance Asc/Asc ADDR_STREET_CD_STR_EJS_CODE_I
VERIFY_STATUS_CODE_TYPE + VERIFY_STATUS_CODE Performance Asc/Asc ADDR_VERIFY_STATUS_EJS_CODE_I
CITY Performance Asc ADDRESS_CITY
STREET_NAME + CITY Performance Asc/Asc ADDRESS_STREET_CITY
STREET_NAME Performance Asc ADDRESS_STREET_NAME

Close relationships  within of separation: