[{TableOfContents }]

!!!ADP TAXATION INTERFACE
!!Setting up the Tax Information

!IPPR
Each Payroll is linked to a specific “ADP Tax Company” and this information must be entered on [IPPR].  This is used in quarterly reporting.
 
!IMLN
There are two lexicons on [IMLN] that must be defined to link pay components to the correct tax type for reporting to ADP.
*[ADP_TAX_TYPE]\\Tax type indicates whether the amount is considered a deduction, contribution, subject amount or a taxable amount. These will be sent as a set to ADP for processing so it is important to setup three different pay components for each tax code sent to ADP.
*[ADP_TAX_CODE]\\These tax codes are determined between organizations and ADP and must be mapped in the ADP system to ensure that the amounts collected are applied to the correct tax accounts.

When setting up the tax codes, use the following code pattern:
*The first two characters of the tax code lexicon’s saved value will tell the interface what level of taxation it is and how it should be processed by the interface.  The following is the list of allowed codes (in the first two characters):
**FD – This indicates that it is a federal code. The interface will replace the FD with just an F to pass the code along to ADP. (For example, “FD MEDEE” will change to “F MEDEE” before being sent ADP)
**ST – This indicates that it is a specific state tax and the two-character code will be replaced by the two-character code of the state in which the tax applies. (For example, for the state of Arizona the code “ST SIT” would change to “AZ SIT” before being sent to ADP.)
**CT – This indicates that it is a city tax and the specific tax code will be retrieved from [IDGV] based on the jurisdiction determined from [IPPH]. 
**CN – This indicates that this is a county tax and the specific code for it will be retrieved from [IDGV] based on the jurisdiction listed on [IPPH].
**HT – This indicates that this is a head tax.
**SD – This indicates that this is a school district tax that will be determined from [IDGV] for this employee.
**XX – This is a special code that indicates that the code is an “exempt” code. The interface will remove the “XX” part of the code and then use the remainder of the code without any modifications. For example the code “XX665577” will be changed to “665577” and passed directly to ADP without any further modifications.
*The remaining characters of the tax code indicate the taxation type (e.g. FIT, SIT, etc.) as agreed to between your organization and ADP.

!IPPC
The ADP interface requires four components for each tax code including: Gross, Deduction, Subject and Taxable wages. The Gross amount is retrieved from an element in the payroll called “GROSS” but the remaining three components are setup as separate pay components in [IPPC].

There are three “External Interface Items” on the [IPPC Information|IPPC#InformationTab] tab.  These fields need to be defined in order to set up a code to be transferred to ADP for this taxation interface.
;[ADP Tax Code|ADP_TAX_CODE]:This field  holds the tax code that this pay component represents. These tax codes are determined between organizations and ADP and must be mapped in the ADP system to ensure that the amounts collected are applied to the correct tax accounts.
;[ADP Tax Type|ADP_TAX_TYPE]:Tax type indicates whether the amount is considered a deduction, contribution, subject amount or a taxable amount. These will be sent as a set to ADP for processing so it is important to set up three different pay components for each tax code sent to ADP.
;[ADP Tax Resident|ADP_TAX_RESIDENT]:If this toggle is checked, the tax is a resident (not work) tax. If it is listed as a resident tax then the system will use the “home” jurisdiction on the [IPPH] header to determine how to apply the tax otherwise it will use the “work” jurisdiction.

!IPPE
In order to transfer the correct amounts to ADP, a number of elements are required by the tax interface. These are defined in [IPPE].

#ADP_TAX_GROSS: This is the amount of Gross wages for inclusion in this interface. It can be a compound element.
#ADP_TAX_HRS_WORKED: This element will contain an amount equal to the eligible taxable hours worked for the employee during the pay period.
#ADP_TAX_RETIRE: This element holds the retirement earnings for the employee during the pay period.
#ADP_TAX_MOV_3RD
#ADP_TAX_ALLOW

!IDGV
On [IDGV], users must ensure that tax jurisdiction information and registration IDs for each type of tax that you are sending to ADP have been defined.

Users must fill in the ADP Tax Code on this form to reflect the tax code associated to this particular registration.
 
!IPVP
[IPVP] shows the pay runs that have been processed by the [UPADPTXP] update process.  If a user is beginning to use this functionality after a large number of pays have already been closed in the application, you may want to use SQL to set the value of this toggle so these past pays are not processed.
 
There are two interface programs for executing; one for the Periodic Interface and one for the Quarterly Interface.

!UPADPTXP – Periodic Interface
This program processes all pay headers ([IPPH]) in each pay run for the selected payroll where the Pay Run stage is “Closed” or “Journalized” and the ADP SUBMITTED toggle in [IPVP] is not checked.

There is no mechanism for selecting individual pay runs within a payroll; all pay runs that are not yet processed will be picked up.

If you run this program with the "Trial Run" field set to NO, the Pay Run toggle will be checked at the end of the processing.  Running it with the "Trial Mode" set to YES, or not defined, the Pay Run toggle will not be checked, and users can reprocess the pay runs over and over again.

The directory defined is a database server-centric directory that must be accessible by the data base server processes.

This process will also update the table [P2K_PR_ADP_TAX_INTERFACES] with the summarized data.  This is used for subsequent reporting by the [UPADPTXQ] (Quarterly Interface) process, and can be viewed with [VPADPI].

!UPADPTXQ – Quarterly Interface
The [UPADPTXQ] program will process and produce a quarterly taxation file for ADP, for the selected ADP Tax Company (defined in [IPPR]).

The List Of Values (LOV) lookup may show multiple values for the same ADP Tax Company, if the same value is used on multiple payrolls.  This is a known issue and has no impact on the processing.

%%information Note: This process will report and summarize the data as previously run on [UPADPTXP] interface runs.  If a users does not have a complete quarter’s worth of data processed by [UPADPTXP], then this file will not reflect the correct values.%%
 
!VPADPI - Viewing ADP Interface Data 
[VPADPI] is a view-only form that displays the extensive data created by the [UPADPTXP] process.

----
![Notes|Edit:Internal.ADP_TAXATION_INTERFACE]
[{InsertPage page='Internal.ADP_TAXATION_INTERFACE' default='Click to create a new notes page'}]