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	*