Table: dbo.Payroll_Check_Payroll_Item_Import
Columns
NameTypeConstraintsDescription
payroll_check_payroll_item_import_KEYint (4)NOT NULLPrimary key for the Payroll_Check_Payroll_Item_Import table.
client_KEYint (4)NOT NULLKey of associated client. Kinda redundant. Could use employee_KEY to find it.
client_pay_schedule_KEYint (4)NOT NULLPay schedule this item applies to
client_pay_schedule_detail_KEYint (4)NOT NULLPay schedule detail this item applies to
employee_KEYint (4)NOT NULLAssociated employee.
employee_work_location_payroll_department_KEYint (4)NOT NULLEmployee work location payroll department this item applies to.
employee_payroll_item_KEYint (4)NOT NULLEmployee payroll item this imported data applies to.
reg_hoursdecimal (5, 4)NOT NULLRegular hours
ot_hoursdecimal (5, 4)NOT NULLOvertime hours
dt_hoursdecimal (5, 4)NOT NULLDoubletime hours
rate_originaldecimal (9, 4)NOT NULLHourly rate
amount_originaldecimal (9, 2)NOT NULLAmount
provisional_markernvarchar (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_overridedecimal (9, 2)Overridden amount
rate_overridedecimal (9, 4)Overridden rate
amountdecimal (9, 2)NOT NULL
ratedecimal (9, 4)NOT NULL
Primary key
NameColumnsDescription
PK_Payroll_Check_Payroll_Item_Importpayroll_check_payroll_item_import_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Payroll_Item_Import__Client__client_KEYclient_KEYClient (client_KEY)
FK_Payroll_Check_Payroll_Item_Import__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYClient_Pay_Schedule (client_pay_schedule_KEY)
FK_Payroll_Check_Payroll_Item_Import__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEYClient_Pay_Schedule_Detail (client_pay_schedule_detail_KEY)
FK_Payroll_Check_Payroll_Item_Import__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Payroll_Check_Payroll_Item_Import__Employee_Payroll_Item__employee_payroll_item_KEYemployee_payroll_item_KEYEmployee_Payroll_Item (employee_payroll_item_KEY)
FK_Payroll_Check_Payroll_Item_Import__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_department_KEYemployee_work_location_payroll_department_KEYEmployee_Work_Location_Payroll_Department (employee_work_location_payroll_department_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Check_Benefit_Item_Import__Payroll_Check_Payroll_Item_Import__payroll_check_payroll_item_import_KEYpayroll_check_payroll_item_import_KEYPayroll_Check_Benefit_Item_Import

Schema diagram