BDNA Data Platform 5.4 July 2017 (SQL Server)
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 numeric 20 Task ID
PROCESS_ID numeric 20 Process Id
TASK_NAME varchar 256  √  null Name of the Task
TASK_TYPE varchar 256  √  null Type of Task (PURCHASEORDER, NORMALIZE, MASHUP etc
PROCESS_STATUS varchar 20  √  null Published, Error, processing etc
ERROR_CODE varchar 4000  √  null Error code
ERROR_DESCRIPTION varchar 4000  √  null Error description
IMPORT_BEGIN_ON datetime 16,3  √  null Import Begin Time
IMPORT_END_ON datetime 16,3  √  null Import End Time
MAPPING_BEGIN_ON datetime 16,3  √  null Mapping Begin Time
MAPPING_END_ON datetime 16,3  √  null Mapping End Time
INVENTORY_ID numeric 20  √  null Inventory ID
ORIG_PROCESS_ID numeric 20 Parent Process Id
DATASRC nvarchar 50  √  null Data Source

Analyzed at Thu Jul 20 12:14 PDT 2017

Confidential and Proprietary to BDNA