Table: dbo.Insurepay_Accruable_Benefit_Type
Table containing InsurePay accruable benefit types.
Columns
NameTypeConstraintsDescription
insurepay_accruable_benefit_type_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (100)NOT NULLDescription of the Insurepay accruable benefit type.
insurepay_descriptionnvarchar (100)NOT NULLInsurePay accruable benefit type as written in InsurePay file
Primary key
NameColumnsDescription
PK_Insurepay_Accruable_Benefit_Typeinsurepay_accruable_benefit_type_KEY
Unique constraints
NameColumnsDescription
UK_Insurepay_Accruable_Benefit_Type$descriptiondescription
UK_Insurepay_Accruable_Benefit_Type$insurepay_descriptioninsurepay_description
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Benefit__Insurepay_Accruable_Benefit_Type__insurepay_accruable_benefit_type_KEYinsurepay_accruable_benefit_type_KEYClient_Benefit

Schema diagram