ReleaseUpdateDB60_Basic.updateWorkflowTracking Upgrade Script
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
Class |
ReleaseUpdateDB60_Basic |
Method |
updateWorkflowTracking |
Description |
This upgrade scripts normalizes the data in the WorkflowTrackingStatusTable and the WorkflowTrackingTable tables. Redundant data will be removed, an additional table is being added, and surrogate keys are being introduced. |
Affected Modules and Tables
Affected Modules |
|---|
Basic |
Affected Tables |
|---|
WorkflowTrackingStatusTable |
WorkflowTrackingTable |
WorkflowTrackingCommentTable |
WorkflowTrackingArgumentTable |
WorkflowTrackingWorkItem |
Data Migration Section
From Table: WorkflowTrackingTable |
To Table: WorkflowTrackingWorkItem |
|---|---|
ToUser |
ToUser |
WorkItemSubject |
WorkItemSubject |
DueDateTime |
DueDateTime |
Outcome |
Outcome |
WorkItemId |
WorkItemId |
New Tables or Fields
Table |
Field |
Extended Data Type -or- Base Enum |
|---|---|---|
WorkflowTrackingWorkItem |
||
WorkflowTrackingTable |
WorkflowTrackingStatusTable |
RefRecId |
WorkflowTrackingTable |
WorkflowElementTable |
RefRecId |
WorkflowTrackingTable |
WorkflowStepTable |
RefRecId |
WorkflowTrackingTable |
WorkflowParallelBranchTable |
RefRecId |
WorkflowTrackingTable |
WorkflowSubWorkflow |
RefRecId |
WorkflowTrackingCommentTable |
WorkflowTrackingTable |
RefRecId |
WorkflowTrackingArgumentTable |
WorkflowTrackingCommentTable |
RefRecId |
Deleted Tables or Fields
Table |
Field |
|---|---|
WorkflowTrackingStatusTable |
ConfigurationId |
WorkflowTrackingStatusTable |
SubWorkflowActivityId |
WorkflowTrackingTable |
ContextCompanyId |
WorkflowTrackingTable |
ContextTableId |
WorkflowTrackingTable |
ContextRecId |
WorkflowTrackingTable |
CorrelationId |
WorkflowTrackingTable |
ConfigurationId |
WorkflowTrackingTable |
ElementId |
WorkflowTrackingTable |
StepId |
WorkflowTrackingTable |
WorkItemId |
WorkflowTrackingTable |
WorkItemActivityInstanceId |
WorkflowTrackingTable |
DueDateTime |
WorkflowTrackingTable |
Outcome |
WorkflowTrackingTable |
ToUser |
WorkflowTrackingTable |
WorkItemSubject |
WorkflowTrackingTable |
RootCorrelationId |
WorkflowTrackingTable |
ParentCorrelationId |
WorkflowTrackingTable |
SubWorkflowSequence |
WorkflowTrackingTable |
SubWorkflowId |