Table: dbo.Client_Benefit
Columns
Name | Type | Constraints | Description
client_benefit_KEY | int (4) | NOT NULL | Primary key of table.
client_KEY | int (4) | NOT NULL | Key of associated client.
description | nvarchar (100) | NOT NULL | Description of Client_Benefit record.
graduated_allowance_calculation__length_of_service_selection_KEY | int (4) |  | The unit of time by which the system measures employee service when determining an accruable benefit allowance using a graduated table. Null when the benefit is not configured to use a graduated table.
accrual_method_KEY | nvarchar (40) | NOT NULL | Benefit accrual method
benefit_accrual_balance_reset_type_KEY | nvarchar (26) | NOT NULL | Specifies when the balance resets
basis__compare_to_date_type_KEY | nvarchar (34) | NOT NULL | The kind of date we use to know when the system should accrue a benefit or reset benefit balance.
include_overtime_hours | bit (1) | NOT NULL | Indicates whether overtime hours are considered when calculating the benefit
include_doubletime_hours | bit (1) | NOT NULL | Indicates whether doubletime hours are considered when calculating the benefit
allowance_amount | decimal (5, 4) | NOT NULL | allowance_amount
available_accrual_limit | decimal (5, 4) | NOT NULL | Maximum benefit hours available to use in the current benefit period.
per_month_accrual_limit | decimal (5, 4) | NOT NULL | Maximum benefit hours that may accrue in one calendar month.
annual_accrual_limit | decimal (5, 4) | NOT NULL | Maximum number of benefit hours that may accrue in one calendar year.
per_check_accrual_limit | decimal (5, 4) | NOT NULL | Maximum benefit hours that may accrue on one payroll check.
reset_balances_to_zero | bit (1) | NOT NULL | Indicates if balances are to be reset
carryover_maximum | decimal (5, 4) | NOT NULL | Maximum amount that can be carried over from one accrual period to the next.
balance_reset_date | smalldatetime (4) |  | When balance reset type is per year, this is the calendar date on which the system resets the balance. Otherwise, it is null.
report_description | nvarchar (100) | NOT NULL | Optional description for use on reports, in place of["BR"] benefit description.
department_specific | bit (1) | NOT NULL | Optionally allow the benefit to accrue via time worked["BR"] in a single department or in selected departments.
selection_scope_KEY | int (4) | NOT NULL | worker compensation exemption type key
client_benefit_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row
sequence_number | int (4) | NOT NULL | This user defined sequence number which defines the order which the benefit item should be presented.
benefit_period_usage_type_KEY | int (4) | NOT NULL |
record_status_KEY | int (4) | NOT NULL | The status of the accruable benefit record.
insurepay_accruable_benefit_type_KEY | int (4) |  | A Foreign key for this table. The associated Insurepay_Accruable_Benefit_Type primary key
xactpay_accruable_benefit_type_KEY | int (4) |  | A Foreign key for this table.The associated XactPay_Accruable_Benefit_Type primary key.
accrue_benefits_on_benefit_hours_used | bit (1) | NOT NULL | Flag which denotes if benefit hours are accrued on benefit hours used. Only applicable to Per Hours Worked type benefits.
work_hours_per_benefit_allowance | decimal (5, 4) | NOT NULL | The number of hours an employee must work to accrue the benefit allowance. Only applicable for "Per hourly increment" type accruals.
accrual_delay_value | smallint (2) | NOT NULL | The number of duration units after the employee hire date the employee begins accruing benefit hours.
accrual_delay__benefit_eligibility_duration_type_KEY | tinyint (1) | NOT NULL | Accrual delay duration unit; FK to the Benefit_Eligibility_Duration_Type.
availability_delay_value | smallint (2) | NOT NULL | The number of duration units after the employee hire date that the employee can use accrued benefit hours.
availability_delay__benefit_eligibility_duration_type_KEY | tinyint (1) | NOT NULL | Availability delay duration unit; FK to the Benefit_Eligibility_Duration_Type.
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_Client_Benefit | client_benefit_KEY |
Unique constraints
Name | Columns | Description
UK_Client_Benefit$client_benefit_guid | client_benefit_guid |
UK_Client_Benefit$client_KEY$description | client_KEY, description |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Benefit__Benefit_Accrual_Balance_Reset_Type__benefit_accrual_balance_reset_type_KEY | benefit_accrual_balance_reset_type_KEY | Benefit_Accrual_Balance_Reset_Type (benefit_accrual_balance_reset_type_KEY) |
FK_Client_Benefit__Benefit_Period_Usage_Type__benefit_period_usage_type_KEY | benefit_period_usage_type_KEY | Benefit_Period_Usage_Type (benefit_period_usage_type_KEY) |
FK_Client_Benefit__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_Benefit__Compare_Date_Type__basis__compare_to_date_type_KEY | basis__compare_to_date_type_KEY | Compare_Date_Type (compare_date_type_KEY) |
FK_Client_Benefit__Insurepay_Accruable_Benefit_Type__insurepay_accruable_benefit_type_KEY | insurepay_accruable_benefit_type_KEY | Insurepay_Accruable_Benefit_Type (insurepay_accruable_benefit_type_KEY) |
FK_Client_Benefit__Length_Of_Service_Selection__graduated_allowance_calculation__length_of_service_selection_KEY | graduated_allowance_calculation__length_of_service_selection_KEY | Length_Of_Service_Selection (length_of_service_selection_KEY) |
FK_Client_Benefit__Record_Status__record_status_KEY | record_status_KEY | Record_Status (record_status_KEY) |
FK_Client_Benefit__Selection_Scope__selection_scope_KEY | selection_scope_KEY | Selection_Scope (selection_scope_KEY) |
FK_Client_Benefit__XactPay_Accruable_Benefit_Type__xactpay_accruable_benefit_type_KEY | xactpay_accruable_benefit_type_KEY | XactPay_Accruable_Benefit_Type (xactpay_accruable_benefit_type_KEY) |
FK_Client_Benefit__Accrual_Method__accrual_method_KEY | accrual_method_KEY | Accrual_Method (accrual_method_KEY) |
FK_Client_Benefit$accrual_delay__benefit_eligibility_duration_type_KEY | accrual_delay__benefit_eligibility_duration_type_KEY | Benefit_Eligibility_Duration_Type (benefit_eligibility_duration_type_KEY) |
FK_Client_Benefit$availability_delay__benefit_eligibility_duration_type_KEY | availability_delay__benefit_eligibility_duration_type_KEY | Benefit_Eligibility_Duration_Type (benefit_eligibility_duration_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Ascii_Time_Clock_Client_Benefit_Id_Map$client_benefit_KEY | client_benefit_KEY | Ascii_Time_Clock_Client_Benefit_Id_Map |
FK_Benefit_Item_Worker_Compensation_Exemption__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Benefit_Item_Worker_Compensation_Exemption |
FK_Accrual_Date__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Accrual_Date |
FK_Benefit_Allowance__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Benefit_Allowance |
FK_Insurepay_Client_Class_Code_N_Client_Benefit__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Insurepay_Client_Class_Code_N_Client_Benefit |
FK_Employee_Benefit__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Employee_Benefit |
FK_Import_Template_Column_Payroll_Item_Data__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Import_Template_Column_Payroll_Item_Data |
FK_Import_Template_Column_Employee_Data__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Import_Template_Column_Employee_Data |
FK_ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition__Client_Benefit__client_benefit_KEY | client_benefit_KEY | ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition |
FK_Payroll_Check_Entry_Option_Payroll_Item_Definition__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Payroll_Check_Entry_Option_Payroll_Item_Definition |
FK_Benefit_Accrual_Exclusion_Detail__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Benefit_Accrual_Exclusion_Detail |