Table: dbo.Benefit_Period_Usage_Type
The type table used to store accruable benefit period usage types.
Columns
NameTypeConstraintsDescription
benefit_period_usage_type_KEYint (4)NOT NULLThe key for this benefit period usage record.
descriptionnvarchar (40)NOT NULLThe description for this benefit period usage record.
Primary key
NameColumnsDescription
PK_Benefit_Period_Usage_Typebenefit_period_usage_type_KEY
Unique constraints
NameColumnsDescription
UK_Benefit_Period_Usage_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Benefit__Benefit_Period_Usage_Type__benefit_period_usage_type_KEYbenefit_period_usage_type_KEYClient_Benefit

Schema diagram