ReleaseUpdateDB60_HRM.updateHRMCompEventEmpl 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	updateHRMCompEventEmpl
Description	Updates the Department and Worker fields in the HRMCompEventEmpl table.

Affected Modules and Tables

Affected Modules
Human Resources

Affected Tables
HRMCompEventEmpl

Remarks

Updates the Department field in the HRMCompEventEmpl table with the corresponding value from the Party field in the DEL_DirPartyInternalOrganizationTable table, which is a foreign key to the OMDepartment table. Updates the Worker field in the HRMCompEventEmpl table with the corresponding value from the record ID field in the HcmWorker table.

Data Migration Section

From Table: HRMCompEventEmpl	To Table: HRMCompEventEmpl
del_OrganizationUnitId	Department
del_EmplId	Worker

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
HRMCompEventEmpl	Department	OMDepartmentRecId
HRMCompEventEmpl	Worker	HcmWorkerRecId

Deleted Tables or Fields

Table	Field
HRMCompEventEmpl	del_OrganizationUnitId
HRMCompEventEmpl	del_EmplId