USP_SIMPLEDATALIST_REVENUEBATCHCONSTITUENTACCOUNT

This simple datalist returns the accounts for a given constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID1	uniqueidentifier	IN	Constituent
@CONSTITUENTID2	uniqueidentifier	IN	Constituent

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_REVENUEBATCHCONSTITUENTACCOUNT
(
  @CONSTITUENTID1 uniqueidentifier = null,
  @CONSTITUENTID2 uniqueidentifier = null
)
as
  set nocount on;

  declare @CONSTITUENTID uniqueidentifier = coalesce(@CONSTITUENTID1, @CONSTITUENTID2);

  -- Open the symmetric key for decryption

  exec dbo.USP_GET_KEY_ACCESS;

  select
    ID as VALUE,
    DESCRIPTION as LABEL
  from
  (
    select 
      CONSTITUENTACCOUNT.ID,
      CONSTITUENTACCOUNT.DESCRIPTION
    from
      dbo.CONSTITUENTACCOUNT
    where
      CONSTITUENTID = @CONSTITUENTID

    union all

    select 
      BATCHREVENUECONSTITUENTACCOUNT.ID,
      BATCHREVENUECONSTITUENTACCOUNT.DESCRIPTION
    from
      dbo.BATCHREVENUECONSTITUENTACCOUNT
    where
      CONSTITUENTID = @CONSTITUENTID
  ) as CONSTITUENTACCOUNTS
  order by
    DESCRIPTION

  close symmetric key sym_BBInfinity;