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