ReleaseUpdateDB60_HRM.updateHcmWorkerBasic 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	updateHcmWorkerBasic
Description	Inserts records into the HcmWorker table, the HcmPersonnelNumber table, the HcmEmployeeAffiliation table, and the HcmContractorAffiliation table from the EmplTable table.

Affected Modules and Tables

Affected Modules
Human Resources

Affected Tables
CompanyInfo
EmplTable
HcmContractorAffiliation
HcmEmployeeAffiliation
HcmPersonnelNumber
HcmWorker
HRMPartyEmployeeRelationship

Remarks

The Person field in the HcmWorker table is the foreign key to the DirPerson table. The Worker field in the HcmPersonnelNumber table is the foreign key to the HcmWorker table. The Worker field in the HcmEmployeeAffiliation table is the foreign key to the HcmWorker table. The Worker field in the HcmContractorAffiliation table is the foreign key to the HcmWorker table.

Data Migration Section

From Table: EmplTable	To Table: HcmWorker

From Table: EmplTable	To Table: HcmPersonnelNumber

From Table: EmplTable	To Table: HcmEmployeeAffiliation

From Table: EmplTable	To Table: HcmContractorAffiliation

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
HcmWorker
HcmPersonnelNumber
HcmEmployeeAffiliation
HcmContractorAffiliation

Deleted Tables or Fields

Table	Field
EmplTable	*