ReleaseUpdateDB60_HRM.updateHcmJobDetail 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	updateHcmJobDetail
Description	Inserts data into the HcmJobDetail table from the HRPPartyJobTableRelationship table.

Affected Modules and Tables

Affected Modules
Human Resources

Affected Tables
HcmJobDetail
HRPPartyJobTableRelationship
HcmJob
HRMCompJobFunction
HRMCompJobType
HcmCompensationLevel
HcmTitle
HcmSurveyCompany
HcmJobDetail

Remarks

1. The Job field, which holds a record ID from the HcmJob table, replaces the JobId field.

2. The JobFunction field, which holds a record ID from the HcmJobFunction table, replaces the HrmCompJobFunctionId field.

3. The JobType field, which holds record ID from the HcmJobType table, replaces the HrmCompJobTypeId field.

4. The CompensationLevel field, which holds record ID from the HcmCompensationLevel table, replaces the HrmCompLevelId field.

Data Migration Section

From Table: HRPPartyJobTableRelationship	To Table: HcmJobDetail

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
HcmJobDetail

Deleted Tables or Fields

Table	Field
HRPPartyJobTableRelationship	*