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

updatePayrollPositionEarningAssignment

Description

Inserts records into the PayrollPositionEarningAssignment table from the DEL_HRPPartyJobTableRelationship table, the DEL_EmplTable table and the PRLEmployeePayElements table.

Affected Modules and Tables

Affected Modules

Payroll

Affected Tables

PAYROLLPOSITIONEARNINGASSIGNMENT

HCMPOSITION

DEL_HRPPARTYPOSITIONTABLERELATIONSHIP

DEL_EMPLTABLE

PRLEMPLOYEEUSFEDERALTAXSETUP

DEL_HRPPARTYJOBTABLERELATIONSHIP

PRLEMPLOYEEPAYELEMENTS

PRLPAYELEMENTS

Remarks

This upgrade will create record in the PayrollPositionEarningAssignment table from the field in the PRLPayElements table, the PRLEmployeePayElements table and the HcmPosition table. Records in the PayrollPositionEarningAssignment table will only be created if the active or expired DEL_HRPPartyJobTableRelationship record exists that is associated to the identified DEL_EmplTable record. This upgrade will also create multiple versions if there are multiple PRLEmployeePayElements records for one position ID.

Data Migration Section

From Table: HcmPosition

To Table: PayrollPositionEarningAssignment

RecId

Position

From Table: PRLPayElements

To Table: PayrollPositionEarningAssignment

DEL_MappingRecId

EarningCode

From Table: PRLEmployeePayElements

To Table: PayrollPositionEarningAssignment

PayElementDate

ValidFrom

PayElementDate

ValidTo

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

PayrollPositionEarningAssignment