Table: dbo.Client_1095
This table stores the client 1095 information.
Columns
Name | Type | Constraints | Description
client_1095_KEY | int (4) | NOT NULL | The primary key.
client_KEY | int (4) | NOT NULL | The client key.
form_year | int (4) | NOT NULL | The year this data is associated with.
all_12_months_minimum_essential_coverage | bit (1) | NOT NULL | The minimum essential coverage flag for all 12 months.
month_1_minimum_essential_coverage | bit (1) | NOT NULL | The minimum essential coverage flag for month 1.
month_2_minimum_essential_coverage | bit (1) | NOT NULL | The minimum essential coverage flag for month 2.
month_3_minimum_essential_coverage | bit (1) | NOT NULL | The minimum essential coverage flag for month 3.
month_4_minimum_essential_coverage | bit (1) | NOT NULL | The minimum essential coverage flag for month 4.
month_5_minimum_essential_coverage | bit (1) | NOT NULL | The minimum essential coverage flag for month 5.
month_6_minimum_essential_coverage | bit (1) | NOT NULL | The minimum essential coverage flag for month 6.
month_7_minimum_essential_coverage | bit (1) | NOT NULL | The minimum essential coverage flag for month 7.
month_8_minimum_essential_coverage | bit (1) | NOT NULL | The minimum essential coverage flag for month 8.
month_9_minimum_essential_coverage | bit (1) | NOT NULL | The minimum essential coverage flag for month 9.
month_10_minimum_essential_coverage | bit (1) | NOT NULL | The minimum essential coverage flag for month 10.
month_11_minimum_essential_coverage | bit (1) | NOT NULL | The minimum essential coverage flag for month 11.
month_12_minimum_essential_coverage | bit (1) | NOT NULL | The minimum essential coverage flag for month 12.
month_1_full_time_employee_count_override | int (4) |  | The full time employee count override for month 1. Null indicates not overridden.
month_2_full_time_employee_count_override | int (4) |  | The full time employee count override for month 2. Null indicates not overridden.
month_3_full_time_employee_count_override | int (4) |  | The full time employee count override for month 3. Null indicates not overridden.
month_4_full_time_employee_count_override | int (4) |  | The full time employee count override for month 4. Null indicates not overridden.
month_5_full_time_employee_count_override | int (4) |  | The full time employee count override for month 5. Null indicates not overridden.
month_6_full_time_employee_count_override | int (4) |  | The full time employee count override for month 6. Null indicates not overridden.
month_7_full_time_employee_count_override | int (4) |  | The full time employee count override for month 7. Null indicates not overridden.
month_8_full_time_employee_count_override | int (4) |  | The full time employee count override for month 8. Null indicates not overridden.
month_9_full_time_employee_count_override | int (4) |  | The full time employee count override for month 9. Null indicates not overridden.
month_10_full_time_employee_count_override | int (4) |  | The full time employee count override for month 10. Null indicates not overridden.
month_11_full_time_employee_count_override | int (4) |  | The full time employee count override for month 11. Null indicates not overridden.
month_12_full_time_employee_count_override | int (4) |  | The full time employee count override for month 12. Null indicates not overridden.
all_12_months_total_employee_count_override | int (4) |  | The total employee count override for all months. Null indicates not overridden.
month_1_total_employee_count_override | int (4) |  | The total employee count override for month 1. Null indicates not overridden.
month_2_total_employee_count_override | int (4) |  | The total employee count override for month 2. Null indicates not overridden.
month_3_total_employee_count_override | int (4) |  | The total employee count override for month 3. Null indicates not overridden.
month_4_total_employee_count_override | int (4) |  | The total employee count override for month 4. Null indicates not overridden.
month_5_total_employee_count_override | int (4) |  | The total employee count override for month 5. Null indicates not overridden.
month_6_total_employee_count_override | int (4) |  | The total employee count override for month 6. Null indicates not overridden.
month_7_total_employee_count_override | int (4) |  | The total employee count override for month 7. Null indicates not overridden.
month_8_total_employee_count_override | int (4) |  | The total employee count override for month 8. Null indicates not overridden.
month_9_total_employee_count_override | int (4) |  | The total employee count override for month 9. Null indicates not overridden.
month_10_total_employee_count_override | int (4) |  | The total employee count override for month 10. Null indicates not overridden.
month_11_total_employee_count_override | int (4) |  | The total employee count override for month 11. Null indicates not overridden.
month_12_total_employee_count_override | int (4) |  | The total employee count override for month 12. Null indicates not overridden.
all_12_months__form_1094_section_4980H_code_KEY | tinyint (1) |  | The form 1094 section 4980H code selected for all months.
month_1__form_1094_section_4980H_code_KEY | tinyint (1) |  | The form 1094 section 4980H code selected for month 1.
month_2__form_1094_section_4980H_code_KEY | tinyint (1) |  | The form 1094 section 4980H code selected for month 2.
month_3__form_1094_section_4980H_code_KEY | tinyint (1) |  | The form 1094 section 4980H code selected for month 3.
month_4__form_1094_section_4980H_code_KEY | tinyint (1) |  | The form 1094 section 4980H code selected for month 4.
month_5__form_1094_section_4980H_code_KEY | tinyint (1) |  | The form 1094 section 4980H code selected for month 5.
month_6__form_1094_section_4980H_code_KEY | tinyint (1) |  | The form 1094 section 4980H code selected for month 6.
month_7__form_1094_section_4980H_code_KEY | tinyint (1) |  | The form 1094 section 4980H code selected for month 7.
month_8__form_1094_section_4980H_code_KEY | tinyint (1) |  | The form 1094 section 4980H code selected for month 8.
month_9__form_1094_section_4980H_code_KEY | tinyint (1) |  | The form 1094 section 4980H code selected for month 9.
month_10__form_1094_section_4980H_code_KEY | tinyint (1) |  | The form 1094 section 4980H code selected for month 10.
month_11__form_1094_section_4980H_code_KEY | tinyint (1) |  | The form 1094 section 4980H code selected for month 11.
month_12__form_1094_section_4980H_code_KEY | tinyint (1) |  | The form 1094 section 4980H code selected for month 12.
all_12_months_form_1094_aggregated_group_indicator | bit (1) |  | The client was a member of an aggregate group for all 12 months of the year.
month_1_form_1094_aggregated_group_indicator_override | bit (1) |  | The client was a member of an aggregate group during January.
month_2_form_1094_aggregated_group_indicator_override | bit (1) |  | The client was a member of an aggregate group during February.
month_3_form_1094_aggregated_group_indicator_override | bit (1) |  | The client was a member of an aggregate group during March.
month_4_form_1094_aggregated_group_indicator_override | bit (1) |  | The client was a member of an aggregate group during April.
month_5_form_1094_aggregated_group_indicator_override | bit (1) |  | The client was a member of an aggregate group during May.
month_6_form_1094_aggregated_group_indicator_override | bit (1) |  | The client was a member of an aggregate group during June.
month_7_form_1094_aggregated_group_indicator_override | bit (1) |  | The client was a member of an aggregate group during July.
month_8_form_1094_aggregated_group_indicator_override | bit (1) |  | The client was a member of an aggregate group during August.
month_9_form_1094_aggregated_group_indicator_override | bit (1) |  | The client was a member of an aggregate group during September
month_10_form_1094_aggregated_group_indicator_override | bit (1) |  | The client was a member of an aggregate group during october
month_11_form_1094_aggregated_group_indicator_override | bit (1) |  | The client was a member of an aggregate group during November
month_12_form_1094_aggregated_group_indicator_override | bit (1) |  | The client was a member of an aggregate group during December
all_12_months_full_time_employee_count_override | int (4) |  | The full time employee count override for all 12 months. Null indicates not overriden.
form_1095_corrected_type_KEY | tinyint (1) | NOT NULL | The form 1095 corrected type key.
corrected_receipt_id | nvarchar (50) |  | The receipt id of the original submission being corrected. Nulls are allowed to indicate a corrected form was never filed for this client for this year.
corrected_submission_id | int (4) |  | The submission ID of the original submission being corrected. Nulls are allowed to indicate a corrected form was never filed for this client for this year.

