BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_TASK_DET - Task metadata 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
TASK_ID number 18  √  null
DISC_ALL_OS.TASK_ID FK0_DISC_ALL_OS R
DISC_COMPUTERSYSTEM.TASK_ID FK0_DISC_COMPUTERSYSTEM R
DISC_CS_CAT_MAP.TASK_ID FK1_DISC_CS_CAT_MAP R
DISC_DEDUPING_STATS.TASK_ID FK1_DISC_DEDUP_STATS R
DISC_EXTRACTED_RECORDS_STATS.TASK_ID FK1_DISC_EXT_REC_STATS R
DISC_HOSTS.TASK_ID FK0_DISC_HOSTS R
DISC_MISSING_HOSTS.TASK_ID FK1_DISC_MISS_HOSTS R
DISC_OS_CAT_MAP.TASK_ID FK0_DISC_OS_CAT_MAP R
DISC_PUBLISHED_RECORDS_STATS.TASK_ID FK1_DISC_PUB_REC_STATS R
MATCH_ADDREMOVE_MANF_KWD.TASK_ID FK1_MATCH_ALL_ADDRM_KW R
MATCH_ADDREMOVE_MANF_STAT_DET.TASK_ID FK1_MATCH_ADDRM_STATS_DET R
MATCH_ADDREMOVE_MANF_STAT_SUMM.TASK_ID FK1_MATCH_ADDRM_STATS_SUM R
MATCH_ADDREMOVE_TIER_STAT_SUMM.TASK_ID FK1_MATCH_ADDRM_TSTATS_SUM R
MATCH_ALL_ADDREMOVE.TASK_ID FK1_MATCH_ALL_ADDREMOVE R
MATCH_ALL_EXE.TASK_ID FK1_MATCH_ALL_EXE R
MATCH_EXE_MANF_KWD.TASK_ID FK1_MATCH_EXE_KW R
MATCH_EXE_MANF_STAT_DET.TASK_ID FK1_MATCH_EXE_ST_DET R
MATCH_EXE_MANF_STAT_SUMM.TASK_ID FK1_MATCH_EXE_ST_SUM R
MATCH_EXE_TIER_STAT_SUMM.TASK_ID FK1_MATCH_EXE_TST_SUM R
MATCH_HOST_HW_PROD_MODEL.TASK_ID FK1_MATCH_HOST_HW_PROD_MODEL R
MATCH_SOFTWARE_METERING.TASK_ID FK4_MATCH_SOFTWARE_METERING R
MATCH_STATS_DETAIL.TASK_ID FK1_MATCH_STATS_DETAIL R
Task ID for this task
PROCESS_ID number 18  √  null
TASK_NAME varchar2 256  √  null Task name for this task
TASK_TYPE varchar2 256  √  null Type of task (e.g., PURCHASE ORDER, etc.)
PROCESS_STATUS varchar2 20  √  null Process status for this task
ERROR_CODE varchar2 4000  √  null Error code for this task
ERROR_DESCRIPTION varchar2 4000  √  null Error description for this task
IMPORT_BEGIN_ON date 7  √  null Import begin timestamp for this task
IMPORT_END_ON date 7  √  null Import end timestamp for this task
MAPPING_BEGIN_ON date 7  √  null Mapping begin timestamp for this task
MAPPING_END_ON date 7  √  null Mapping end timestamp for this task
INVENTORY_ID number 18  √  null Inventory ID for this task
ORIG_PROCESS_ID number 18  √  null Original process Id in case of combined task
DATASRC nvarchar2 25  √  null

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
TASK_ID Primary key Asc PK_MATCH_TASK_DET This unique column is also nullable

Close relationships  within of separation:
Confidential and Proprietary to BDNA