Table: dbo.Benefit_Allowance
Columns
Name | Type | Constraints | Description
benefit_allowance_KEY | int (4) | NOT NULL | Primary key of this table
client_benefit_KEY | int (4) | NOT NULL | Parent client benefit record
from_service | int (4) | NOT NULL | Shows a beginning date for a period of employment.
to_service | int (4) | NOT NULL | Shows an end date for a period of employment.
allowance_amount | decimal (5, 4) | NOT NULL | Allowance amount for period.
carryover | decimal (5, 4) | NOT NULL | Amount to be carried over to the next period.
available_limit | decimal (5, 4) | NOT NULL | Limit applicable to allowance amount.
check_limit | decimal (5, 4) | NOT NULL | Accrual amount limit for a check.
month_limit | decimal (5, 4) | NOT NULL | Accrual amount limit on a monthly basis.
annual_limit | decimal (5, 4) | NOT NULL | Accrual amount limit on a yearly basis.

Primary key
Name | Columns | Description
PK_Benefit_Allowance | benefit_allowance_KEY |
Unique constraints
Name | Columns | Description
UK_Benefit_Allowance$client_benefit_KEY$from_service | client_benefit_KEY, from_service |
UK_Benefit_Allowance$client_benefit_KEY$to_service | client_benefit_KEY, to_service |

Foreign keys
Name | Columns | Referenced table | Description
FK_Benefit_Allowance__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Client_Benefit (client_benefit_KEY) |