ReleaseUpdateDB60_Payroll.updatePayrollWorkerTaxCodeParameterValue 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	updatePayrollWorkerTaxCodeParameterValue
Description	Updates records in the PayrollWorkerTaxCodeParameterValue table by using values from the following tables: PrlEmployeeUSFederalTaxSetup, PrlEmployeeUSStateTaxSetup, and PrlEmployeeUSLocalTaxSetup.

Affected Modules and Tables

Affected Modules
Payroll

Affected Tables
PAYROLLWORKERTAXCODEPARAMETERVALUE
PAYROLLWORKERTAXCODE
PAYROLLTAXCODE
PAYROLLTAXCODEPARAMETER
PAYROLLTAXENGINETAXCODE
PRLEMPLOYEEUSFEDERALTAXSETUP
PRLEMPLOYEEUSSTATETAXSETUP
PRLEMPLOYEEUSLOCALTAXSETUP
LOGISTICSADDRESSCOUNTRYREGION
PRLLOCALWITHHOLDING

Remarks

The PrlEmployeeUSFederalTaxSetup table contains all the federal tax setup information. The PrlEmployeeUSStateTaxSetup table contains all the state tax setup information. The PrlEmployeeUSLocalTaxSetup table contains all the local tax setup information.

Data Migration Section

From Table: PrlEmployeeUSFederalTaxSetup	To Table: PayrollWorkerTaxCodeParameterValue
SUTAExemptStatusER	Value
FicaExemptStatusER	Value
FUTAExemptStatusER	Value
FicaExemptStatus	Value
ExptFedWH	Value
MedicareExemptStatus	Value
IsStatutoryEmployee	Value
HasRetirementPlan	Value
HasThirdPartySick	Value
SUTAState	Value
AdditionalFedWithholding	Value
FederalFilingStatus	Value
NumExempt	Value

From Table: PrlEmployeeUSStateTaxSetup	To Table: PayrollWorkerTaxCodeParameterValue
StateExempt	Value
AdditionalStateWithholding	Value
NonResidentCertificate	Value
SupplementalCalculationMethod	Value
MiscellaneousValues	Value

From Table: PrlEmployeeUSLocalTaxSetup	To Table: PayrollWorkerTaxCodeParameterValue
CityExemptions	Value
MiscellaneousValues	Value