Condividi tramite


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

updateHcmEmploymentVacation

Description

Inserts records into the HcmEmploymentVacation table from the DEL_HRMPartyEmployeeRelationship table.

Affected Modules and Tables

Affected Modules

Human Resources

Affected Tables

HcmEmploymentVacation

Remarks

The Employment field in the HcmEmploymentVacation table is the foreign key to the HcmEmployment table.

Data Migration Section

From Table: DEL_HRMPartyEmployeeRelationship

To Table: HcmEmploymentVacation

ValidFromDateTime

ValidFrom

ValidToDateTime

ValidTo

Holidays

HolidaysPerYear

TotalVacationHours

VacationHoursTotal

VacationHoursTaken

VacationHoursTaken

VacationHoursLeft

VacationHoursLeft

VacationHoursCarriedOver

VacationHoursCarriedOver

VacationPayment

VacationPay

VacationWithSalary

IsPaidVacation

CareWithSalary

IsPaidPersonalDays

DaysOffWithSalary

IsPaidHolidays

From Table: HcmEmployment

To Table: HcmEmploymentVacation

RecId

Employment

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

HcmEmploymentVacation

*