What table stores employees tax exemptions

Understand tax parameter storage

• UPEMPT stores employee tax records
• UPEMTF stores tax parameter fields and values
• PARMSEQ defines the field position for each tax
• PARMVAL stores the selected value for that field

Identify parmseq values

• PARMSEQ increments for each tax parameter per employee
• The parameter order matches the on-screen field order
• USFIT tax includes seven parameters in Employee Payroll detail
• Each employee record includes seven PARMSEQ entries for USFIT

Interpret parmval values

• PARMVAL stores the numeric value for each parameter
• Exemptions map directly to numeric values
• Marital status values follow the dropdown order
• Dropdown order varies by tax code

Create a crystal report formula

Example of using a formula field to extract USFIT exemptions. Set the following conditions:

To add USFIT exemptions from a Crystal Report, create a formula field using the following.

• 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 PARMVALd PARMSEQ="2" then PARMVAL