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 |