| payroll_check_payroll_item_import_KEY | int (4) | NOT NULL | Primary key for the Payroll_Check_Payroll_Item_Import table. |
| client_KEY | int (4) | NOT NULL | Key of associated client. Kinda redundant. Could use employee_KEY to find it. |
| client_pay_schedule_KEY | int (4) | NOT NULL | Pay schedule this item applies to |
| client_pay_schedule_detail_KEY | int (4) | NOT NULL | Pay schedule detail this item applies to |
| employee_KEY | int (4) | NOT NULL | Associated employee. |
| employee_work_location_payroll_department_KEY | int (4) | NOT NULL | Employee work location payroll department this item applies to. |
| employee_payroll_item_KEY | int (4) | NOT NULL | Employee payroll item this imported data applies to. |
| reg_hours | decimal (5, 4) | NOT NULL | Regular hours |
| ot_hours | decimal (5, 4) | NOT NULL | Overtime hours |
| dt_hours | decimal (5, 4) | NOT NULL | Doubletime hours |
| rate_original | decimal (9, 4) | NOT NULL | Hourly rate |
| amount_original | decimal (9, 2) | NOT NULL | 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. |
| amount_override | decimal (9, 2) | | Overridden amount |
| rate_override | decimal (9, 4) | | Overridden rate |
| amount | decimal (9, 2) | NOT NULL | |
| rate | decimal (9, 4) | NOT NULL | |