Table: dbo.Form_1095_Coverage_Code__Individual_Months
This table stores the 1095 coverage codes that are valid for individual months.
Columns
NameTypeConstraintsDescription
form_1095_coverage_code_KEYtinyint (1)NOT NULLThe primary key.
Primary key
NameColumnsDescription
PK_Form_1095_Coverage_Code__Individual_Months$form_1095_coverage_code_KEYform_1095_coverage_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1095_Coverage_Code__Individual_Months__Form_1095_Coverage_Code__form_1095_coverage_code_KEYform_1095_coverage_code_KEYForm_1095_Coverage_Code (form_1095_coverage_code_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee_1095_Override__Form_1095_Coverage_Code__Individual_Month__month_1__form_1095_coverage_code_KEYmonth_1__form_1095_coverage_code_KEYEmployee_1095_Override
FK_Employee_1095_Override__Form_1095_Coverage_Code__Individual_Month__month_2__form_1095_coverage_code_KEYmonth_2__form_1095_coverage_code_KEYEmployee_1095_Override
FK_Employee_1095_Override__Form_1095_Coverage_Code__Individual_Month__month_3__form_1095_coverage_code_KEYmonth_3__form_1095_coverage_code_KEYEmployee_1095_Override
FK_Employee_1095_Override__Form_1095_Coverage_Code__Individual_Month__month_4__form_1095_coverage_code_KEYmonth_4__form_1095_coverage_code_KEYEmployee_1095_Override
FK_Employee_1095_Override__Form_1095_Coverage_Code__Individual_Month__month_5__form_1095_coverage_code_KEYmonth_5__form_1095_coverage_code_KEYEmployee_1095_Override
FK_Employee_1095_Override__Form_1095_Coverage_Code__Individual_Month__month_6__form_1095_coverage_code_KEYmonth_6__form_1095_coverage_code_KEYEmployee_1095_Override
FK_Employee_1095_Override__Form_1095_Coverage_Code__Individual_Month__month_7__form_1095_coverage_code_KEYmonth_7__form_1095_coverage_code_KEYEmployee_1095_Override
FK_Employee_1095_Override__Form_1095_Coverage_Code__Individual_Month__month_8__form_1095_coverage_code_KEYmonth_8__form_1095_coverage_code_KEYEmployee_1095_Override
FK_Employee_1095_Override__Form_1095_Coverage_Code__Individual_Month__month_9__form_1095_coverage_code_KEYmonth_9__form_1095_coverage_code_KEYEmployee_1095_Override
FK_Employee_1095_Override__Form_1095_Coverage_Code__Individual_Month__month_10__form_1095_coverage_code_KEYmonth_10__form_1095_coverage_code_KEYEmployee_1095_Override
FK_Employee_1095_Override__Form_1095_Coverage_Code__Individual_Month__month_11__form_1095_coverage_code_KEYmonth_11__form_1095_coverage_code_KEYEmployee_1095_Override
FK_Employee_1095_Override__Form_1095_Coverage_Code__Individual_Month__month_12__form_1095_coverage_code_KEYmonth_12__form_1095_coverage_code_KEYEmployee_1095_Override
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_1__form_1095_coverage_code_KEYmonth_1__form_1095_coverage_code_KEYEmployee_1095
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_2__form_1095_coverage_code_KEYmonth_2__form_1095_coverage_code_KEYEmployee_1095
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_3__form_1095_coverage_code_KEYmonth_3__form_1095_coverage_code_KEYEmployee_1095
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_4__form_1095_coverage_code_KEYmonth_4__form_1095_coverage_code_KEYEmployee_1095
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_5__form_1095_coverage_code_KEYmonth_5__form_1095_coverage_code_KEYEmployee_1095
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_6__form_1095_coverage_code_KEYmonth_6__form_1095_coverage_code_KEYEmployee_1095
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_7__form_1095_coverage_code_KEYmonth_7__form_1095_coverage_code_KEYEmployee_1095
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_8__form_1095_coverage_code_KEYmonth_8__form_1095_coverage_code_KEYEmployee_1095
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_9__form_1095_coverage_code_KEYmonth_9__form_1095_coverage_code_KEYEmployee_1095
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_10__form_1095_coverage_code_KEYmonth_10__form_1095_coverage_code_KEYEmployee_1095
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_11__form_1095_coverage_code_KEYmonth_11__form_1095_coverage_code_KEYEmployee_1095
FK_Employee_1095__Form_1095_Coverage_Code__Individual_Month__month_12__form_1095_coverage_code_KEYmonth_12__form_1095_coverage_code_KEYEmployee_1095

Schema diagram