Condividi tramite


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