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

Affected Modules and Tables

Affected Modules
Human Resources

Affected Tables
HcmEmploymentDetail

Remarks

The Employment field in the HcmEmploymentDetail table is the foreign key to the HcmEmployment table. The TransitionReasonCode field in the HcmEmploymentDetail table is the foreign key to the HcmReasonCode table.

Data Migration Section

From Table: HRMPartyEmployeeRelationship	To Table: HcmEmploymentDetail
ValidFromDateTime	ValidFrom
ValidToDateTime	ValidTo
EmployerTerminationNoticeUnit	EmployerUnitOfNotice
EmployerTerminationNotice	EmployerNoticeAmount
EmployeeTerminationNoticeUnit	WorkerUnitOfNotice
EmployeeTerminationNotice	WorkerNoticeAmount
StartDate	WorkerStartDate
AdjustedStartDate	AdjustedWorkerStartDate
LastDateWorked	LastDateWorked
TerminationDate	TransitionDate

From Table: HcmEmployment	To Table: HcmEmploymentDetail
Recid	Employment

From Table: DEL_HRMReasonCode	To Table: HcmEmploymentDetail
del_MappingRecId	TransitionReasonCode