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. |
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 |