ReleaseUpdateDB60_HRM.updateHcmIssuingAgency

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

Class

ReleaseUpdateDB60_HRM

Method

updateHcmIssuingAgency

Description

Inserts records into the <c>HcmIssuingAgency</c> table from the <c>HRMi9IssuingAuthority</c> table.

Affected Modules and Tables

Affected Modules

Human Resources

Affected Tables

HcmIssuingAgency

HRMi9IssuingAuthority

Remarks

This upgrade will discard duplicate records if the <c>IssuingAuthorityId</c> field, the <c>Name</c> field and the <c>Location</c> field of the <c>HRMi9IssuingAuthority</c> table are identical. The new unique identifier <c>IssuingAgencyId</c> field of the <c>HcmIssuingAgency</c> table combines the <c>IssuingAuthorityId</c> field and the <c>DataAreaId</c> field of the <c>HRMi9IssuingAuthority</c> table from the first record found. All records found that are identified as duplicates in other companies will be discarded. If only one company exists, the <c>DataAreaId</c> field will not be appended.

Data Migration Section

From Table: HRMi9IssuingAuthority

To Table: HcmIssuingAgency

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

HcmIssuingAgency

Deleted Tables or Fields

Table

Field

HRMi9IssuingAuthority

*