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

Affected Modules and Tables

Affected Modules
Human Resources

Affected Tables
HRMCompVarEnrollEmplLine

Remarks

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

Data Migration Section

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

New Tables or Fields

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

Deleted Tables or Fields

Table	Field
HRMCompVarEnrollEmplLine	del_OrganizationUnitId
	del_EmplId