Table: dbo.Employee_1095
This table stores the employee 1095 information.. The schema for this table must be kept synchronized with Employee_1095_Override for year/month specific fields. A null in one of these year/month specific fields in this table means that it is not set for the employee. A particular year/month group can be all null if is does not apply. Alternatively, the year field can be null with at least some of the months filled in. Lastly, the year field can be non-null and the corresponding month fields are null.
Columns
NameTypeConstraintsDescription
employee_1095_KEYint (4)NOT NULLThe primary key.
employee_KEYint (4)NOT NULLThe employee key.
form_yearint (4)NOT NULLThe year this data is associated with.
all_12_months__form_1095_coverage_code_KEYtinyint (1)The coverage code selected for all 12 months.
month_1__form_1095_coverage_code_KEYtinyint (1)The coverage code selected for month 1.
month_2__form_1095_coverage_code_KEYtinyint (1)The coverage code selected for month 2.
month_3__form_1095_coverage_code_KEYtinyint (1)The coverage code selected for month 3.
month_4__form_1095_coverage_code_KEYtinyint (1)The coverage code selected for month 4.
month_5__form_1095_coverage_code_KEYtinyint (1)The coverage code selected for month 5.
month_6__form_1095_coverage_code_KEYtinyint (1)The coverage code selected for month 6.
month_7__form_1095_coverage_code_KEYtinyint (1)The coverage code selected for month 7.
month_8__form_1095_coverage_code_KEYtinyint (1)The coverage code selected for month 8.
month_9__form_1095_coverage_code_KEYtinyint (1)The coverage code selected for month 9.
month_10__form_1095_coverage_code_KEYtinyint (1)The coverage code selected for month 10.
month_11__form_1095_coverage_code_KEYtinyint (1)The coverage code selected for month 11.
month_12__form_1095_coverage_code_KEYtinyint (1)The coverage code selected for month 12.
all_12_months__employee_premium_sharedecimal (9, 2)The employee premium share for all 12 months.
month_1__employee_premium_sharedecimal (9, 2)The employee premium share for month 1.
month_2__employee_premium_sharedecimal (9, 2)The employee premium share for month 2.
month_3__employee_premium_sharedecimal (9, 2)The employee premium share for month 3.
month_4__employee_premium_sharedecimal (9, 2)The employee premium share for month 4.
month_5__employee_premium_sharedecimal (9, 2)The employee premium share for month 5.
month_6__employee_premium_sharedecimal (9, 2)The employee premium share for month 6.
month_7__employee_premium_sharedecimal (9, 2)The employee premium share for month 7.
month_8__employee_premium_sharedecimal (9, 2)The employee premium share for month 8.
month_9__employee_premium_sharedecimal (9, 2)The employee premium share for month 9.
month_10__employee_premium_sharedecimal (9, 2)The employee premium share for month 10.
month_11__employee_premium_sharedecimal (9, 2)The employee premium share for month 11.
month_12__employee_premium_sharedecimal (9, 2)The employee premium share for month 12.
all_12_months__form_1095_safe_harbor_code_KEYtinyint (1)The safe harbor code selected for all 12 months.
month_1__form_1095_safe_harbor_code_KEYtinyint (1)The safe harbor code for month 1.
month_2__form_1095_safe_harbor_code_KEYtinyint (1)The safe harbor code for month 2.
month_3__form_1095_safe_harbor_code_KEYtinyint (1)The safe harbor code for month 3.
month_4__form_1095_safe_harbor_code_KEYtinyint (1)The safe harbor code for month 4.
month_5__form_1095_safe_harbor_code_KEYtinyint (1)The safe harbor code for month 5.
month_6__form_1095_safe_harbor_code_KEYtinyint (1)The safe harbor code for month 6.
month_7__form_1095_safe_harbor_code_KEYtinyint (1)The safe harbor code for month 7.
month_8__form_1095_safe_harbor_code_KEYtinyint (1)The safe harbor code for month 8.
month_9__form_1095_safe_harbor_code_KEYtinyint (1)The safe harbor code for month 9.
month_10__form_1095_safe_harbor_code_KEYtinyint (1)The safe harbor code for month 10.
month_11__form_1095_safe_harbor_code_KEYtinyint (1)The safe harbor code for month 11.
month_12__form_1095_safe_harbor_code_KEYtinyint (1)The safe harbor code for month 12.
corrected_record_idint (4)The record id of the original 1095-C being corrected. Nulls are allowed to indicate a corrected form was never filed for this employee for this year.
all_12_months__form_1095_zip_codenvarchar (20)The zip code for all 12 months. A null means it does not apply to the employee (see table description for more information).
month_1__form_1095_zip_codenvarchar (20)The zip code for month 1. A null means it does not apply to the employee (see table description for more information).
month_2__form_1095_zip_codenvarchar (20)The zip code for month 2. A null means it does not apply to the employee (see table description for more information).
month_3__form_1095_zip_codenvarchar (20)The zip code for month 3. A null means it does not apply to the employee (see table description for more information).
month_4__form_1095_zip_codenvarchar (20)The zip code for month 4. A null means it does not apply to the employee (see table description for more information).
month_5__form_1095_zip_codenvarchar (20)The zip code for month 5. A null means it does not apply to the employee (see table description for more information).
month_6__form_1095_zip_codenvarchar (20)The zip code for month 6. A null means it does not apply to the employee (see table description for more information).
month_7__form_1095_zip_codenvarchar (20)The zip code for month 7. A null means it does not apply to the employee (see table description for more information).
month_8__form_1095_zip_codenvarchar (20)The zip code for month 8. A null means it does not apply to the employee (see table description for more information).
month_9__form_1095_zip_codenvarchar (20)The zip code for month 9. A null means it does not apply to the employee (see table description for more information).
month_10__form_1095_zip_codenvarchar (20)The zip code for month 10. A null means it does not apply to the employee (see table description for more information).
month_11__form_1095_zip_codenvarchar (20)The zip code for month 11. A null means it does not apply to the employee (see table description for more information).
month_12__form_1095_zip_codenvarchar (20)The zip code for month 12. A null means it does not apply to the employee (see table description for more information).
Primary key
NameColumnsDescription
PK_Employee_1095employee_1095_KEY
Unique constraints
NameColumnsDescription
UK_Employee_1095$employee_KEY$form_yearemployee_KEY, form_year
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_1095__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Employee_1095__Form_1095_Coverage_Code__all_12_months__form_1095_coverage_code_KEYall_12_months__form_1095_coverage_code_KEYForm_1095_Coverage_Code (form_1095_coverage_code_KEY)
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_1__form_1095_coverage_code_KEYmonth_1__form_1095_coverage_code_KEYForm_1095_Coverage_Code__Individual_Months (form_1095_coverage_code_KEY)
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_2__form_1095_coverage_code_KEYmonth_2__form_1095_coverage_code_KEYForm_1095_Coverage_Code__Individual_Months (form_1095_coverage_code_KEY)
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_3__form_1095_coverage_code_KEYmonth_3__form_1095_coverage_code_KEYForm_1095_Coverage_Code__Individual_Months (form_1095_coverage_code_KEY)
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_4__form_1095_coverage_code_KEYmonth_4__form_1095_coverage_code_KEYForm_1095_Coverage_Code__Individual_Months (form_1095_coverage_code_KEY)
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_5__form_1095_coverage_code_KEYmonth_5__form_1095_coverage_code_KEYForm_1095_Coverage_Code__Individual_Months (form_1095_coverage_code_KEY)
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_6__form_1095_coverage_code_KEYmonth_6__form_1095_coverage_code_KEYForm_1095_Coverage_Code__Individual_Months (form_1095_coverage_code_KEY)
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_7__form_1095_coverage_code_KEYmonth_7__form_1095_coverage_code_KEYForm_1095_Coverage_Code__Individual_Months (form_1095_coverage_code_KEY)
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_8__form_1095_coverage_code_KEYmonth_8__form_1095_coverage_code_KEYForm_1095_Coverage_Code__Individual_Months (form_1095_coverage_code_KEY)
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_9__form_1095_coverage_code_KEYmonth_9__form_1095_coverage_code_KEYForm_1095_Coverage_Code__Individual_Months (form_1095_coverage_code_KEY)
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_10__form_1095_coverage_code_KEYmonth_10__form_1095_coverage_code_KEYForm_1095_Coverage_Code__Individual_Months (form_1095_coverage_code_KEY)
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_11__form_1095_coverage_code_KEYmonth_11__form_1095_coverage_code_KEYForm_1095_Coverage_Code__Individual_Months (form_1095_coverage_code_KEY)
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_12__form_1095_coverage_code_KEYmonth_12__form_1095_coverage_code_KEYForm_1095_Coverage_Code__Individual_Months (form_1095_coverage_code_KEY)
FK_Employee_1095__Form_1095_Safe_Harbor_Code__all_12_months__form_1095_safe_harbor_code_KEYall_12_months__form_1095_safe_harbor_code_KEYForm_1095_Safe_Harbor_Code (form_1095_safe_harbor_code_KEY)
FK_Employee_1095__Form_1095_Safe_Harbor_Code__month_1__form_1095_safe_harbor_code_KEYmonth_1__form_1095_safe_harbor_code_KEYForm_1095_Safe_Harbor_Code (form_1095_safe_harbor_code_KEY)
FK_Employee_1095__Form_1095_Safe_Harbor_Code__month_2__form_1095_safe_harbor_code_KEYmonth_2__form_1095_safe_harbor_code_KEYForm_1095_Safe_Harbor_Code (form_1095_safe_harbor_code_KEY)
FK_Employee_1095__Form_1095_Safe_Harbor_Code__month_3__form_1095_safe_harbor_code_KEYmonth_3__form_1095_safe_harbor_code_KEYForm_1095_Safe_Harbor_Code (form_1095_safe_harbor_code_KEY)
FK_Employee_1095__Form_1095_Safe_Harbor_Code__month_4__form_1095_safe_harbor_code_KEYmonth_4__form_1095_safe_harbor_code_KEYForm_1095_Safe_Harbor_Code (form_1095_safe_harbor_code_KEY)
FK_Employee_1095__Form_1095_Safe_Harbor_Code__month_5__form_1095_safe_harbor_code_KEYmonth_5__form_1095_safe_harbor_code_KEYForm_1095_Safe_Harbor_Code (form_1095_safe_harbor_code_KEY)
FK_Employee_1095__Form_1095_Safe_Harbor_Code__month_6__form_1095_safe_harbor_code_KEYmonth_6__form_1095_safe_harbor_code_KEYForm_1095_Safe_Harbor_Code (form_1095_safe_harbor_code_KEY)
FK_Employee_1095__Form_1095_Safe_Harbor_Code__month_7__form_1095_safe_harbor_code_KEYmonth_7__form_1095_safe_harbor_code_KEYForm_1095_Safe_Harbor_Code (form_1095_safe_harbor_code_KEY)
FK_Employee_1095__Form_1095_Safe_Harbor_Code__month_8__form_1095_safe_harbor_code_KEYmonth_8__form_1095_safe_harbor_code_KEYForm_1095_Safe_Harbor_Code (form_1095_safe_harbor_code_KEY)
FK_Employee_1095__Form_1095_Safe_Harbor_Code__month_9__form_1095_safe_harbor_code_KEYmonth_9__form_1095_safe_harbor_code_KEYForm_1095_Safe_Harbor_Code (form_1095_safe_harbor_code_KEY)
FK_Employee_1095__Form_1095_Safe_Harbor_Code__month_10__form_1095_safe_harbor_code_KEYmonth_10__form_1095_safe_harbor_code_KEYForm_1095_Safe_Harbor_Code (form_1095_safe_harbor_code_KEY)
FK_Employee_1095__Form_1095_Safe_Harbor_Code__month_11__form_1095_safe_harbor_code_KEYmonth_11__form_1095_safe_harbor_code_KEYForm_1095_Safe_Harbor_Code (form_1095_safe_harbor_code_KEY)
FK_Employee_1095__Form_1095_Safe_Harbor_Code__month_12__form_1095_safe_harbor_code_KEYmonth_12__form_1095_safe_harbor_code_KEYForm_1095_Safe_Harbor_Code (form_1095_safe_harbor_code_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee_1095_Covered_Individual__Employee__employee_1095_KEYemployee_1095_KEYEmployee_1095_Covered_Individual

Schema diagram