Table: dbo.Payroll_Check_Benefit_Item_Import
Table used to import employee benefits related to a single check.
Columns
NameTypeConstraintsDescription
payroll_check_benefit_item_import_KEYint (4)NOT NULLPrimary key for this table
payroll_check_payroll_item_import_KEYint (4)NOT NULLPayroll import item associated with this benefit
employee_benefit_KEYint (4)NOT NULLEmployee benefit this imported data applies to
used_hoursdecimal (5, 4)NOT NULLBenefit hours used for this payroll item. The employees benefit total will eventually be reduced by this amount
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.
Primary key
NameColumnsDescription
PK_Payroll_Check_Benefit_Item_Importpayroll_check_benefit_item_import_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Check_Benefit_Item_Import$payroll_check_payroll_item_import_KEY$employee_benefit_KEYpayroll_check_payroll_item_import_KEY, employee_benefit_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Benefit_Item_Import__Employee_Benefit__employee_benefit_KEYemployee_benefit_KEYEmployee_Benefit (employee_benefit_KEY)
FK_Payroll_Check_Benefit_Item_Import__Payroll_Check_Payroll_Item_Import__payroll_check_payroll_item_import_KEYpayroll_check_payroll_item_import_KEYPayroll_Check_Payroll_Item_Import (payroll_check_payroll_item_import_KEY)

Schema diagram