Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ORIGINALTAXCLAIMNUMBER nvarchar(10)   Default = '' Original Tax Claim Number
 MAXGIFTDATEFROMORIGINALCLAIM datetime The date of the last revenue item for this constituent that was included in the tax claim.
 TOTALGIFTAMOUNTFROMORIGINALCLAIM money   Default = 0 Total gift amount included for this constituent in the tax claim.
 TOTALTAXCLAIMAMOUNTFROMORIGINALCLAIM money   Default = 0 Total tax claimed for this constituent.
 ORIGINALBASETAXCLAIMAMOUNT money   Default = 0 Base Tax Claim Amount
 ORIGINALTRANSITIONALTAXCLAIMAMOUNT money   Default = 0 Transitional Tax Claim Amount
 REFUNDSOURCECODE tinyint   Default = 0 0=Eligibility changed, 1=Manually refunded, 2=Application adjusted
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 INCLUDETRANSITIONALAMOUNTCODE tinyint   Default = 0 Indicates whether transitional amount is included in TAXCLAIMAMOUNT.
 INCLUDETRANSITIONALAMOUNT nvarchar(48) (Computed) CASE [INCLUDETRANSITIONALAMOUNTCODE] WHEN 0 THEN N'Calculate whether to include in tax claim amount' WHEN 1 THEN N'Include in tax claim amount' WHEN 2 THEN N'Exclude from tax claim amount' END Provides a translation for the 'INCLUDETRANSITIONALAMOUNTCODE' field.
 REFUNDSOURCE nvarchar(20) (Computed) CASE [REFUNDSOURCECODE] WHEN 0 THEN N'Eligibility changed' WHEN 1 THEN N'Manually refunded' WHEN 2 THEN N'Application adjusted' END Provides a translation for the 'REFUNDSOURCECODE' field.
 ORIGINALGIFTAMOUNT money   Default = 0 Stores the original gift amount to handle cases where the application amounts are changed after a manual refund or sparking an adjustment refund.
 ORIGINALTAXCLAIMAMOUNT money (Computed) case when ORIGINALTRANSITIONALTAXCLAIMAMOUNT = 0 then ORIGINALBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then ORIGINALBASETAXCLAIMAMOUNT + ORIGINALTRANSITIONALTAXCLAIMAMOUNT else ORIGINALBASETAXCLAIMAMOUNT end

Foreign Key Field Type Null Notes Description
 R68ID uniqueidentifier   R68.ID Indicates in which R68 business process parameter set the refund has been included.
 REVENUESPLITID uniqueidentifier   FINANCIALTRANSACTIONLINEITEM.ID FK to REVENUESPLIT
 CONSTITUENTID uniqueidentifier   CONSTITUENT.LOCALID FK to CONSTITUENT
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_R68REFUNDDETAIL_CONSTITUENTID CONSTITUENTID      
 IX_R68REFUNDDETAIL_DATEADDED DATEADDED    
 IX_R68REFUNDDETAIL_DATECHANGED DATECHANGED      
 PK_R68REFUNDDETAIL ID  

Trigger Name Description
 TR_R68REFUNDDETAIL_AUDIT_UPDATE
 TR_R68REFUNDDETAIL_AUDIT_DELETE

Entity-Relationship diagram of this table