employee_benefit_KEY | int (4) | NOT NULL | Primary key for this table |
client_benefit_KEY | int (4) | NOT NULL | Parent client benefit record |
employee_KEY | int (4) | NOT NULL | Parent employee record |
allowance_amount | decimal (5, 4) | NOT NULL | allowance_amount |
available_accrual_limit | decimal (5, 4) | NOT NULL | available_limit |
per_month_accrual_limit | decimal (5, 4) | NOT NULL | per_month_limit |
annual_accrual_limit | decimal (5, 4) | NOT NULL | annual_limit |
per_check_accrual_limit | decimal (5, 4) | NOT NULL | per_check_limit |
carryover_maximum | decimal (5, 4) | NOT NULL | carryover_maximum |
beginning_balance | decimal (5, 4) | NOT NULL | Balance for which there are no records that support accrual, perhaps an amount converted from an existing system. |
balance_adjustment | decimal (5, 4) | NOT NULL | adjustment_amount |
date_of_previous_balance_reset | smalldatetime (4) | | The last time we reset the accrual balance. Null when the benefit is configured to never reset the accrual balance. Also NULL when the benefit is configured to reset but we have not reached the point in time where we should do the first reset. |
activation_date | smalldatetime (4) | | The date when the employee benefit becomes active. NULL when the employee benefit is not active. |
employee_benefit_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row |
next_accrual_date | smalldatetime (4) | | Next date that this benefit should accrue. |
annual_usage_limit | decimal (5, 4) | NOT NULL | Maximum number of benefit hours that may used in one benefit year. Could be employee career, calendar year, or anniversary based on the benefit reset method. Not to be confused with the limit on hours that can accrue in a year. |
per_month_usage_limit | decimal (5, 4) | NOT NULL | Maximum number of benefit hours that may used in the current calendar month. If the check is in a particular month the limit will just be on hours in that month. Not to be confused with the limit on hours that can accrue in a month. |
per_check_usage_limit | decimal (5, 4) | NOT NULL | Maximum number of benefit hours that may used on one payroll check. Not to be confused with the limit on hours that can accrue on a payroll check. |