BDNA Data Platform 5.4 July 2017 (SQL Server)
DISC_PUBLISHED_RECORDS_STATS - Row counts and unique machine counts from published tables

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 numeric 20 Inventory ID
TASK_ID numeric 20 Task ID
TABLE_NAME varchar 50 Table Name
TABLE_DESC varchar 255  √  null Table Description
ACTIVE_FLAG varchar 1  √  null If this table is active?
MACHINE_COUNT numeric 20  √  null No. of machines
ROW_COUNT numeric 20  √  null No. of rows in the table
OS_COUNT numeric 20  √  null No. of Operating systems
MACHINE_COUNT_STATUS varchar 25  √  null Machine count Valid/Invalid Count/Expected count with known difference
OS_COUNT_STATUS varchar 25  √  null OS count Valid/Invalid Count/Expected count with known difference

Analyzed at Thu Jul 20 12:14 PDT 2017

Confidential and Proprietary to BDNA