Table: dbo.Employee_1095_Covered_Individual
This table stores the employee 1095 Part 3 covered individual information. The form has a single field for name. But the electronic filing requires first name and last name. Suffix is there to distinguish between people with same first and last names.
Columns
NameTypeConstraintsDescription
employee_1095_covered_individual_KEYint (4)NOT NULLThe primary key.
employee_1095_KEYint (4)NOT NULLThe employee 1095 key.
is_employeebit (1)NOT NULLThis does not correspond to a feature on the printed form. It is needed for syncing up of employee demographic data which will be done at the time the form is printed.
first_namenvarchar (60)NOT NULLCovered Individual first name. If empty string it means user did not specify the first name.
last_namenvarchar (60)NOT NULLCovered Individual last name. If empty string it means user did not specify the last name.
suffixnvarchar (10)NOT NULLCovered Individual suffix. If empty string it means user did not specify the suffix.
social_security_numbernvarchar (22)NOT NULLCovered Individual social security number. If empty string it means user did not specify the social security number.
date_of_birthsmalldatetime (4)Covered Individual date of birth. If null it means user did not specify the date of birth.
all_12_months__form_1095_coveragebit (1)NOT NULLCoverage for all 12 months.
month_1__form_1095_coveragebit (1)NOT NULLCoverage for month 1.
month_2__form_1095_coveragebit (1)NOT NULLCoverage for month 2.
month_3__form_1095_coveragebit (1)NOT NULLCoverage for month 3.
month_4__form_1095_coveragebit (1)NOT NULLCoverage for month 4.
month_5__form_1095_coveragebit (1)NOT NULLCoverage for month 5.
month_6__form_1095_coveragebit (1)NOT NULLCoverage for month 6.
month_7__form_1095_coveragebit (1)NOT NULLCoverage for month 7.
month_8__form_1095_coveragebit (1)NOT NULLCoverage for month 8.
month_9__form_1095_coveragebit (1)NOT NULLCoverage for month 9.
month_10__form_1095_coveragebit (1)NOT NULLCoverage for month 10.
month_11__form_1095_coveragebit (1)NOT NULLCoverage for month 11.
month_12__form_1095_coveragebit (1)NOT NULLCoverage for month 12.
Primary key
NameColumnsDescription
PK_Employee_1095_Covered_Individualemployee_1095_covered_individual_KEY
Unique constraints
NameColumnsDescription
UK_Employee_1095_Covered_Individual$employee_1095_covered_individual_KEY$employee_1095_KEYemployee_1095_covered_individual_KEY, employee_1095_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_1095_Covered_Individual__Employee__employee_1095_KEYemployee_1095_KEYEmployee_1095 (employee_1095_KEY)

Schema diagram