Table: dbo.Client_W2_Rendered_Document
Table used to store pre-rendered documents which are included in the client W2 package; the federal transmittal documents (W3) and state/local client transmittals (names vary by locality)
Columns
NameTypeConstraintsDescription
client_w2_rendered_document_KEYint (4)NOT NULLPrimary key for table.
form_yearint (4)NOT NULLFiling year of the document
client_KEYint (4)NOT NULLPrimary key of the client associated with this row's documents.
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.
facsimile_documentvarbinary (-1)Cached ActiveReport page of a particular W2 form, the facsimile copy which includes all form graphics plus field data.
data_only_documentvarbinary (-1)Cached ActiveReport page of a particular W2 form, the pre-printed copy which only includes field data, no form graphics.
barcode_overlay_documentvarbinary (-1)Cached ActiveReport page of a W2 barcode for the w2 documents. User option to include, so we dynamically overlay when it's required.
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_Client_W2_Rendered_Documentclient_w2_rendered_document_KEY
Unique constraints
NameColumnsDescription
UK_Client_W2_Rendered_Document$form_year$report_definition_KEY$tax_form_KEY$client_KEYform_year, report_definition_KEY, tax_form_KEY, client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_W2_Rendered_Document__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_W2_Rendered_Document__Report_Definition__report_definition_KEYreport_definition_KEYReport_Definition (report_definition_KEY)
FK_Client_W2_Rendered_Document__Tax_Form__tax_form_KEYtax_form_KEYTax_Form (tax_form_KEY)

Schema diagram