ReleaseUpdateDB60_HRM.updateHcmEmploymentDetail Upgrade Script

  • Article

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