Table: dbo.Payroll_Check_Payroll_Item_Import
Columns
Name | Type | Constraints | Description
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 |

Primary key
Name | Columns | Description
PK_Payroll_Check_Payroll_Item_Import | payroll_check_payroll_item_import_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_Payroll_Item_Import__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Payroll_Check_Payroll_Item_Import__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Client_Pay_Schedule (client_pay_schedule_KEY) |
FK_Payroll_Check_Payroll_Item_Import__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY | Client_Pay_Schedule_Detail (client_pay_schedule_detail_KEY) |
FK_Payroll_Check_Payroll_Item_Import__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Payroll_Check_Payroll_Item_Import__Employee_Payroll_Item__employee_payroll_item_KEY | employee_payroll_item_KEY | Employee_Payroll_Item (employee_payroll_item_KEY) |
FK_Payroll_Check_Payroll_Item_Import__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_department_KEY | employee_work_location_payroll_department_KEY | Employee_Work_Location_Payroll_Department (employee_work_location_payroll_department_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
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_Benefit_Item_Import |