Table: dbo.Benefit_Transaction
Columns
Name | Type | Constraints | Description
benefit_transaction_KEY | int (4) | NOT NULL | Primary key of this table
bank_transaction_KEY | int (4) |  | Parent payroll check used to compute this transaction
employee_benefit_KEY | int (4) | NOT NULL | Parent employee benefit
accrued_hours | decimal (5, 4) | NOT NULL | Amount accrued
accrual_date | smalldatetime (4) |  | Date of accrual
payroll_check_payroll_item_distribution_KEY | int (4) |  | Optional associated payroll item distribution
benefit_transaction_type_KEY | int (4) | NOT NULL | Benefit transaction type foreign key.
accrued_hours_override | decimal (5, 4) |  | User override of the accrued_hours field.

Primary key
Name | Columns | Description
PK_Benefit_Transaction | benefit_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Benefit_Transaction__Benefit_Transaction_Type__benefit_transaction_type_KEY | benefit_transaction_type_KEY | Benefit_Transaction_Type (benefit_transaction_type_KEY) |
FK_Benefit_Transaction__Employee_Benefit__employee_benefit_KEY | employee_benefit_KEY | Employee_Benefit (employee_benefit_KEY) |
FK_Benefit_Transaction__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Bank_Transaction (bank_transaction_KEY) |
FK_Benefit_Transaction__Payroll_Check_Payroll_Item_Distribution__payroll_check_payroll_item_distribution_KEY | payroll_check_payroll_item_distribution_KEY | Payroll_Check_Payroll_Item_Distribution (payroll_check_payroll_item_distribution_KEY) |