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
NameTypeConstraintsDescription
processed_tax_form_KEYint (4)NOT NULLThe primary key, assigned by ACS.
client_KEYint (4)NOT NULLThe client the tax form was processed for.
tax_form_KEYint (4)NOT NULLThe tax form.
period_end_datesmalldatetime (4)NOT NULLThe period end date for the tax form.
processed_datesmalldatetime (4)NOT NULLThe most recent date within this period the tax form was processed.
print_job_subtype_KEYint (4)The print job subtype for the form (to identify types of W2s and 1099s).
local__tax_agent_system_KEYint (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_datedate (3)The most recent date within this period the tax form was reprinted. Intended for queries only.
reprintbit (1)NOT NULLFlag 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
NameColumnsDescription
PK_Processed_Tax_Formprocessed_tax_form_KEY
Unique constraints
NameColumnsDescription
UK_Processed_Tax_Form$client_KEY$tax_form_KEY$period_end_date$print_job_subtype_KEY$local__tax_agent_system_KEYclient_KEY, tax_form_KEY, period_end_date, print_job_subtype_KEY, local__tax_agent_system_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Processed_Tax_Form__Client__client_KEYclient_KEYClient (client_KEY)
FK_Processed_Tax_Form__Print_Job_Subtype__print_job_subtype_KEYprint_job_subtype_KEYPrint_Job_Subtype (print_job_subtype_KEY)
FK_Processed_Tax_Form__Tax_Form__tax_form_KEYtax_form_KEYTax_Form (tax_form_KEY)

Schema diagram