V_QUERY_AMRPOIMPORTBATCHEXCEPTIONREPORT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| BATCHID | uniqueidentifier | ||
| RECORDTYPECODE | tinyint | ||
| RECORDTYPE | nvarchar(16) | yes | |
| EVENTID | uniqueidentifier | yes | |
| EVENTNAME | nvarchar(100) | ||
| CURRENCYID | uniqueidentifier | ||
| ISO4217 | nvarchar(3) | ||
| DECIMALDIGITS | tinyint | ||
| CURRENCYSYMBOL | nvarchar(5) | ||
| SYMBOLDISPLAYSETTINGCODE | tinyint | ||
| SEQUENCE | int | ||
| REGISTRANT_NAME | nvarchar(154) | yes | |
| AUCTIONITEM_DONORNAME | nvarchar(154) | yes | |
| PURCHASE_CONSTITUENTNAME | nvarchar(154) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:18:26 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_AMRPOIMPORTBATCHEXCEPTIONREPORT AS
select
BATCHAMPROIMPORT.ID,
BATCHAMPROIMPORT.BATCHID,
BATCHAMPROIMPORT.RECORDTYPECODE,
BATCHAMPROIMPORT.RECORDTYPE,
BATCHAMPROIMPORT.EVENTID,
EVENT.NAME as EVENTNAME,
CURRENCY.ID CURRENCYID,
CURRENCY.ISO4217,
CURRENCY.DECIMALDIGITS,
CURRENCY.CURRENCYSYMBOL,
CURRENCY.SYMBOLDISPLAYSETTINGCODE,
BATCHAMPROIMPORT.SEQUENCE,
null as REGISTRANT_NAME,
null as AUCTIONITEM_DONORNAME,
null as PURCHASE_CONSTITUENTNAME
from
dbo.BATCHAMPROIMPORT
inner join dbo.EVENT on BATCHAMPROIMPORT.EVENTID = EVENT.ID
inner join dbo.CURRENCY on CURRENCY.ID = EVENT.BASECURRENCYID
where
BATCHAMPROIMPORT.RECORDTYPECODE not in (3,4,5)
union all
select
BATCHAMPROIMPORT.ID,
BATCHAMPROIMPORT.BATCHID,
BATCHAMPROIMPORT.RECORDTYPECODE,
BATCHAMPROIMPORT.RECORDTYPE,
BATCHAMPROIMPORT.EVENTID,
EVENT.NAME as EVENTNAME,
CURRENCY.ID CURRENCYID,
CURRENCY.ISO4217,
CURRENCY.DECIMALDIGITS,
CURRENCY.CURRENCYSYMBOL,
CURRENCY.SYMBOLDISPLAYSETTINGCODE,
BATCHAMPROIMPORT.SEQUENCE,
case
when CONSTITUENT.ID is not null then
CONSTITUENT.NAME
else
case
when BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_ISINDIVIDUAL = 1 then
BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_UPDATEDFIRSTNAME + ' ' + BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_UPDATEDKEYNAME
else
BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_UPDATEDKEYNAME
end
end REGISTRANT_NAME,
null as AUCTIONITEM_DONORNAME,
null as PURCHASE_CONSTITUENTNAME
from
dbo.BATCHAMPROIMPORT
inner join dbo.EVENT on BATCHAMPROIMPORT.EVENTID = EVENT.ID
inner join dbo.CURRENCY on CURRENCY.ID = EVENT.BASECURRENCYID
inner join dbo.BATCHAMPROIMPORTREGISTRANT on BATCHAMPROIMPORTREGISTRANT.ID = BATCHAMPROIMPORT.ID
left join dbo.BATCHAMPROIMPORTCONSTITUENT on BATCHAMPROIMPORTCONSTITUENT.ID = BATCHAMPROIMPORTREGISTRANT.REGISTRANT_CONSTITUENTID
left join dbo.CONSTITUENT on CONSTITUENT.ID = BATCHAMPROIMPORTREGISTRANT.REGISTRANT_CONSTITUENTID
where
BATCHAMPROIMPORT.RECORDTYPECODE = 3
union all
select
BATCHAMPROIMPORT.ID,
BATCHAMPROIMPORT.BATCHID,
BATCHAMPROIMPORT.RECORDTYPECODE,
BATCHAMPROIMPORT.RECORDTYPE,
BATCHAMPROIMPORT.EVENTID,
EVENT.NAME as EVENTNAME,
CURRENCY.ID CURRENCYID,
CURRENCY.ISO4217,
CURRENCY.DECIMALDIGITS,
CURRENCY.CURRENCYSYMBOL,
CURRENCY.SYMBOLDISPLAYSETTINGCODE,
BATCHAMPROIMPORT.SEQUENCE,
null as REGISTRANT_NAME,
case
when CONSTITUENT.ID is not null then
CONSTITUENT.NAME
else
case
when BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_ISINDIVIDUAL = 1 then
BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_UPDATEDFIRSTNAME + ' ' + BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_UPDATEDKEYNAME
else
BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_UPDATEDKEYNAME
end
end AUCTIONITEM_DONORNAME,
null as PURCHASE_CONSTITUENTNAME
from
dbo.BATCHAMPROIMPORT
inner join dbo.EVENT on BATCHAMPROIMPORT.EVENTID = EVENT.ID
inner join dbo.CURRENCY on CURRENCY.ID = EVENT.BASECURRENCYID
inner join dbo.BATCHAMPROIMPORTITEM on BATCHAMPROIMPORTITEM.ID = BATCHAMPROIMPORT.ID
left join dbo.BATCHAMPROIMPORTCONSTITUENT on BATCHAMPROIMPORTCONSTITUENT.ID = BATCHAMPROIMPORTITEM.AUCTIONITEM_CONSTITUENTID
left join dbo.CONSTITUENT on CONSTITUENT.ID = BATCHAMPROIMPORTITEM.AUCTIONITEM_CONSTITUENTID
where
BATCHAMPROIMPORT.RECORDTYPECODE = 4
union all
select
BATCHAMPROIMPORT.ID,
BATCHAMPROIMPORT.BATCHID,
BATCHAMPROIMPORT.RECORDTYPECODE,
BATCHAMPROIMPORT.RECORDTYPE,
BATCHAMPROIMPORT.EVENTID,
EVENT.NAME as EVENTNAME,
CURRENCY.ID CURRENCYID,
CURRENCY.ISO4217,
CURRENCY.DECIMALDIGITS,
CURRENCY.CURRENCYSYMBOL,
CURRENCY.SYMBOLDISPLAYSETTINGCODE,
BATCHAMPROIMPORT.SEQUENCE,
null as REGISTRANT_NAME,
null as AUCTIONITEM_DONORNAME,
case
when CONSTITUENT.ID is not null then
CONSTITUENT.NAME
else
case
when BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_ISINDIVIDUAL = 1 then
BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_UPDATEDFIRSTNAME + ' ' + BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_UPDATEDKEYNAME
else
BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_UPDATEDKEYNAME
end
end PURCHASE_CONSTITUENTNAME
from
dbo.BATCHAMPROIMPORT
inner join dbo.EVENT on BATCHAMPROIMPORT.EVENTID = EVENT.ID
inner join dbo.CURRENCY on CURRENCY.ID = EVENT.BASECURRENCYID
inner join dbo.BATCHAMPROIMPORTPURCHASE on BATCHAMPROIMPORTPURCHASE.ID = BATCHAMPROIMPORT.ID
left join dbo.BATCHAMPROIMPORTCONSTITUENT on BATCHAMPROIMPORTCONSTITUENT.ID = BATCHAMPROIMPORTPURCHASE.PURCHASE_CONSTITUENTID
left join dbo.CONSTITUENT on CONSTITUENT.ID = BATCHAMPROIMPORTPURCHASE.PURCHASE_CONSTITUENTID
where
BATCHAMPROIMPORT.RECORDTYPECODE = 5;