Share via

ReleaseUpdateDB60_Payroll.updatePayrollPayCycle Upgrade Script

  • Article

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

Class

ReleaseUpdateDB60_Payroll

Method

updatePayrollPayCycle

Description

Inserts records into the PayrollPayCycle table from the DEL_PRLPayPeriodMaster table.

Affected Modules and Tables

Affected Modules

Payroll

Affected Tables

PAYROLLPAYCYCLE

DEL_PRLPAYROLLPERIODMASTER

Remarks

This upgrade will retain the data of each company by appending the DataAreaId field to the PayrollPeriodId field of the DEL_PRLPayrollPeriodMaster table to create new, unique identifiers for the PayrollPayCycle table when multiple companies exist. If only one company exists, the DataAreaId field will not be appended. The enum values for the TimePeriod field differ from the values of the PRLPayPeriodEnum enumeration. To correctly map the existing value to the new value, one is added to the TimePeriod field value during the upgrade.

Data Migration Section

From Table: DEL_PRLPayrollPeriodMaster

To Table: PayrollPayCycle

PayrollPeriodId

PayCycleID

Description

Description

PRLPayPeriodEnum

TimePeriod