Compartir a través de


ReleaseUpdateDB60_HRM.updateHcmWorkerBasic 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

updateHcmWorkerBasic

Description

Inserts records into the HcmWorker table, the HcmPersonnelNumber table, the HcmEmployeeAffiliation table, and the HcmContractorAffiliation table from the EmplTable table.

Affected Modules and Tables

Affected Modules

Human Resources

Affected Tables

CompanyInfo

EmplTable

HcmContractorAffiliation

HcmEmployeeAffiliation

HcmPersonnelNumber

HcmWorker

HRMPartyEmployeeRelationship

Remarks

The Person field in the HcmWorker table is the foreign key to the DirPerson table. The Worker field in the HcmPersonnelNumber table is the foreign key to the HcmWorker table. The Worker field in the HcmEmployeeAffiliation table is the foreign key to the HcmWorker table. The Worker field in the HcmContractorAffiliation table is the foreign key to the HcmWorker table.

Data Migration Section

From Table: EmplTable

To Table: HcmWorker

From Table: EmplTable

To Table: HcmPersonnelNumber

From Table: EmplTable

To Table: HcmEmployeeAffiliation

From Table: EmplTable

To Table: HcmContractorAffiliation

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

HcmWorker

HcmPersonnelNumber

HcmEmployeeAffiliation

HcmContractorAffiliation

Deleted Tables or Fields

Table

Field

EmplTable

*