Table: dbo.Employee_W2_Rendered_Datashare
Table used to store pre-rendered employee datasharing xml that will be exported for import by other applications.
Columns
NameTypeConstraintsDescription
employee_w2_rendered_datashare_KEYint (4)NOT NULLPrimary key for table.
form_yearint (4)NOT NULLFiling year of the datashare xml
employee_KEYint (4)NOT NULLPrimary key of the employee associated with this row's datashare xml.
datashare_xmlnvarchar (-1)Cached datashare xml that will be exported for import by other applications.
render_datesmalldatetime (4)NOT NULLDate the datashare data was rendered.
Primary key
NameColumnsDescription
PK_Employee_W2_Rendered_Datashareemployee_w2_rendered_datashare_KEY
Unique constraints
NameColumnsDescription
UK_Employee_W2_Rendered_Datashare$form_year$employee_KEYform_year, employee_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_W2_Rendered_Datashare__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)

Schema diagram