Table: dbo.Payroll_Check_Benefit_Item_Import
Table used to import employee benefits related to a single check.
Columns
Name | Type | Constraints | Description
payroll_check_benefit_item_import_KEY | int (4) | NOT NULL | Primary key for this table
payroll_check_payroll_item_import_KEY | int (4) | NOT NULL | Payroll import item associated with this benefit
employee_benefit_KEY | int (4) | NOT NULL | Employee benefit this imported data applies to
used_hours | decimal (5, 4) | NOT NULL | Benefit hours used for this payroll item. The employees benefit total will eventually be reduced by this amount
provisional_marker | nvarchar (200) |  | If set, indicates the record is not ready for processing into a check. Records with the same value belong to the same batch of provisional items.

Primary key
Name | Columns | Description
PK_Payroll_Check_Benefit_Item_Import | payroll_check_benefit_item_import_KEY |
Unique constraints
Name | Columns | Description
UK_Payroll_Check_Benefit_Item_Import$payroll_check_payroll_item_import_KEY$employee_benefit_KEY | payroll_check_payroll_item_import_KEY, employee_benefit_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_Benefit_Item_Import__Employee_Benefit__employee_benefit_KEY | employee_benefit_KEY | Employee_Benefit (employee_benefit_KEY) |
FK_Payroll_Check_Benefit_Item_Import__Payroll_Check_Payroll_Item_Import__payroll_check_payroll_item_import_KEY | payroll_check_payroll_item_import_KEY | Payroll_Check_Payroll_Item_Import (payroll_check_payroll_item_import_KEY) |