USP_DATALIST_REVENUEBATCHCONSTITUENTNAME
Returns a constituent's name given a constituent ID in revenue batch.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_REVENUEBATCHCONSTITUENTNAME
(
@CONSTITUENTID uniqueidentifier
) as
begin
select
CONSTITUENT_NF.NAME,
CONSTITUENT.LOOKUPID
from
dbo.CONSTITUENT
outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) CONSTITUENT_NF
where
CONSTITUENT.ID = @CONSTITUENTID
union all
select
coalesce(CONSTITUENT_NF.NAME, BATCHREVENUECONSTITUENT.NAME),
coalesce(CONSTITUENT.LOOKUPID, '')
from
dbo.BATCHREVENUECONSTITUENT
left outer join
dbo.CONSTITUENT on BATCHREVENUECONSTITUENT.EXISTINGCONSTITUENTID = CONSTITUENT.ID
outer apply
dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) CONSTITUENT_NF
where
BATCHREVENUECONSTITUENT.ID = @CONSTITUENTID
end