Table used to import employee benefits related to a single check. |
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. |