ReleaseUpdateDB60_KM.updateKMKnowledgeCollectorPlanningTable Upgrade Script

  • Article

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Class

ReleaseUpdateDB60_KM

Method

updateKMKnowledgeCollectorPlanningTable

Description

Updates the ResponsibleWorker field of the KMKnowledgeCollectorPlanningTable table with the corresponding value from the RecId field of the HcmWorker table.

Affected Modules and Tables

Affected Modules

Human Resources

Affected Tables

KMKnowledgeCollectorPlanningTable

EmplTable

HcmWorker

Remarks

The ResponsibleWorker field, which has the RecId value from the HcmWorker table, replaces the Responsible field.

Data Migration Section

From Table: KMKnowledgeCollectorPlanningTable

To Table: KMKnowledgeCollectorPlanningTable

Responsible

ResponsibleWorker

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

KMKnowledgeCollectorPlanningTable

ResponsibleWorker

HcmWorkerRecId

Deleted Tables or Fields

Table

Field

EmplTable

*

Name Changes for Tables or Fields

Old Table Name: KMKnowledgeCollectorPlanningTable

New Table Name: KMKnowledgeCollectorPlanningTable

Old Field Name:

New Field Name:

Responsible

DEL_Responsible