ReleaseUpdateDB60_HRM.updateHcmSkill

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

Class

ReleaseUpdateDB60_HRM

Method

updateHcmSkill

Description

Inserts records into the <c>HcmSkill</c> table from the <c>HRMSkill</c> table.

Affected Modules and Tables

Affected Modules

Human Resources

Affected Tables

HcmRatingModel

HcmSkill

HRMSkill

HRMSkillType

Remarks

This upgrade will retain the data of each company by appending the <c>DataAreaId</c> field to the <c>SkillId</c> field of the <c>HRMSkill</c> table to create new, unique identifiers for the <c>HcmSkill</c> table when multiple companies exist. If only one company exists, the <c>DataAreaId</c> field will not be appended. The <c>SkillType</c> field in the <c>HcmSkill</c> table is the foreign key to the <c>HcmSkillType</c> table. The <c>RatingModel</c> field in the <c>HcmSkill</c> table is the foreign key to the <c>HcmRatingModel</c> table.

Data Migration Section

From Table: HRMSkill

To Table: HcmSkill

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

HcmSkill

Deleted Tables or Fields

Table

Field

HRMSkill

*