BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_PER_ADDREMOVE_STAT_SUMM - Manufacturer Add/Remove tier statistics summary information matched

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
INVENTORY_ID number 18  √  null Inventory ID for this row
TASK_ID number 18  √  null Task ID for this row
CAT_KEYWORD_TIER number 0  √  null Tier from Catalog
CAT_MANUFACTURER_ID number 18  √  null Manufactuer from Catalog
TOTAL float 126  √  null Total count for each manufacturer/tier/category
MAPPED float 126  √  null Total Add/Remove mapped records
IRRELEVANT float 126  √  null Total Add/Remove irrelevant records
KNOWN float 126  √  null Total Add/Remove known records
PERC_KNOWN float 126  √  null Total Add/Remove percentage known records
UNKNOWN float 126  √  null Total Add/Remove unknown records
PERC_UNKNOWN float 126  √  null Total Add/Remove percentage unknown records

Analyzed at Thu Jul 20 12:13 PDT 2017

Confidential and Proprietary to BDNA