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
Name | Type | Constraints | Description
employee_1095_KEY | int (4) | NOT NULL | The primary key.
employee_KEY | int (4) | NOT NULL | The employee key.
form_year | int (4) | NOT NULL | The year this data is associated with.
all_12_months__form_1095_coverage_code_KEY | tinyint (1) |  | The coverage code selected for all 12 months.
month_1__form_1095_coverage_code_KEY | tinyint (1) |  | The coverage code selected for month 1.
month_2__form_1095_coverage_code_KEY | tinyint (1) |  | The coverage code selected for month 2.
month_3__form_1095_coverage_code_KEY | tinyint (1) |  | The coverage code selected for month 3.
month_4__form_1095_coverage_code_KEY | tinyint (1) |  | The coverage code selected for month 4.
month_5__form_1095_coverage_code_KEY | tinyint (1) |  | The coverage code selected for month 5.
month_6__form_1095_coverage_code_KEY | tinyint (1) |  | The coverage code selected for month 6.
month_7__form_1095_coverage_code_KEY | tinyint (1) |  | The coverage code selected for month 7.
month_8__form_1095_coverage_code_KEY | tinyint (1) |  | The coverage code selected for month 8.
month_9__form_1095_coverage_code_KEY | tinyint (1) |  | The coverage code selected for month 9.
month_10__form_1095_coverage_code_KEY | tinyint (1) |  | The coverage code selected for month 10.
month_11__form_1095_coverage_code_KEY | tinyint (1) |  | The coverage code selected for month 11.
month_12__form_1095_coverage_code_KEY | tinyint (1) |  | The coverage code selected for month 12.
all_12_months__employee_premium_share | decimal (9, 2) |  | The employee premium share for all 12 months.
month_1__employee_premium_share | decimal (9, 2) |  | The employee premium share for month 1.
month_2__employee_premium_share | decimal (9, 2) |  | The employee premium share for month 2.
month_3__employee_premium_share | decimal (9, 2) |  | The employee premium share for month 3.
month_4__employee_premium_share | decimal (9, 2) |  | The employee premium share for month 4.
month_5__employee_premium_share | decimal (9, 2) |  | The employee premium share for month 5.
month_6__employee_premium_share | decimal (9, 2) |  | The employee premium share for month 6.
month_7__employee_premium_share | decimal (9, 2) |  | The employee premium share for month 7.
month_8__employee_premium_share | decimal (9, 2) |  | The employee premium share for month 8.
month_9__employee_premium_share | decimal (9, 2) |  | The employee premium share for month 9.
month_10__employee_premium_share | decimal (9, 2) |  | The employee premium share for month 10.
month_11__employee_premium_share | decimal (9, 2) |  | The employee premium share for month 11.
month_12__employee_premium_share | decimal (9, 2) |  | The employee premium share for month 12.
all_12_months__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The safe harbor code selected for all 12 months.
month_1__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The safe harbor code for month 1.
month_2__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The safe harbor code for month 2.
month_3__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The safe harbor code for month 3.
month_4__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The safe harbor code for month 4.
month_5__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The safe harbor code for month 5.
month_6__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The safe harbor code for month 6.
month_7__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The safe harbor code for month 7.
month_8__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The safe harbor code for month 8.
month_9__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The safe harbor code for month 9.
month_10__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The safe harbor code for month 10.
month_11__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The safe harbor code for month 11.
month_12__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The safe harbor code for month 12.
corrected_record_id | int (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_code | nvarchar (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_code | nvarchar (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_code | nvarchar (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_code | nvarchar (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_code | nvarchar (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_code | nvarchar (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_code | nvarchar (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_code | nvarchar (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_code | nvarchar (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_code | nvarchar (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_code | nvarchar (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_code | nvarchar (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_code | nvarchar (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
Name | Columns | Description
PK_Employee_1095 | employee_1095_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_1095$employee_KEY$form_year | employee_KEY, form_year |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_1095__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Employee_1095__Form_1095_Coverage_Code__all_12_months__form_1095_coverage_code_KEY | all_12_months__form_1095_coverage_code_KEY | Form_1095_Coverage_Code (form_1095_coverage_code_KEY) |
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_1__form_1095_coverage_code_KEY | month_1__form_1095_coverage_code_KEY | Form_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_KEY | month_2__form_1095_coverage_code_KEY | Form_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_KEY | month_3__form_1095_coverage_code_KEY | Form_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_KEY | month_4__form_1095_coverage_code_KEY | Form_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_KEY | month_5__form_1095_coverage_code_KEY | Form_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_KEY | month_6__form_1095_coverage_code_KEY | Form_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_KEY | month_7__form_1095_coverage_code_KEY | Form_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_KEY | month_8__form_1095_coverage_code_KEY | Form_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_KEY | month_9__form_1095_coverage_code_KEY | Form_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_KEY | month_10__form_1095_coverage_code_KEY | Form_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_KEY | month_11__form_1095_coverage_code_KEY | Form_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_KEY | month_12__form_1095_coverage_code_KEY | Form_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_KEY | all_12_months__form_1095_safe_harbor_code_KEY | Form_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_KEY | month_1__form_1095_safe_harbor_code_KEY | Form_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_KEY | month_2__form_1095_safe_harbor_code_KEY | Form_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_KEY | month_3__form_1095_safe_harbor_code_KEY | Form_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_KEY | month_4__form_1095_safe_harbor_code_KEY | Form_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_KEY | month_5__form_1095_safe_harbor_code_KEY | Form_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_KEY | month_6__form_1095_safe_harbor_code_KEY | Form_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_KEY | month_7__form_1095_safe_harbor_code_KEY | Form_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_KEY | month_8__form_1095_safe_harbor_code_KEY | Form_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_KEY | month_9__form_1095_safe_harbor_code_KEY | Form_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_KEY | month_10__form_1095_safe_harbor_code_KEY | Form_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_KEY | month_11__form_1095_safe_harbor_code_KEY | Form_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_KEY | month_12__form_1095_safe_harbor_code_KEY | Form_1095_Safe_Harbor_Code (form_1095_safe_harbor_code_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Employee_1095_Covered_Individual__Employee__employee_1095_KEY | employee_1095_KEY | Employee_1095_Covered_Individual |