BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_STATS_DETAIL - Statistics detail information matched (e.g., known, mapped, irrelevant)

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
MATCH_INVENTORY.INVENTORY_ID FK0_MATCH_STATS_DETAIL R
Inventory ID for this row
TASK_ID number 18  √  null
MATCH_TASK_DET.TASK_ID FK1_MATCH_STATS_DETAIL R
Task ID for this row
STATS_NAME varchar2 255  √  null Statistics Name (e.g., Software Tier 1, Software Tier 2, CPU Model, Hardware Model, Operating Systems)
TOTAL float 126  √  null Total count for each manufacturer/tier/category
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
DATASRC varchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)
STATS_DESCRIPTION varchar2 255  √  null Description for the statistic

Analyzed at Thu Jul 20 12:13 PDT 2017


Close relationships  within of separation:
Confidential and Proprietary to BDNA