ReleaseUpdateDB60_Payroll.updatePayrollPositionDetails 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

updatePayrollPositionDetails

Description

Inserts records into the PayrollPositionDetails table from the DEL_HRPPartyPositionTable, DEL_EmplTable and PayrollPayCycle tables.

Affected Modules and Tables

Affected Modules

Payroll

Affected Tables

PAYROLLPOSITIONDETAILS

HCMPOSITION

DEL_HRPPARTYPOSITIONTABLERELATIONSHIP

DEL_EMPLTABLE

PRLEMPLOYEEUSFEDERALTAXSETUP

PAYROLLPAYCYCLE

PRLEMPLGROUP

DEL_HRPPARTYJOBTABLERELATIONSHIP

HcmEmploymentLeave

HcmLeaveType

WorkCalendarTable

WorkCalendarDate

WorkCalendarDateLine

WorkTimeTable

WorkTimeLine

Remarks

This upgrade will create a record in the PayrollPositionDetails table from the fields in the DEL_EmplTable table, and the HcmPosition table. Records in the PayrollPositionDetails table will only be created if the "active" or "expired" DEL_HRPPartyTableRelationship record exists that is associated to the identified DEL_EmplTable table record. The schedules are created and assigned to the schedule field of the PayrollPositionDetails table when a schedule is needed for the GenerateEarningsFromSchedule field of the PayrollPositionDetails table is set to true or a record in the HcmEmploymentLeave table is created for the worker assigned to position.

Data Migration Section

From Table: HCMPosition

To Table: PayrollPositionDetails

RecID

Position

From Table: Del_EmplTable

To Table: PayrollPositionDetails

DEL_PRLNormHrs

PayrollNormalHours

DEL_PRLOThrs

PayrollOvertimeHours

DataAreaID

PaidByLegalEntity

PRLCompanyOfficer

IsCompanyOfficer

From Table: PayrollPayCycle

To Table: PayrollPositionDetails

RecId

PayCycle

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

PayrollPositionDetails