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