| BENEFITSWAIVED |
int |
yes |
|
dbo.[REVENUE_EXT].[BENEFITSWAIVED] |
| DONOTACKNOWLEDGE |
int |
yes |
|
dbo.[REVENUE_EXT].[DONOTACKNOWLEDGE] |
| DONOTRECEIPT |
int |
yes |
|
dbo.[REVENUE_EXT].[DONOTRECEIPT] |
| GIVENANONYMOUSLY |
int |
yes |
|
dbo.[REVENUE_EXT].[GIVENANONYMOUSLY] |
| ISORIGINATION |
int |
yes |
|
The revenue is listed in the dbo.[CONSTITUENTORGINATION] table |
| NEEDSRERECEIPT |
int |
yes |
|
[dbo].[REVENUE_EXT].[NEEDSRERECEIPT] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |
| ISDELETEDFINANCIALTRANSACTION |
int |
yes |
|
Flag indicating that the financial transaction is deleted. |
| ISDELETEDFINANCIALTRANSACTIONLINEITEM |
int |
yes |
|
Flag indicating that the financial transaction line item is deleted. |
| BENEFITSWAIVEDDESCRIPTION |
nvarchar(50) |
yes |
|
1="Yes", 0="No", -1="Not used" |
| DONOTACKNOWLEDGEDESCRIPTION |
nvarchar(50) |
yes |
|
1="Yes", 0="No", -1="Not used" |
| DONOTRECEIPTDESCRIPTION |
nvarchar(50) |
yes |
|
1="Yes", 0="No", -1="Not used" |
| GIVENANONYMOUSLYDESCRIPTION |
nvarchar(50) |
yes |
|
1="Yes", 0="No", -1="Not used" |
| ISORIGINATIONDESCRIPTION |
nvarchar(50) |
yes |
|
1="Yes", 0="No", -1="Not used" |
| NEEDSRERECEIPTDESCRIPTION |
nvarchar(50) |
yes |
|
1="Yes", 0="No", -1="Not used" |
| ISDELETEDFINANCIALTRANSACTIONLINEITEMDESCRIPTION |
nvarchar(50) |
yes |
|
1="Yes", 0="No", -1="Not used" |
| ISDELETEDFINANCIALTRANSACTIONDESCRIPTION |
nvarchar(50) |
yes |
|
1="Yes", 0="No", -1="Not used" |