Primary key
Name | Columns | Description
PK_Client_1095 | client_1095_KEY |
Unique constraints
Name | Columns | Description
UK_Client_1095$client_KEY$form_year$form_1095_corrected_type_KEY | client_KEY, form_year, form_1095_corrected_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_1095__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_1095__Form_1094_Section_4980H_Code__all_12_months__form_1095_coverage_code_KEY | all_12_months__form_1094_section_4980H_code_KEY | Form_1094_Section_4980H_Code (form_1094_section_4980H_code_KEY) |
FK_Client_1095__Form_1094_Section_4980H_Code__month_1__form_1094_section_4980H_code_KEY | month_1__form_1094_section_4980H_code_KEY | Form_1094_Section_4980H_Code (form_1094_section_4980H_code_KEY) |
FK_Client_1095__Form_1094_Section_4980H_Code__month_2__form_1094_section_4980H_code_KEY | month_2__form_1094_section_4980H_code_KEY | Form_1094_Section_4980H_Code (form_1094_section_4980H_code_KEY) |
FK_Client_1095__Form_1094_Section_4980H_Code__month_3__form_1094_section_4980H_code_KEY | month_3__form_1094_section_4980H_code_KEY | Form_1094_Section_4980H_Code (form_1094_section_4980H_code_KEY) |
FK_Client_1095__Form_1094_Section_4980H_Code__month_4__form_1094_section_4980H_code_KEY | month_4__form_1094_section_4980H_code_KEY | Form_1094_Section_4980H_Code (form_1094_section_4980H_code_KEY) |
FK_Client_1095__Form_1094_Section_4980H_Code__month_5__form_1094_section_4980H_code_KEY | month_5__form_1094_section_4980H_code_KEY | Form_1094_Section_4980H_Code (form_1094_section_4980H_code_KEY) |
FK_Client_1095__Form_1094_Section_4980H_Code__month_6__form_1094_section_4980H_code_KEY | month_6__form_1094_section_4980H_code_KEY | Form_1094_Section_4980H_Code (form_1094_section_4980H_code_KEY) |
FK_Client_1095__Form_1094_Section_4980H_Code__month_7__form_1094_section_4980H_code_KEY | month_7__form_1094_section_4980H_code_KEY | Form_1094_Section_4980H_Code (form_1094_section_4980H_code_KEY) |
FK_Client_1095__Form_1094_Section_4980H_Code__month_8__form_1094_section_4980H_code_KEY | month_8__form_1094_section_4980H_code_KEY | Form_1094_Section_4980H_Code (form_1094_section_4980H_code_KEY) |
FK_Client_1095__Form_1094_Section_4980H_Code__month_9__form_1094_section_4980H_code_KEY | month_9__form_1094_section_4980H_code_KEY | Form_1094_Section_4980H_Code (form_1094_section_4980H_code_KEY) |
FK_Client_1095__Form_1094_Section_4980H_Code__month_10__form_1094_section_4980H_code_KEY | month_10__form_1094_section_4980H_code_KEY | Form_1094_Section_4980H_Code (form_1094_section_4980H_code_KEY) |
FK_Client_1095__Form_1094_Section_4980H_Code__month_11__form_1094_section_4980H_code_KEY | month_11__form_1094_section_4980H_code_KEY | Form_1094_Section_4980H_Code (form_1094_section_4980H_code_KEY) |
FK_Client_1095__Form_1094_Section_4980H_Code__month_12__form_1094_section_4980H_code_KEY | month_12__form_1094_section_4980H_code_KEY | Form_1094_Section_4980H_Code (form_1094_section_4980H_code_KEY) |
FK_Client_1095__Form_1095_Corrected_Type__form_1095_corrected_type_KEY | form_1095_corrected_type_KEY | Form_1095_Corrected_Type (form_1095_corrected_type_KEY) |