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