Table: dbo.Client_1095_Override
This table stores the overrides for client 1095 information.
Columns
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | The primary key.
client_id | nvarchar (22) |  | The client id. Null indicates not overridden.
client_ein | nvarchar (22) |  | The client ein. Null indicates not overridden.
description | nvarchar (100) |  | The description. Null indicates not overridden.
address_1 | nvarchar (100) |  | The address line 1. Null indicates not overridden.
address_2 | nvarchar (100) |  | The address line 2. Null indicates not overridden.
city | nvarchar (60) |  | The city. Null indicates not overridden.
state_abbreviation | nvarchar (4) |  | The state abbreviation. Null indicates not overridden.
postal_code | nvarchar (20) |  | The postal code. Null indicates not overridden.
contact_name | nvarchar (100) |  | The contact name. Null indicates not overridden.
contact_phone | nvarchar (50) |  | The contact phone. Null indicates not overridden.
title | nvarchar (40) |  | The title. Null indicates not overridden.
signature_date | smalldatetime (4) |  | The signature date. Null indicates not overridden.
qualifying_offer_method_indicator | bit (1) |  | Override indicator for the qualifying offer method checkbox on the 1094-C. Null means this column is not overriden
qualifying_offer_method_transition_relief_indicator | bit (1) |  | Override indicator for the qualifying offer method transition relief checkbox on the 1094-C. Null means this column is not overriden
section_4980h_transition_relief_indicator | bit (1) |  | Override indicator for the section 4980H transition relief checkbox on the 1094-C. Null means this column is not overriden
ninety_eight_percent_offer_method_indicator | bit (1) |  | Override indicator for the 98% offer method checkbox on the 1094-C. Null means this column is not overriden
total_number_form1095c_filed_by_ale_member_override | int (4) |  | The total number of Forms 1095-C filed by and/or on behalf of ALE member override.
form_1095_corrected_type_KEY | tinyint (1) | NOT NULL | The form 1095 corrected type key.
healthcare_plan_start_month | nvarchar (20) |  | The month the healthcare plan started.

Primary key
Name | Columns | Description
PK_Client_1095_Override$client_KEY$form_1095_corrected_type_KEY | client_KEY, form_1095_corrected_type_KEY |
Unique constraints
Name | Columns | Description
UK_Client_1095_Override$client_KEY$form_1095_corrected_type_KEY | client_KEY, form_1095_corrected_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_1095_Override__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_1095_Override__Form_1095_Corrected_Type__form_1095_corrected_type_KEY | form_1095_corrected_type_KEY | Form_1095_Corrected_Type (form_1095_corrected_type_KEY) |