Export Tax Withholding Tables - PYTXWE

The Export Tax Withholding Tables (PYTXWE) function exports all tax withholding tables from common code category PYTX for a given tax year into the CSV format. The utility prompts for the tax year and creates a CSV file in the format needed for the Import Tax Withholding Tables (PYTXWI) function. This utility is mostly be used to create the CSV files used for the import, but it can also be used by districts to move tax tables from one account to another, e.g., from test to production.

Tax Year: Enter the tax year for which tax withholding tables should be exported, e.g., 2019.

When the utility is run, PYTXWE selects all entries from common codes where:

• Code category is “PYTX”
• Ledger equals “@@”
• Third and fourth character of the code value is equal to the last two digits of the supplied tax year

For the example, the SQL select statement for tax year 2019 looks like this:

select * from cd_codes_mstr
where cd_category = 'PYTX' and cd_gr = '@@' and cd_code like '__19%'

CSV File

The utility creates a CSV file in the ..\admin\data directory of the App server, using the following naming convention:  

TaxTablesyyyy-ccyymmddhhmmss.csv   

Where yyyy = entered tax year and ccyymmddhhmmss equals the current date and time stamp of when the utility was run. 

For example, a file containing 2019 tax tables that was created on 5/29/2019 at 7:52 AM is named as follows: TaxTables2019-20190529075206.csv