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. |