ReleaseUpdateDB60_Basic.updateWorkflowTracking Upgrade Script [AX 2012]
Updated: March 24, 2011
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. |
|
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 |
|
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 |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).