USP_DATALIST_FINANCIALACCOUNTSBYCONSTITUENT

Returns a list of all financial accounts for a constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            create procedure dbo.USP_DATALIST_FINANCIALACCOUNTSBYCONSTITUENT(@CONSTITUENTID uniqueidentifier = null)
            as

            set nocount on;

            begin try

                -- Open the symmetric key for decryption

                exec dbo.USP_GET_KEY_ACCESS;

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

            begin catch
                close symmetric key sym_BBInfinity;
            end catch