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 | |||
Name | Type | Constraints | Description |
employee_1095_covered_individual_KEY | int (4) | NOT NULL | The primary key. |
employee_1095_KEY | int (4) | NOT NULL | The employee 1095 key. |
is_employee | bit (1) | NOT NULL | This 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_name | nvarchar (60) | NOT NULL | Covered Individual first name. If empty string it means user did not specify the first name. |
last_name | nvarchar (60) | NOT NULL | Covered Individual last name. If empty string it means user did not specify the last name. |
suffix | nvarchar (10) | NOT NULL | Covered Individual suffix. If empty string it means user did not specify the suffix. |
social_security_number | nvarchar (22) | NOT NULL | Covered Individual social security number. If empty string it means user did not specify the social security number. |
date_of_birth | smalldatetime (4) | Covered Individual date of birth. If null it means user did not specify the date of birth. | |
all_12_months__form_1095_coverage | bit (1) | NOT NULL | Coverage for all 12 months. |
month_1__form_1095_coverage | bit (1) | NOT NULL | Coverage for month 1. |
month_2__form_1095_coverage | bit (1) | NOT NULL | Coverage for month 2. |
month_3__form_1095_coverage | bit (1) | NOT NULL | Coverage for month 3. |
month_4__form_1095_coverage | bit (1) | NOT NULL | Coverage for month 4. |
month_5__form_1095_coverage | bit (1) | NOT NULL | Coverage for month 5. |
month_6__form_1095_coverage | bit (1) | NOT NULL | Coverage for month 6. |
month_7__form_1095_coverage | bit (1) | NOT NULL | Coverage for month 7. |
month_8__form_1095_coverage | bit (1) | NOT NULL | Coverage for month 8. |
month_9__form_1095_coverage | bit (1) | NOT NULL | Coverage for month 9. |
month_10__form_1095_coverage | bit (1) | NOT NULL | Coverage for month 10. |
month_11__form_1095_coverage | bit (1) | NOT NULL | Coverage for month 11. |
month_12__form_1095_coverage | bit (1) | NOT NULL | Coverage for month 12. |
Primary key | |||
Name | Columns | Description | |
PK_Employee_1095_Covered_Individual | employee_1095_covered_individual_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Employee_1095_Covered_Individual$employee_1095_covered_individual_KEY$employee_1095_KEY | employee_1095_covered_individual_KEY, employee_1095_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Employee_1095_Covered_Individual__Employee__employee_1095_KEY | employee_1095_KEY | Employee_1095 (employee_1095_KEY) |