Skip to content
logo Knowledgebase

What table stores an employees tax exemptions

Created on  | Last modified on  Highlight Matches

Summary

What tables is the tax info information held Where does Sage HRMS post the employee tax withholdings Tax info Sage HRMS Employee withholding status Number of tax exemptions Employees tax exemptions

Description

Cause

Resolution

Taxes are stored in UPEMPT however the tax fields (marital status, exemptions, etc) are in UPEMTF and the field or values are coded based on the tax. So the two fields you need to note are PARMSEQ and PARMVAL. The PARMSEQ is a numerical value that increments with each tax or person and corresponds with the fields on the screen (same order). If you open Tax info button on the Employee Payroll detail for USFIT, you will see 7 parameters, and in the database you will find each the for the employee that USFIT has 7 PARMSEQ.

The PARMVAL is the value in the field. For exemptions it is easy 1=1, 2=2 etc. but for other items like marital status, it is the same order as the drop down menu that you choose from (differs from tax to tax).

Example:

Lets say you wanted to add the number of exemptions on the USFIT tax code to a Crystal report, to do this you would create a formula field in Crystal using the below:

  • Set TAXID=USFIT, PARMSEQ =2 as conditions of the formula field and then use the value of PARMVAL
  • If TAXID="USFIT" and PARMSEQ="2" then PARMVAL