Table: dbo.Benefit_Transaction
Columns
NameTypeConstraintsDescription
benefit_transaction_KEYint (4)NOT NULLPrimary key of this table
bank_transaction_KEYint (4)Parent payroll check used to compute this transaction
employee_benefit_KEYint (4)NOT NULLParent employee benefit
accrued_hoursdecimal (5, 4)NOT NULLAmount accrued
accrual_datesmalldatetime (4)Date of accrual
payroll_check_payroll_item_distribution_KEYint (4)Optional associated payroll item distribution
benefit_transaction_type_KEYint (4)NOT NULLBenefit transaction type foreign key.
accrued_hours_overridedecimal (5, 4)User override of the accrued_hours field.
Primary key
NameColumnsDescription
PK_Benefit_Transactionbenefit_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Benefit_Transaction__Benefit_Transaction_Type__benefit_transaction_type_KEYbenefit_transaction_type_KEYBenefit_Transaction_Type (benefit_transaction_type_KEY)
FK_Benefit_Transaction__Employee_Benefit__employee_benefit_KEYemployee_benefit_KEYEmployee_Benefit (employee_benefit_KEY)
FK_Benefit_Transaction__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYPayroll_Bank_Transaction (bank_transaction_KEY)
FK_Benefit_Transaction__Payroll_Check_Payroll_Item_Distribution__payroll_check_payroll_item_distribution_KEYpayroll_check_payroll_item_distribution_KEYPayroll_Check_Payroll_Item_Distribution (payroll_check_payroll_item_distribution_KEY)

Schema diagram