Table Information for the Recompute Taxable Wages Screen

Changes to the Recompute Taxable Wages screen update the EMPL_EARNINGS table.

If State is selected in the Tax Types group box, this screen also updates the EMPL_EARN_STATE table.

Report Sources

DED_CD
DED_STATE_TXBL
EMPL
EMPL_EARNINGS
EMPL_EARN_DED
EMPL_EARN_PAY_TYPE
EMPL_TAX
FED_TAX_INFO
MULTI_CO_ST_OVRD
PAY_TYPE_ST_TXBL
PAY_TYPE_TXBL
STATE_TAX_HS
TAXBLE_ENTITY

Report Columns

Column Heading	Screen	Table Name
Employee Name	Manage Employee Information	EMPL
FY/ PD/ Post Seq No	Manage Employee Earnings History	EMPL_EARNINGS
Check Dt/Chk Type	Manage Employee Earnings History	EMPL_EARNINGS
Federal Wages Exempt Pay Types Exempt Deductions Before	Manage Employee Earnings History	EMPL_EARNINGS
Federal Wages Exempt Pay Types Exempt Deductions After	Recalculated based on the information from Manage Employee Taxes	EMPL_TAX
Social Security Wages Exempt Pay Types Exempt Deductions Before	Manage Employee Earnings History	EMPL_EARNINGS
Social Security Wages Exempt Pay Types Exempt Deductions After	Recalculated based on the information from Manage Employee Taxes	EMPL_TAX
Medicare Wages Exempt Pay Types Exempt Deductions Before	Manage Employee Earnings History	EMPL_EARNINGS
Medicare Wages Exempt Pay Types Exempt Deductions After	Recalculated based on the information from Manage Employee Taxes	EMPL_TAX
FUTA Wages Accrued Before	Manage Employee Earnings History	EMPL_EARNINGS
FUTA Wages Accrued After	Recalculated based on the information from Manage Employee Taxes	EMPL_TAX
State Wages SUTA Wages SUTA Accrued Before	Manage Employee Earnings History	EMPL_EARNINGS
State Wages SUTA Wages SUTA Accrued After	Recalculated based on the information from Manage Employee Taxes	EMPL_TAX

JavaScript must be enabled in order to use this site.Please enable JavaScript in your browser and refresh the page.

Table Information for the Recompute Taxable Wages Screen

Changes to the Recompute Taxable Wages screen update the EMPL_EARNINGS table.

If State is selected in the Tax Types group box, this screen also updates the EMPL_EARN_STATE table.

Report Sources

DED_CD
DED_STATE_TXBL
EMPL
EMPL_EARNINGS
EMPL_EARN_DED
EMPL_EARN_PAY_TYPE
EMPL_TAX
FED_TAX_INFO
MULTI_CO_ST_OVRD
PAY_TYPE_ST_TXBL
PAY_TYPE_TXBL
STATE_TAX_HS
TAXBLE_ENTITY

Report Columns

Column Heading	Screen	Table Name
Employee Name	Manage Employee Information	EMPL
FY/ PD/ Post Seq No	Manage Employee Earnings History	EMPL_EARNINGS
Check Dt/Chk Type	Manage Employee Earnings History	EMPL_EARNINGS
Federal Wages Exempt Pay Types Exempt Deductions Before	Manage Employee Earnings History	EMPL_EARNINGS
Federal Wages Exempt Pay Types Exempt Deductions After	Recalculated based on the information from Manage Employee Taxes	EMPL_TAX
Social Security Wages Exempt Pay Types Exempt Deductions Before	Manage Employee Earnings History	EMPL_EARNINGS
Social Security Wages Exempt Pay Types Exempt Deductions After	Recalculated based on the information from Manage Employee Taxes	EMPL_TAX
Medicare Wages Exempt Pay Types Exempt Deductions Before	Manage Employee Earnings History	EMPL_EARNINGS
Medicare Wages Exempt Pay Types Exempt Deductions After	Recalculated based on the information from Manage Employee Taxes	EMPL_TAX
FUTA Wages Accrued Before	Manage Employee Earnings History	EMPL_EARNINGS
FUTA Wages Accrued After	Recalculated based on the information from Manage Employee Taxes	EMPL_TAX
State Wages SUTA Wages SUTA Accrued Before	Manage Employee Earnings History	EMPL_EARNINGS
State Wages SUTA Wages SUTA Accrued After	Recalculated based on the information from Manage Employee Taxes	EMPL_TAX