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

updateHcmCertificateType

Description

Inserts records into the HcmCertificateType table from the DEL_HRMCertificateType table.

Affected Modules and Tables

Affected Modules

Human Resources

Affected Tables

HcmCertificateType

DEL_HRMCertificateType

Remarks

This upgrade will discard duplicate records if the HrmCertificateTypeId field and the Description field of the DEL_HRMCertificateType table are identical. The new unique identifier CertificateTypeId field of the HcmCertificateType table combines the HrmCertificateTypeId field and the DataAreaId field of the DEL_HRMCertificateType 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 DataAreaId field will not be appended.

Data Migration Section

From Table: DEL_HRMCertificateType

To Table: HcmCertificateType

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

HcmCertificateType

*

Deleted Tables or Fields

Table

Field

DEL_HRMCertificateType

*