USP_SIMPLEDATALIST_CONSTITUENTACCOUNTFORWEB

This simple datalist returns the accounts (only last 4 digits) for a given constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent

Definition

Copy



            create procedure dbo.USP_SIMPLEDATALIST_CONSTITUENTACCOUNTFORWEB(@CONSTITUENTID uniqueidentifier = null)
            as
                set nocount on;

            begin try
                -- Open the symmetric key for decryption

                exec dbo.USP_GET_KEY_ACCESS;

                select 
                    CONSTITUENTACCOUNT.ID as VALUE,
                    dbo.UFN_CONSTITUENTACCOUNT_GETACCOUNTNUMBERINWEBFORMAT(FINANCIALINSTITUTION.FINANCIALINSTITUTION, coalesce(convert(nvarchar(50), DecryptByKey(CONSTITUENTACCOUNT.ACCOUNTNUMBER)),''), CONSTITUENTACCOUNT.ACCOUNTTYPE) as LABEL
                from
                    dbo.CONSTITUENTACCOUNT
                inner join
                    dbo.FINANCIALINSTITUTION
                on
                    CONSTITUENTACCOUNT.FINANCIALINSTITUTIONID = FINANCIALINSTITUTION.ID
                where
                    CONSTITUENTID = @CONSTITUENTID
                order by
                    CONSTITUENTACCOUNT.DATEADDED;

                close symmetric key sym_BBInfinity;
            end try

            begin catch
                close symmetric key sym_BBInfinity;
            end catch