ReleaseUpdateDB60_Payroll.updatePayrollPayCycle 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_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