| 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 | ||