Table: dbo.XactPay_Accruable_Benefit_Type
Table containing XactPay accruable benefit types.
Columns
NameTypeConstraintsDescription
xactpay_accruable_benefit_type_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (100)NOT NULLDescription of the XactPay accruable benefit type.
xactpay_descriptionnvarchar (100)NOT NULLXactPay accruable benefit type as written in XactPay file.
Primary key
NameColumnsDescription
PK_XactPay_Accruable_Benefit_Typexactpay_accruable_benefit_type_KEY
Unique constraints
NameColumnsDescription
UK_XactPay_Accruable_Benefit_Type$descriptiondescription
UK_XactPay_Accruable_Benefit_Type$xactpay_descriptionxactpay_description
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Benefit__XactPay_Accruable_Benefit_Type__xactpay_accruable_benefit_type_KEYxactpay_accruable_benefit_type_KEYClient_Benefit

Schema diagram