Table: dbo.Benefit_Allowance
Columns
NameTypeConstraintsDescription
benefit_allowance_KEYint (4)NOT NULLPrimary key of this table
client_benefit_KEYint (4)NOT NULLParent client benefit record
from_serviceint (4)NOT NULLShows a beginning date for a period of employment.
to_serviceint (4)NOT NULLShows an end date for a period of employment.
allowance_amountdecimal (5, 4)NOT NULLAllowance amount for period.
carryoverdecimal (5, 4)NOT NULLAmount to be carried over to the next period.
available_limitdecimal (5, 4)NOT NULLLimit applicable to allowance amount.
check_limitdecimal (5, 4)NOT NULLAccrual amount limit for a check.
month_limitdecimal (5, 4)NOT NULLAccrual amount limit on a monthly basis.
annual_limitdecimal (5, 4)NOT NULLAccrual amount limit on a yearly basis.
Primary key
NameColumnsDescription
PK_Benefit_Allowancebenefit_allowance_KEY
Unique constraints
NameColumnsDescription
UK_Benefit_Allowance$client_benefit_KEY$from_serviceclient_benefit_KEY, from_service
UK_Benefit_Allowance$client_benefit_KEY$to_serviceclient_benefit_KEY, to_service
Foreign keys
NameColumnsReferenced tableDescription
FK_Benefit_Allowance__Client_Benefit__client_benefit_KEYclient_benefit_KEYClient_Benefit (client_benefit_KEY)

Schema diagram