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 |