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 | |