| Table: dbo.Print_1095 | |||
| This table holds information for a form 1095 print run. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| print_1095_KEY | int (4) | NOT NULL | The primary key. |
| user_session_guid | uniqueidentifier (16) | NOT NULL | The user session GUID. |
| form_year | int (4) | NOT NULL | The year that this data is associated with. |
| client_KEY | int (4) | NOT NULL | The client that this data is associated with. |
| month_1_full_time_employee_count | int (4) | Full time employee count for month 1. | |
| month_2_full_time_employee_count | int (4) | Full time employee count for month 2. | |
| month_3_full_time_employee_count | int (4) | Full time employee count for month 3. | |
| month_4_full_time_employee_count | int (4) | Full time employee count for month 4. | |
| month_5_full_time_employee_count | int (4) | Full time employee count for month 5. | |
| month_6_full_time_employee_count | int (4) | Full time employee count for month 6. | |
| month_7_full_time_employee_count | int (4) | Full time employee count for month 7. | |
| month_8_full_time_employee_count | int (4) | Full time employee count for month 8. | |
| month_9_full_time_employee_count | int (4) | Full time employee count for month 9. | |
| month_10_full_time_employee_count | int (4) | Full time employee count for month 10. | |
| month_11_full_time_employee_count | int (4) | Full time employee count for month 11. | |
| month_12_full_time_employee_count | int (4) | Full time employee count for month 12. | |
| all_12_months_total_employee_count | int (4) | Total employee count for all months. | |
| month_1_total_employee_count | int (4) | Total employee count for month 1. | |
| month_2_total_employee_count | int (4) | Total employee count for month 2. | |
| month_3_total_employee_count | int (4) | Total employee count for month 3. | |
| month_4_total_employee_count | int (4) | Total employee count for month 4. | |
| month_5_total_employee_count | int (4) | Total employee count for month 5. | |
| month_6_total_employee_count | int (4) | Total employee count for month 6. | |
| month_7_total_employee_count | int (4) | Total employee count for month 7. | |
| month_8_total_employee_count | int (4) | Total employee count for month 8. | |
| month_9_total_employee_count | int (4) | Total employee count for month 9. | |
| month_10_total_employee_count | int (4) | Total employee count for month 10. | |
| month_11_total_employee_count | int (4) | Total employee count for month 11. | |
| month_12_total_employee_count | int (4) | Total employee count for month 12. | |
| all_12_months_full_time_employee_count | int (4) | The full time employee count for all 12 months. Null indicates not specified | |
| form_1095_corrected_type_KEY | tinyint (1) | NOT NULL | The form 1095 corrected type key. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Print_1095 | print_1095_KEY | ||
| Incoming foreign keys | |||
| Name | Columns | Referencing table | Description |
| FK_Print_1095_Selection__Print_1095__print_1095_KEY | print_1095_KEY | Print_1095_Selection | |