Compartilhar via


ReleaseUpdateDB60_HRM.updateHcmWorkerNonHcm 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_HRM

Method

updateHcmWorkerNonHcm

Description

Inserts records into the OutlookWorkerSetup table, the ProjWorkerSetup table, the PurchRFQWorkerSetup table, and the SMADispatchWorkerSetup table from the EmplTable table.

Affected Modules and Tables

Affected Modules

Human Resources

Affected Tables

EmplTable

HcmWorker

HRMPartyEmployeeRelationship

OutlookWorkerSetup

ProjWorkerSetup

PurchRFQWorkerSetup

SMADispatchWorkerSetup

Remarks

This upgrade is identified as "not discard duplicates". The Worker field in the OutlookWorkerSetup table is the foreign key to the HcmWorker table. The Worker field in the ProjWorkerSetup table is the foreign key to the HcmWorker table. The Worker field in the PurchRFQWorkerSetup table is the foreign key to the HcmWorker table. The Worker field in the SMADispatchWorkerSetup table is the foreign key to the HcmWorker table.

Data Migration Section

From Table: EmplTable

To Table: OutlookWorkerSetup

From Table: EmplTable

To Table: ProjWorkerSetup

From Table: EmplTable

To Table: PurchRFQWorkerSetup

From Table: EmplTable

To Table: SMADispatchWorkerSetup

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

OutlookWorkerSetup

ProjWorkerSetup

PurchRFQWorkerSetup

SMADispatchWorkerSetup

Deleted Tables or Fields

Table

Field

EmplTable

*