Compartir a través de


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

updateHRMAbsenceTable

Description

Populates the Worker, Worker_PostedBy, Worker_ApprovedBy, and Worker_RejectedBy fields in the HRMAbsenceTable table.

Affected Modules and Tables

Affected Modules

Human Resources

Affected Tables

DirPerson

EmplTable

HcmWorker

HRMAbsenceTable

Remarks

Populates the Worker field in the HRMAbsenceTable table from the EmplId field in the HRMAbsenceTable table. Populates the Worker_PostedBy field in the HRMAbsenceTable table from the PostedBy field in the HRMAbsenceTable table. Populates the Worker_ApprovedBy field in the HRMAbsenceTable table from the ApprovedBy field in the HRMAbsenceTable table. Populates the Worker_RejectedBy field in the HRMAbsenceTable table from the RejectedBy field in the HRMAbsenceTable table.

Data Migration Section

From Table: HRMAbsenceTable

To Table: HRMAbsenceTable

EmplId

Worker

PostedBy

PostedBy

ApprovedBy

Worker_ApprovedBy

RejectedBy

RejectedBy

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

HRMAbsenceTable

Worker

HcmWorkerRecId

PostedBy

HcmWorkerRecId

Worker_ApprovedBy

HcmWorkerRecId

RejectedBy

HcmWorkerRecId

Name Changes for Tables or Fields

Old Table Name: HRMAbsenceTable

New Table Name: HRMAbsenceTable

Old Field Name:

New Field Name:

EmplId

DEL_EmplId

PostedBy

DEL_PostedBy

Worker_ApprovedBy

DEL_Worker_ApprovedBy

RejectedBy

DEL_RejectedBy