Table: dbo.Print_1095
This table holds information for a form 1095 print run.
Columns
NameTypeConstraintsDescription
print_1095_KEYint (4)NOT NULLThe primary key.
user_session_guiduniqueidentifier (16)NOT NULLThe user session GUID.
form_yearint (4)NOT NULLThe year that this data is associated with.
client_KEYint (4)NOT NULLThe client that this data is associated with.
month_1_full_time_employee_countint (4)Full time employee count for month 1.
month_2_full_time_employee_countint (4)Full time employee count for month 2.
month_3_full_time_employee_countint (4)Full time employee count for month 3.
month_4_full_time_employee_countint (4)Full time employee count for month 4.
month_5_full_time_employee_countint (4)Full time employee count for month 5.
month_6_full_time_employee_countint (4)Full time employee count for month 6.
month_7_full_time_employee_countint (4)Full time employee count for month 7.
month_8_full_time_employee_countint (4)Full time employee count for month 8.
month_9_full_time_employee_countint (4)Full time employee count for month 9.
month_10_full_time_employee_countint (4)Full time employee count for month 10.
month_11_full_time_employee_countint (4)Full time employee count for month 11.
month_12_full_time_employee_countint (4)Full time employee count for month 12.
all_12_months_total_employee_countint (4)Total employee count for all months.
month_1_total_employee_countint (4)Total employee count for month 1.
month_2_total_employee_countint (4)Total employee count for month 2.
month_3_total_employee_countint (4)Total employee count for month 3.
month_4_total_employee_countint (4)Total employee count for month 4.
month_5_total_employee_countint (4)Total employee count for month 5.
month_6_total_employee_countint (4)Total employee count for month 6.
month_7_total_employee_countint (4)Total employee count for month 7.
month_8_total_employee_countint (4)Total employee count for month 8.
month_9_total_employee_countint (4)Total employee count for month 9.
month_10_total_employee_countint (4)Total employee count for month 10.
month_11_total_employee_countint (4)Total employee count for month 11.
month_12_total_employee_countint (4)Total employee count for month 12.
all_12_months_full_time_employee_countint (4)The full time employee count for all 12 months. Null indicates not specified
form_1095_corrected_type_KEYtinyint (1)NOT NULLThe form 1095 corrected type key.
Primary key
NameColumnsDescription
PK_Print_1095print_1095_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_1095__Client__client_KEYclient_KEYClient (client_KEY)
FK_Print_1095__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)
FK_Print_1095__Form_1095_Corrected_Type__form_1095_corrected_type_KEYform_1095_corrected_type_KEYForm_1095_Corrected_Type (form_1095_corrected_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Print_1095_Selection__Print_1095__print_1095_KEYprint_1095_KEYPrint_1095_Selection

Schema diagram