BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_HOST_SW_USAGE - Software Usage information table

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
DISC_SW_PROD_ID number 18  √  null Link to the software instance to the software installation using the unique identifier (MATCH_HOST_SW_PROD and MATCH_HOST_SW_PROD_DET)
HOST_ID number 0  √  null Host Id
CAT_SW_UUID number 0  √  null Unique SW identifier(COALESCE of CAT_SW_RELEASE_ID,CAT_SW_EDITION_ID,CAT_SW_VERSION_ID)
IS_USED number 0  √  null Is Software being used?
LAST_USED_DATE date 7  √  null Software Last Used Date
USED_COUNT number 0  √  null Number of times Software used
RULE_INSTALLED_DATE number 0  √  null Installed date rule - Is on/off?
IS_USED_BY_INSTALLED_DATE number 0  √  null Installed date rule - Is Used?
INSTALLED_DATE date 7  √  null Installed date rule - Installed Date
RULE_RECENTLY_RUN number 0  √  null Recently run rule - Is on/off?
IS_USED_BY_RECENTLY_RUN number 0  √  null Recently run rule - Is Used?
LAST_RUN_DATE date 7  √  null Recently run rule - Last Run Date
RUN_COUNT number 0  √  null Recently run rule - Run Count
RUN_LAST_USERDOMAIN varchar2 255  √  null Recently run rule - Last Run User Domain
RUN_LAST_USERLOGON varchar2 255  √  null Recently run rule - Last Run User Logon
RUN_LAST_USERNAME varchar2 255  √  null Recently run rule - Last Run User Name
RULE_METERING number 0  √  null Metering Rule - Is on/off?
IS_USED_BY_METERING number 0  √  null Metering rule - Is Used?
LAST_METERING_DATE date 7  √  null Metering Rule - Last metering date
METERING_NBR_OF_MONTHS number 0  √  null Metering Rule - Number of months used for the metering calculation
RULE_METERING_BY_MINUTES number 0  √  null Metering Rule - by Minutes - Is on/off?
METERING_NBR_OF_MINUTES number 0  √  null Metering Rule - by Minutes - Number of minutes used for the metering calculation
RULE_METERING_BY_TIMES number 0  √  null Metering Rule - by No. of time - Is on/off?
METERING_NBR_OF_TIMES number 0  √  null Metering Rule - by No. of time - Number of times used for the metering calculation
IS_SUITE varchar2 1  √  null Is this software a Suite?
GROUP_ID number 18  √  null Group Id of this software
SUITE_ID number 18  √  null Suite Id of this software
TASK_ID number 18  √  null Task ID
INVENTORY_ID number 18  √  null Inventory ID
DATASRC nvarchar2 50  √  null Data Source

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
DISC_SW_PROD_ID + INVENTORY_ID + TASK_ID Primary key Asc/Asc/Asc PK_MATCH_HOST_SW_USAGE These unique columns are also nullable
Confidential and Proprietary to BDNA