Table: dbo.Client_1095_Override
This table stores the overrides for client 1095 information.
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLThe primary key.
client_idnvarchar (22)The client id. Null indicates not overridden.
client_einnvarchar (22)The client ein. Null indicates not overridden.
descriptionnvarchar (100)The description. Null indicates not overridden.
address_1nvarchar (100)The address line 1. Null indicates not overridden.
address_2nvarchar (100)The address line 2. Null indicates not overridden.
citynvarchar (60)The city. Null indicates not overridden.
state_abbreviationnvarchar (4)The state abbreviation. Null indicates not overridden.
postal_codenvarchar (20)The postal code. Null indicates not overridden.
contact_namenvarchar (100)The contact name. Null indicates not overridden.
contact_phonenvarchar (50)The contact phone. Null indicates not overridden.
titlenvarchar (40)The title. Null indicates not overridden.
signature_datesmalldatetime (4)The signature date. Null indicates not overridden.
qualifying_offer_method_indicatorbit (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_indicatorbit (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_indicatorbit (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_indicatorbit (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_overrideint (4)The total number of Forms 1095-C filed by and/or on behalf of ALE member override.
form_1095_corrected_type_KEYtinyint (1)NOT NULLThe form 1095 corrected type key.
healthcare_plan_start_monthnvarchar (20)The month the healthcare plan started.
Primary key
NameColumnsDescription
PK_Client_1095_Override$client_KEY$form_1095_corrected_type_KEYclient_KEY, form_1095_corrected_type_KEY
Unique constraints
NameColumnsDescription
UK_Client_1095_Override$client_KEY$form_1095_corrected_type_KEYclient_KEY, form_1095_corrected_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_1095_Override__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_1095_Override__Form_1095_Corrected_Type__form_1095_corrected_type_KEYform_1095_corrected_type_KEYForm_1095_Corrected_Type (form_1095_corrected_type_KEY)

Schema diagram