Compartir a través de


ReleaseUpdateTransformDB50_Basic.updateEmplTableDelta 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

ReleaseUpdateTransformDB50_Basic

Method

updateEmplTableDelta

Description

Updates the party field in the EmplTable table and creates data in the HCMWorker and HCMEmployment tables from data in the EmplTable table.

Script Type

Preprocessing 60: Delta

Microsoft Dynamics AX Source

Microsoft Dynamics AX 4.0

Microsoft Dynamics AX 2009

Affected Modules and Tables

Affected Modules

Human Resources

Affected Tables

EmplTable

Remarks

This upgrade is required in order to convert the partyId field to the new party field for Microsoft Dynamics AX 2012. The party for the EmplTable table will be kept as a reference to the DirPartyTable record. This also creates data in the HCMWorker and HCMEmployment tables from data in the EmplTable table.

Data Migration Section

From Table: EmplTable

To Table: EmplTable

PartyId

Party

From Table: EmplTable

To Table: HCMWorker

emplId

PersonnelNumber

Party

Person

From Table: EmplTable

To Table: HCMEmployment

dataAreaId

LegalEnitiy

dimension

DefaultDimension

From Table: HRMPartyEmployeeRelationship

To Table: HCMEmployment

EmployeeType

EmploymentType

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

EmplTable

Party

HCMWorker

HCMEmployment

Deleted Tables or Fields

Table

Field

EmplTable

PartyId