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

updateHcmWorkerAffiliationAdvHolder_RU

Description

Inserts records into the HcmWorkerAffiliationAdvHolder_RU table from the EmplTable table.

Affected Modules and Tables

Affected Modules

Human Resources

Affected Tables

HcmWorkerAffiliationAdvHolder_RU

Remarks

The WorkerAffiliation field in the HcmWorkerAffiliationAdvHolder_RU table is the foreign key for the HcmWorkerAffiliation table. The WorkerGroup field in the HcmWorkerAffiliationAdvHolder_RU table is the foreign key for the HcmWorkerGroup_RU table. The IdentityCard field in the HcmWorkerAffiliationAdvHolder_RU table is the foreign key for the HcmIdentityCardTable_RU table.

Data Migration Section

From Table: HRMPartyEmployeeRelationship

To Table: HcmWorkerAffiliationAdvHolder_RU

ValidFromDateTime

ValidFrom

From Table: HcmIdentityCardTable_RU

To Table: HcmWorkerAffiliationAdvHolder_RU

RecId

IdentityCard

From Table: EmplTable

To Table: HcmWorkerAffiliationAdvHolder_RU

IdentityCardNumber_RU

IdentityCardNumber

IdentityCardIssueBy_RU

IdentityCardIssueBy

IdentityCardIssueDate_RU

IdentityCardIssueDate

IdentityCardSeries_RU

IdentityCardSeries

AdvHolder_RU

AdvHolder

From Table: HcmWorkerGroup_RU

To Table: HcmWorkerAffiliationAdvHolder_RU

RecId

WorkerGroup

From Table: HcmWorkerAffiliation

To Table: HcmWorkerAffiliationAdvHolder_RU

RecId

WorkerAffiliation

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

HcmWorkerAffiliationAdvHolder_RU