Table: dbo.Client_1095
This table stores the client 1095 information.
Columns
NameTypeConstraintsDescription
client_1095_KEYint (4)NOT NULLThe primary key.
client_KEYint (4)NOT NULLThe client key.
form_yearint (4)NOT NULLThe year this data is associated with.
all_12_months_minimum_essential_coveragebit (1)NOT NULLThe minimum essential coverage flag for all 12 months.
month_1_minimum_essential_coveragebit (1)NOT NULLThe minimum essential coverage flag for month 1.
month_2_minimum_essential_coveragebit (1)NOT NULLThe minimum essential coverage flag for month 2.
month_3_minimum_essential_coveragebit (1)NOT NULLThe minimum essential coverage flag for month 3.
month_4_minimum_essential_coveragebit (1)NOT NULLThe minimum essential coverage flag for month 4.
month_5_minimum_essential_coveragebit (1)NOT NULLThe minimum essential coverage flag for month 5.
month_6_minimum_essential_coveragebit (1)NOT NULLThe minimum essential coverage flag for month 6.
month_7_minimum_essential_coveragebit (1)NOT NULLThe minimum essential coverage flag for month 7.
month_8_minimum_essential_coveragebit (1)NOT NULLThe minimum essential coverage flag for month 8.
month_9_minimum_essential_coveragebit (1)NOT NULLThe minimum essential coverage flag for month 9.
month_10_minimum_essential_coveragebit (1)NOT NULLThe minimum essential coverage flag for month 10.
month_11_minimum_essential_coveragebit (1)NOT NULLThe minimum essential coverage flag for month 11.
month_12_minimum_essential_coveragebit (1)NOT NULLThe minimum essential coverage flag for month 12.
month_1_full_time_employee_count_overrideint (4)The full time employee count override for month 1. Null indicates not overridden.
month_2_full_time_employee_count_overrideint (4)The full time employee count override for month 2. Null indicates not overridden.
month_3_full_time_employee_count_overrideint (4)The full time employee count override for month 3. Null indicates not overridden.
month_4_full_time_employee_count_overrideint (4)The full time employee count override for month 4. Null indicates not overridden.
month_5_full_time_employee_count_overrideint (4)The full time employee count override for month 5. Null indicates not overridden.
month_6_full_time_employee_count_overrideint (4)The full time employee count override for month 6. Null indicates not overridden.
month_7_full_time_employee_count_overrideint (4)The full time employee count override for month 7. Null indicates not overridden.
month_8_full_time_employee_count_overrideint (4)The full time employee count override for month 8. Null indicates not overridden.
month_9_full_time_employee_count_overrideint (4)The full time employee count override for month 9. Null indicates not overridden.
month_10_full_time_employee_count_overrideint (4)The full time employee count override for month 10. Null indicates not overridden.
month_11_full_time_employee_count_overrideint (4)The full time employee count override for month 11. Null indicates not overridden.
month_12_full_time_employee_count_overrideint (4)The full time employee count override for month 12. Null indicates not overridden.
all_12_months_total_employee_count_overrideint (4)The total employee count override for all months. Null indicates not overridden.
month_1_total_employee_count_overrideint (4)The total employee count override for month 1. Null indicates not overridden.
month_2_total_employee_count_overrideint (4)The total employee count override for month 2. Null indicates not overridden.
month_3_total_employee_count_overrideint (4)The total employee count override for month 3. Null indicates not overridden.
month_4_total_employee_count_overrideint (4)The total employee count override for month 4. Null indicates not overridden.
month_5_total_employee_count_overrideint (4)The total employee count override for month 5. Null indicates not overridden.
month_6_total_employee_count_overrideint (4)The total employee count override for month 6. Null indicates not overridden.
month_7_total_employee_count_overrideint (4)The total employee count override for month 7. Null indicates not overridden.
month_8_total_employee_count_overrideint (4)The total employee count override for month 8. Null indicates not overridden.
month_9_total_employee_count_overrideint (4)The total employee count override for month 9. Null indicates not overridden.
month_10_total_employee_count_overrideint (4)The total employee count override for month 10. Null indicates not overridden.
month_11_total_employee_count_overrideint (4)The total employee count override for month 11. Null indicates not overridden.
month_12_total_employee_count_overrideint (4)The total employee count override for month 12. Null indicates not overridden.
all_12_months__form_1094_section_4980H_code_KEYtinyint (1)The form 1094 section 4980H code selected for all months.
month_1__form_1094_section_4980H_code_KEYtinyint (1)The form 1094 section 4980H code selected for month 1.
month_2__form_1094_section_4980H_code_KEYtinyint (1)The form 1094 section 4980H code selected for month 2.
month_3__form_1094_section_4980H_code_KEYtinyint (1)The form 1094 section 4980H code selected for month 3.
month_4__form_1094_section_4980H_code_KEYtinyint (1)The form 1094 section 4980H code selected for month 4.
month_5__form_1094_section_4980H_code_KEYtinyint (1)The form 1094 section 4980H code selected for month 5.
month_6__form_1094_section_4980H_code_KEYtinyint (1)The form 1094 section 4980H code selected for month 6.
month_7__form_1094_section_4980H_code_KEYtinyint (1)The form 1094 section 4980H code selected for month 7.
month_8__form_1094_section_4980H_code_KEYtinyint (1)The form 1094 section 4980H code selected for month 8.
month_9__form_1094_section_4980H_code_KEYtinyint (1)The form 1094 section 4980H code selected for month 9.
month_10__form_1094_section_4980H_code_KEYtinyint (1)The form 1094 section 4980H code selected for month 10.
month_11__form_1094_section_4980H_code_KEYtinyint (1)The form 1094 section 4980H code selected for month 11.
month_12__form_1094_section_4980H_code_KEYtinyint (1)The form 1094 section 4980H code selected for month 12.
all_12_months_form_1094_aggregated_group_indicatorbit (1)The client was a member of an aggregate group for all 12 months of the year.
month_1_form_1094_aggregated_group_indicator_overridebit (1)The client was a member of an aggregate group during January.
month_2_form_1094_aggregated_group_indicator_overridebit (1)The client was a member of an aggregate group during February.
month_3_form_1094_aggregated_group_indicator_overridebit (1)The client was a member of an aggregate group during March.
month_4_form_1094_aggregated_group_indicator_overridebit (1)The client was a member of an aggregate group during April.
month_5_form_1094_aggregated_group_indicator_overridebit (1)The client was a member of an aggregate group during May.
month_6_form_1094_aggregated_group_indicator_overridebit (1)The client was a member of an aggregate group during June.
month_7_form_1094_aggregated_group_indicator_overridebit (1)The client was a member of an aggregate group during July.
month_8_form_1094_aggregated_group_indicator_overridebit (1)The client was a member of an aggregate group during August.
month_9_form_1094_aggregated_group_indicator_overridebit (1)The client was a member of an aggregate group during September
month_10_form_1094_aggregated_group_indicator_overridebit (1)The client was a member of an aggregate group during october
month_11_form_1094_aggregated_group_indicator_overridebit (1)The client was a member of an aggregate group during November
month_12_form_1094_aggregated_group_indicator_overridebit (1)The client was a member of an aggregate group during December
all_12_months_full_time_employee_count_overrideint (4)The full time employee count override for all 12 months. Null indicates not overriden.
form_1095_corrected_type_KEYtinyint (1)NOT NULLThe form 1095 corrected type key.
corrected_receipt_idnvarchar (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_idint (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
NameColumnsDescription
PK_Client_1095client_1095_KEY
Unique constraints
NameColumnsDescription
UK_Client_1095$client_KEY$form_year$form_1095_corrected_type_KEYclient_KEY, form_year, form_1095_corrected_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_1095__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_1095__Form_1094_Section_4980H_Code__all_12_months__form_1095_coverage_code_KEYall_12_months__form_1094_section_4980H_code_KEYForm_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_KEYmonth_1__form_1094_section_4980H_code_KEYForm_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_KEYmonth_2__form_1094_section_4980H_code_KEYForm_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_KEYmonth_3__form_1094_section_4980H_code_KEYForm_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_KEYmonth_4__form_1094_section_4980H_code_KEYForm_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_KEYmonth_5__form_1094_section_4980H_code_KEYForm_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_KEYmonth_6__form_1094_section_4980H_code_KEYForm_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_KEYmonth_7__form_1094_section_4980H_code_KEYForm_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_KEYmonth_8__form_1094_section_4980H_code_KEYForm_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_KEYmonth_9__form_1094_section_4980H_code_KEYForm_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_KEYmonth_10__form_1094_section_4980H_code_KEYForm_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_KEYmonth_11__form_1094_section_4980H_code_KEYForm_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_KEYmonth_12__form_1094_section_4980H_code_KEYForm_1094_Section_4980H_Code (form_1094_section_4980H_code_KEY)
FK_Client_1095__Form_1095_Corrected_Type__form_1095_corrected_type_KEYform_1095_corrected_type_KEYForm_1095_Corrected_Type (form_1095_corrected_type_KEY)

Schema diagram