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