Table: dbo.W2_Rendered_Template
Table used to store pre-rendered form template documents used during W2 processing.
Columns
NameTypeConstraintsDescription
w2_rendered_template_KEYint (4)NOT NULLPrimary key for table.
form_yearint (4)NOT NULLFiling year of the template
report_definition_KEYint (4)Key of the associated report; a null value means the document is associated with a tax form instead of a report.
template_documentvarbinary (-1)NOT NULLCached ActiveReport page of a particular W2 form, includes only the form graphics.
tax_form_KEYint (4)Key of the associated tax form; a null value means the document is associated with a report instead of a tax form.
render_datesmalldatetime (4)NOT NULLDate the document was rendered.
Primary key
NameColumnsDescription
PK_W2_Rendered_Templatew2_rendered_template_KEY
Unique constraints
NameColumnsDescription
UK_W2_Rendered_Template$form_year$report_definition_KEY$tax_form_KEYform_year, report_definition_KEY, tax_form_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_W2_Rendered_Template__Report_Definition__report_definition_KEYreport_definition_KEYReport_Definition (report_definition_KEY)
FK_W2_Rendered_Template__Tax_Form__tax_form_KEYtax_form_KEYTax_Form (tax_form_KEY)

Schema diagram