ReleaseUpdateDB60_HRM.updateHcmEmploymentDetail Upgrade Script [AX 2012]

Updated: July 19, 2010

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

Human Resources

Affected Tables

HcmEmploymentDetail

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.

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


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: