Table: dbo.Processed_Tax_Form
Any tax forms in this table have been processed. Tax forms are considered processed when they have been printed or magnetic media/internet files have been created for them.
Columns
Name | Type | Constraints | Description
processed_tax_form_KEY | int (4) | NOT NULL | The primary key, assigned by ACS.
client_KEY | int (4) | NOT NULL | The client the tax form was processed for.
tax_form_KEY | int (4) | NOT NULL | The tax form.
period_end_date | smalldatetime (4) | NOT NULL | The period end date for the tax form.
processed_date | smalldatetime (4) | NOT NULL | The most recent date within this period the tax form was processed.
print_job_subtype_KEY | int (4) |  | The print job subtype for the form (to identify types of W2s and 1099s).
local__tax_agent_system_KEY | int (4) |  | Tax agents in this column should always be marked as local in the Tax Agent table. This column is used for local W-2 copy 1s, since they are not in the TaxForm enumeration. The tax_form_KEY on these rows will be the state's W-2 copy 1. This column should be null if the form being stored is not a local copy 1
reprinted_date | date (3) |  | The most recent date within this period the tax form was reprinted. Intended for queries only.
reprint | bit (1) | NOT NULL | Flag used to determine if the processed tax form needs to be reprinted. Should only be true for form type W2 as enforced by the DAL constraint

Primary key
Name | Columns | Description
PK_Processed_Tax_Form | processed_tax_form_KEY |
Unique constraints
Name | Columns | Description
UK_Processed_Tax_Form$client_KEY$tax_form_KEY$period_end_date$print_job_subtype_KEY$local__tax_agent_system_KEY | client_KEY, tax_form_KEY, period_end_date, print_job_subtype_KEY, local__tax_agent_system_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Processed_Tax_Form__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Processed_Tax_Form__Print_Job_Subtype__print_job_subtype_KEY | print_job_subtype_KEY | Print_Job_Subtype (print_job_subtype_KEY) |
FK_Processed_Tax_Form__Tax_Form__tax_form_KEY | tax_form_KEY | Tax_Form (tax_form_KEY) |