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 |