| ORIGINALTAXCLAIMNUMBER |
nvarchar(10) |
|
Default = '' |
Original Tax Claim Number |
| MAXGIFTDATEFROMORIGINALCLAIM |
datetime |
yes |
|
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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| INCLUDETRANSITIONALAMOUNTCODE |
tinyint |
|
Default = 0 |
Indicates whether transitional amount is included in TAXCLAIMAMOUNT. |
| INCLUDETRANSITIONALAMOUNT |
nvarchar(48) (Computed) |
yes |
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) |
yes |
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) |
yes |
case when ORIGINALTRANSITIONALTAXCLAIMAMOUNT = 0 then ORIGINALBASETAXCLAIMAMOUNT when dbo.UFN_REVENUESPLITGIFTAID_TRANSITIONALREFLIEFEXPIRED(ID, INCLUDETRANSITIONALAMOUNTCODE) = 0 then ORIGINALBASETAXCLAIMAMOUNT + ORIGINALTRANSITIONALTAXCLAIMAMOUNT else ORIGINALBASETAXCLAIMAMOUNT end |
|