Table slot9.WORLD.TSTA.ADDRESS_COLLAPSE_LOG
This table stores a log entry for multiple MASTER ADDRESS records being collapsed into a single record
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
COLLAPSE_ID number 38
BUSINESS_COLLAPSE_LOG.COLLAPSE_ID Implied Constraint R
Address ID of Collapsed Address
KEEP_ID number 38 Address ID of Keep Address
COLLAPSE_INFO varchar2 255  √  null Collapsed Address Summary Info
KEEP_INFO varchar2 255  √  null Kept Address Summary Info
CREATOR_ID varchar2 100  √  null Collapsing Person USER ID
CREATOR_DATE date 7  √  null Collapse Date/Time
UPDATOR_ID varchar2 100  √  null Updating Person USER ID
UPDATOR_DATE date 7  √  null Date of Last Update
REC_ID number 0  √  null
ADDR_SC_ADDRESS_SUBTYPE_CODE varchar2 30  √  null
CITY_CD_CITY_CODE varchar2 30  √  null
STATE_CD_STATE_CODE varchar2 30  √  null
CNTRY_CD_COUNTRY_TYPE_CODE varchar2 30  √  null
CNTY_CD_COUNTY_CODE varchar2 30  √  null
DIRCT_CD_DIRECTION_CODE varchar2 30  √  null
STREET_NUMBER varchar2 10  √  null
STREET_NAME varchar2 40  √  null
ZIP4 number 0  √  null
BEAT varchar2 30  √  null
SUB_BEAT varchar2 30  √  null
SUB_NUMBER varchar2 50  √  null
INTRSECT1_DIR varchar2 30  √  null
INTRSECT1_NAME varchar2 40  √  null
CITY varchar2 40  √  null
DISTANCE1 number 10,2  √  null
UNITS1 varchar2 2  √  null
INTRSECT2_DIR varchar2 30  √  null
STREET_CD_STREET_TYPE_CODE varchar2 30  √  null
VERIFY_STATUS_CODE varchar2 30  √  null
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
DIRECT_SUFFIX varchar2 30  √  null
INTRSECT1_STREET_TYPE_CODE varchar2 30  √  null
VERIFY_USER varchar2 15  √  null
INTRSECT1_STREET_NUMBER varchar2 10  √  null
INDX_SEC_LEVEL_CODE number 0  √  null
MASTER_INDEX_SECURITY_CODES.INDX_SEC_LEVEL_CODE Implied Constraint 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
CITY_CD_CITY_CODE_TYPE varchar2 30  √  null
CNTRY_CD_COUNTRY_TYPE_COD_TYPE varchar2 30  √  null
CNTY_CD_COUNTY_CODE_TYPE varchar2 30  √  null
DIRCT_CD_DIRECTION_CODE_TYPE varchar2 30  √  null
DIRECT_SUFFIX_TYPE varchar2 30  √  null
INTRSECT1_DIR_TYPE varchar2 30  √  null
INTRSECT1_DIR_SUFFIX_TYPE varchar2 30  √  null
INTRSECT1_STREET_TYPE_COD_TYPE varchar2 30  √  null
INTRSECT2_DIR_TYPE varchar2 30  √  null
STATE_CD_STATE_CODE_TYPE varchar2 30  √  null
STREET_CD_STREET_TYPE_COD_TYPE varchar2 30  √  null
VERIFY_STATUS_CODE_TYPE varchar2 30  √  null
INDX_TYPE_CODE varchar2 30  √  null
LOADED_BY varchar2 100  √  null
ZIP5 varchar2 30  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"COLLAPSE_ID" IS NOT NULL ACL_COLLAPSE_ID_NN
"KEEP_ID" IS NOT NULL ACL_KEEP_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
COLLAPSE_ID Primary key Asc ACL_PK

Close relationships: