Table: dbo.Employee_Benefit
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Employee_Benefit | employee_benefit_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_Benefit$client_benefit_KEY$employee_KEY | client_benefit_KEY, employee_KEY |
UK_Employee_Benefit$employee_benefit_guid | employee_benefit_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Benefit__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Client_Benefit (client_benefit_KEY) |
FK_Employee_Benefit__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Payroll_Check_Benefit_Item_Import__Employee_Benefit__employee_benefit_KEY | employee_benefit_KEY | Payroll_Check_Benefit_Item_Import |
FK_Benefit_Transaction__Employee_Benefit__employee_benefit_KEY | employee_benefit_KEY | Benefit_Transaction |