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
NameTypeConstraintsDescription
employee_KEYint (4)NOT NULLThe primary key.
include_employeebit (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_numbernvarchar (22)Social security number override. Null indicates not overridden.
last_namenvarchar (60)Last name override. Null indicates not overridden.
first_namenvarchar (60)First name override. Null indicates not overridden.
middle_namenvarchar (60)Middle name override. Null indicates not overridden.
suffixnvarchar (10)Suffix override. Null indicates not overridden.
address_1nvarchar (80)Address line 1 override. Null indicates not overridden.
address_2nvarchar (80)Address line 2 override. Null indicates not overridden.
citynvarchar (60)City override. Null indicates not overridden.
state_abbreviationnvarchar (4)State abbreviation override. Null indicates not overridden.
postal_codenvarchar (100)Postal code override. Null indicates not overridden.
all_12_months__form_1095_coverage_code_KEYtinyint (1)The override coverage code selected for all 12 months.
month_1__form_1095_coverage_code_KEYtinyint (1)The override coverage code selected for month 1.
month_2__form_1095_coverage_code_KEYtinyint (1)The override coverage code selected for month 2.
month_3__form_1095_coverage_code_KEYtinyint (1)The override coverage code selected for month 3.
month_4__form_1095_coverage_code_KEYtinyint (1)The override coverage code selected for month 4.
month_5__form_1095_coverage_code_KEYtinyint (1)The override coverage code selected for month 5.
month_6__form_1095_coverage_code_KEYtinyint (1)The override coverage code selected for month 6.
month_7__form_1095_coverage_code_KEYtinyint (1)The override coverage code selected for month 7.
month_8__form_1095_coverage_code_KEYtinyint (1)The override coverage code selected for month 8.
month_9__form_1095_coverage_code_KEYtinyint (1)The override coverage code selected for month 9.
month_10__form_1095_coverage_code_KEYtinyint (1)The override coverage code selected for month 10.
month_11__form_1095_coverage_code_KEYtinyint (1)The override coverage code selected for month 11.
month_12__form_1095_coverage_code_KEYtinyint (1)The override coverage code selected for month 12.
all_12_months__employee_premium_sharedecimal (9, 2)The override employee premium share for all 12 months.
month_1__employee_premium_sharedecimal (9, 2)The override employee premium share for month 1.
month_2__employee_premium_sharedecimal (9, 2)The override employee premium share for month 2.
month_3__employee_premium_sharedecimal (9, 2)The override employee premium share for month 3.
month_4__employee_premium_sharedecimal (9, 2)The override employee premium share for month 4.
month_5__employee_premium_sharedecimal (9, 2)The override employee premium share for month 5.
month_6__employee_premium_sharedecimal (9, 2)The override employee premium share for month 6.
month_7__employee_premium_sharedecimal (9, 2)The override employee premium share for month 7.
month_8__employee_premium_sharedecimal (9, 2)The override employee premium share for month 8.
month_9__employee_premium_sharedecimal (9, 2)The override employee premium share for month 9.
month_10__employee_premium_sharedecimal (9, 2)The override employee premium share for month 10.
month_11__employee_premium_sharedecimal (9, 2)The override employee premium share for month 11.
month_12__employee_premium_sharedecimal (9, 2)The override employee premium share for month 12.
all_12_months__form_1095_safe_harbor_code_KEYtinyint (1)The override safe harbor code selected for all 12 months.
month_1__form_1095_safe_harbor_code_KEYtinyint (1)The override safe harbor code for month 1.
month_2__form_1095_safe_harbor_code_KEYtinyint (1)The override safe harbor code for month 2.
month_3__form_1095_safe_harbor_code_KEYtinyint (1)The override safe harbor code for month 3.
month_4__form_1095_safe_harbor_code_KEYtinyint (1)The override safe harbor code for month 4.
month_5__form_1095_safe_harbor_code_KEYtinyint (1)The override safe harbor code for month 5.
month_6__form_1095_safe_harbor_code_KEYtinyint (1)The override safe harbor code for month 6.
month_7__form_1095_safe_harbor_code_KEYtinyint (1)The override safe harbor code for month 7.
month_8__form_1095_safe_harbor_code_KEYtinyint (1)The override safe harbor code for month 8.
month_9__form_1095_safe_harbor_code_KEYtinyint (1)The override safe harbor code for month 9.
month_10__form_1095_safe_harbor_code_KEYtinyint (1)The override safe harbor code for month 10.
month_11__form_1095_safe_harbor_code_KEYtinyint (1)The override safe harbor code for month 11.
month_12__form_1095_safe_harbor_code_KEYtinyint (1)The override safe harbor code for month 12.
form_1095_corrected_type_KEYtinyint (1)NOT NULLThe form 1095 corrected type key.
all_12_months__form_1095_zip_codenvarchar (20)The override of the zip code for all 12 months. A null means not overridden.
month_1__form_1095_zip_codenvarchar (20)The override of the zip code for month 1. A null means not overridden.
month_2__form_1095_zip_codenvarchar (20)The override of the zip code for month 2. A null means not overridden.
month_3__form_1095_zip_codenvarchar (20)The override of the zip code for month 3. A null means not overridden.
month_4__form_1095_zip_codenvarchar (20)The override of the zip code for month 4. A null means not overridden.
month_5__form_1095_zip_codenvarchar (20)The override of the zip code for month 5. A null means not overridden.
month_6__form_1095_zip_codenvarchar (20)The override of the zip code for month 6. A null means not overridden.
month_7__form_1095_zip_codenvarchar (20)The override of the zip code for month 7. A null means not overridden.
month_8__form_1095_zip_codenvarchar (20)The override of the zip code for month 8. A null means not overridden.
month_9__form_1095_zip_codenvarchar (20)The override of the zip code for month 9. A null means not overridden.
month_10__form_1095_zip_codenvarchar (20)The override of the zip code for month 10. A null means not overridden.
month_11__form_1095_zip_codenvarchar (20)The override of the zip code for month 11. A null means not overridden.
month_12__form_1095_zip_codenvarchar (20)The override of the zip code for month 12. A null means not overridden.
Primary key
NameColumnsDescription
PK_Employee_1095_Override$employee_KEY$form_1095_corrected_type_KEYemployee_KEY, form_1095_corrected_type_KEY
Unique constraints
NameColumnsDescription
UK_Employee_1095_Override$employee_KEY$form_1095_corrected_type_KEYemployee_KEY, form_1095_corrected_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_1095_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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_Override__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)
FK_Employee_1095_Override__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Employee_1095_Override__Form_1095_Corrected_Type__form_1095_corrected_type_KEYform_1095_corrected_type_KEYForm_1095_Corrected_Type (form_1095_corrected_type_KEY)

Schema diagram