ReleaseUpdateDB60_HRM.updateHcmEmploymentEmployee 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	updateHcmEmploymentEmployee
Description	Inserts records into the HcmEmploymentEmployee table from the HRMPartyEmployeeRelationship table.

Affected Modules and Tables

Affected Modules
Human Resources

Affected Tables
HcmEmploymentEmployee

Remarks

The Employment field in the HcmEmploymentEmployee table is the foreign key to the HcmEmployment table. The IncomeTaxCategory field in the HcmEmploymentEmployee table is the foreign key to the HcmIncomeTaxCategory table. The IncomeTaxCode field in the HcmEmploymentEmployee table is the foreign key to the HcmIncomeTaxCode table.

Data Migration Section

From Table: HRMPartyEmployeeRelationship	To Table: HcmEmploymentEmployee
ValidToDateTime	ValidTo
ValidFromDateTime	ValidFrom
PayrollCurrency	Currency
PayrollSalaryScaleDate	SalaryScaleDate
PayrollSalarySeniorityDate	SalarySeniorityDate
PayrollSalaryType	SalaryType
EmployeeSavingAmount	EmployeeSavingAmount
EmployerSavingAmount	EmployerSavingAmount
PensionStart	PensionStartDateEmpl
ProbationEndDate	ProbationDate
PensionEnrollment	PensionStartDateEmplContract
SeniorityDate	SeniorityDate

From Table: DEL_HRMIncomeTaxCategory	To Table: HcmEmploymentEmployee
del_MappingRecId	IncomeTaxCategory

From Table: DEL_HRMIncomeTaxCode	To Table: HcmEmploymentEmployee
del_MappingRecId	IncomeTaxCode

From Table: HcmEmployment	To Table: HcmEmploymentEmployee
RecId	Employment