Table: dbo.Benefit_Eligibility_Duration_Type
This table stores the time duration types available for accruable benefit eligibility items.
Columns
NameTypeConstraintsDescription
benefit_eligibility_duration_type_KEYtinyint (1)NOT NULLSurrogate primary key.
descriptionnvarchar (12)NOT NULLThe time duration description.
Primary key
NameColumnsDescription
PK_Benefit_Eligibility_Duration_Typebenefit_eligibility_duration_type_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Benefit$accrual_delay__benefit_eligibility_duration_type_KEYaccrual_delay__benefit_eligibility_duration_type_KEYClient_Benefit
FK_Client_Benefit$availability_delay__benefit_eligibility_duration_type_KEYavailability_delay__benefit_eligibility_duration_type_KEYClient_Benefit

Schema diagram