Table: dbo.Employee_1095_Override
This table stores the overrides for employee 1095 information. The schema for this table must be kept synchronized with Employee_1095 for year/month specific fields. A null in one of these year/month specific fields means thatit is not overridden.
Columns
Name | Type | Constraints | Description
employee_KEY | int (4) | NOT NULL | The primary key.
include_employee | bit (1) |  | Override of the automatic 1095-C print selection. true means a 1095-C will be always be output. false means a 1095-C will never be output. null means a 1095-C will be output if there is Employee_1095 or Employee_1095_Override data to trigger it.
social_security_number | nvarchar (22) |  | Social security number override. Null indicates not overridden.
last_name | nvarchar (60) |  | Last name override. Null indicates not overridden.
first_name | nvarchar (60) |  | First name override. Null indicates not overridden.
middle_name | nvarchar (60) |  | Middle name override. Null indicates not overridden.
suffix | nvarchar (10) |  | Suffix override. Null indicates not overridden.
address_1 | nvarchar (80) |  | Address line 1 override. Null indicates not overridden.
address_2 | nvarchar (80) |  | Address line 2 override. Null indicates not overridden.
city | nvarchar (60) |  | City override. Null indicates not overridden.
state_abbreviation | nvarchar (4) |  | State abbreviation override. Null indicates not overridden.
postal_code | nvarchar (100) |  | Postal code override. Null indicates not overridden.
all_12_months__form_1095_coverage_code_KEY | tinyint (1) |  | The override coverage code selected for all 12 months.
month_1__form_1095_coverage_code_KEY | tinyint (1) |  | The override coverage code selected for month 1.
month_2__form_1095_coverage_code_KEY | tinyint (1) |  | The override coverage code selected for month 2.
month_3__form_1095_coverage_code_KEY | tinyint (1) |  | The override coverage code selected for month 3.
month_4__form_1095_coverage_code_KEY | tinyint (1) |  | The override coverage code selected for month 4.
month_5__form_1095_coverage_code_KEY | tinyint (1) |  | The override coverage code selected for month 5.
month_6__form_1095_coverage_code_KEY | tinyint (1) |  | The override coverage code selected for month 6.
month_7__form_1095_coverage_code_KEY | tinyint (1) |  | The override coverage code selected for month 7.
month_8__form_1095_coverage_code_KEY | tinyint (1) |  | The override coverage code selected for month 8.
month_9__form_1095_coverage_code_KEY | tinyint (1) |  | The override coverage code selected for month 9.
month_10__form_1095_coverage_code_KEY | tinyint (1) |  | The override coverage code selected for month 10.
month_11__form_1095_coverage_code_KEY | tinyint (1) |  | The override coverage code selected for month 11.
month_12__form_1095_coverage_code_KEY | tinyint (1) |  | The override coverage code selected for month 12.
all_12_months__employee_premium_share | decimal (9, 2) |  | The override employee premium share for all 12 months.
month_1__employee_premium_share | decimal (9, 2) |  | The override employee premium share for month 1.
month_2__employee_premium_share | decimal (9, 2) |  | The override employee premium share for month 2.
month_3__employee_premium_share | decimal (9, 2) |  | The override employee premium share for month 3.
month_4__employee_premium_share | decimal (9, 2) |  | The override employee premium share for month 4.
month_5__employee_premium_share | decimal (9, 2) |  | The override employee premium share for month 5.
month_6__employee_premium_share | decimal (9, 2) |  | The override employee premium share for month 6.
month_7__employee_premium_share | decimal (9, 2) |  | The override employee premium share for month 7.
month_8__employee_premium_share | decimal (9, 2) |  | The override employee premium share for month 8.
month_9__employee_premium_share | decimal (9, 2) |  | The override employee premium share for month 9.
month_10__employee_premium_share | decimal (9, 2) |  | The override employee premium share for month 10.
month_11__employee_premium_share | decimal (9, 2) |  | The override employee premium share for month 11.
month_12__employee_premium_share | decimal (9, 2) |  | The override employee premium share for month 12.
all_12_months__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The override safe harbor code selected for all 12 months.
month_1__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The override safe harbor code for month 1.
month_2__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The override safe harbor code for month 2.
month_3__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The override safe harbor code for month 3.
month_4__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The override safe harbor code for month 4.
month_5__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The override safe harbor code for month 5.
month_6__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The override safe harbor code for month 6.
month_7__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The override safe harbor code for month 7.
month_8__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The override safe harbor code for month 8.
month_9__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The override safe harbor code for month 9.
month_10__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The override safe harbor code for month 10.
month_11__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The override safe harbor code for month 11.
month_12__form_1095_safe_harbor_code_KEY | tinyint (1) |  | The override safe harbor code for month 12.
form_1095_corrected_type_KEY | tinyint (1) | NOT NULL | The form 1095 corrected type key.
all_12_months__form_1095_zip_code | nvarchar (20) |  | The override of the zip code for all 12 months. A null means not overridden.
month_1__form_1095_zip_code | nvarchar (20) |  | The override of the zip code for month 1. A null means not overridden.
month_2__form_1095_zip_code | nvarchar (20) |  | The override of the zip code for month 2. A null means not overridden.
month_3__form_1095_zip_code | nvarchar (20) |  | The override of the zip code for month 3. A null means not overridden.
month_4__form_1095_zip_code | nvarchar (20) |  | The override of the zip code for month 4. A null means not overridden.
month_5__form_1095_zip_code | nvarchar (20) |  | The override of the zip code for month 5. A null means not overridden.
month_6__form_1095_zip_code | nvarchar (20) |  | The override of the zip code for month 6. A null means not overridden.
month_7__form_1095_zip_code | nvarchar (20) |  | The override of the zip code for month 7. A null means not overridden.
month_8__form_1095_zip_code | nvarchar (20) |  | The override of the zip code for month 8. A null means not overridden.
month_9__form_1095_zip_code | nvarchar (20) |  | The override of the zip code for month 9. A null means not overridden.
month_10__form_1095_zip_code | nvarchar (20) |  | The override of the zip code for month 10. A null means not overridden.
month_11__form_1095_zip_code | nvarchar (20) |  | The override of the zip code for month 11. A null means not overridden.
month_12__form_1095_zip_code | nvarchar (20) |  | The override of the zip code for month 12. A null means not overridden.

Primary key
Name | Columns | Description
PK_Employee_1095_Override$employee_KEY$form_1095_corrected_type_KEY | employee_KEY, form_1095_corrected_type_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_1095_Override$employee_KEY$form_1095_corrected_type_KEY | employee_KEY, form_1095_corrected_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_1095_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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) |
FK_Employee_1095_Override__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Employee_1095_Override__Form_1095_Corrected_Type__form_1095_corrected_type_KEY | form_1095_corrected_type_KEY | Form_1095_Corrected_Type (form_1095_corrected_type_KEY) |