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. |
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. |