Table: dbo.Employee_Benefit
Columns
NameTypeConstraintsDescription
employee_benefit_KEYint (4)NOT NULLPrimary key for this table
client_benefit_KEYint (4)NOT NULLParent client benefit record
employee_KEYint (4)NOT NULLParent employee record
allowance_amountdecimal (5, 4)NOT NULLallowance_amount
available_accrual_limitdecimal (5, 4)NOT NULLavailable_limit
per_month_accrual_limitdecimal (5, 4)NOT NULLper_month_limit
annual_accrual_limitdecimal (5, 4)NOT NULLannual_limit
per_check_accrual_limitdecimal (5, 4)NOT NULLper_check_limit
carryover_maximumdecimal (5, 4)NOT NULLcarryover_maximum
beginning_balancedecimal (5, 4)NOT NULLBalance for which there are no records that support accrual, perhaps an amount converted from an existing system.
balance_adjustmentdecimal (5, 4)NOT NULLadjustment_amount
date_of_previous_balance_resetsmalldatetime (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_datesmalldatetime (4)The date when the employee benefit becomes active. NULL when the employee benefit is not active.
employee_benefit_guiduniqueidentifier (16)NOT NULLA unique GUID key for this row
next_accrual_datesmalldatetime (4)Next date that this benefit should accrue.
annual_usage_limitdecimal (5, 4)NOT NULLMaximum 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_limitdecimal (5, 4)NOT NULLMaximum 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_limitdecimal (5, 4)NOT NULLMaximum 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
NameColumnsDescription
PK_Employee_Benefitemployee_benefit_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Benefit$client_benefit_KEY$employee_KEYclient_benefit_KEY, employee_KEY
UK_Employee_Benefit$employee_benefit_guidemployee_benefit_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Benefit__Client_Benefit__client_benefit_KEYclient_benefit_KEYClient_Benefit (client_benefit_KEY)
FK_Employee_Benefit__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Check_Benefit_Item_Import__Employee_Benefit__employee_benefit_KEYemployee_benefit_KEYPayroll_Check_Benefit_Item_Import
FK_Benefit_Transaction__Employee_Benefit__employee_benefit_KEYemployee_benefit_KEYBenefit_Transaction

Schema diagram