ReleaseUpdateDB60_Payroll.updatePayrollPositionDetails Upgrade Script [AX 2012]
Updated: June 15, 2012
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 |
|---|
|
Payroll |
|
Affected Tables |
|---|
|
PAYROLLPOSITIONDETAILS |
|
HCMPOSITION |
|
DEL_HRPPARTYPOSITIONTABLERELATIONSHIP |
|
DEL_EMPLTABLE |
|
PRLEMPLOYEEUSFEDERALTAXSETUP |
|
PAYROLLPAYCYCLE |
|
PRLEMPLGROUP |
|
DEL_HRPPARTYJOBTABLERELATIONSHIP |
|
HcmEmploymentLeave |
|
HcmLeaveType |
|
WorkCalendarTable |
|
WorkCalendarDate |
|
WorkCalendarDateLine |
|
WorkTimeTable |
|
WorkTimeLine |
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.
|
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 |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).