USP_SIMPLEDATALIST_CONSTITUENTACCOUNT

            CREATE procedure dbo.USP_SIMPLEDATALIST_CONSTITUENTACCOUNT(@CONSTITUENTID uniqueidentifier = null)
            as
                set nocount on;

                -- Open the symmetric key for decryption

                exec dbo.USP_GET_KEY_ACCESS;

                select 
                    CONSTITUENTACCOUNT.ID as VALUE,
                    CONSTITUENTACCOUNT.DESCRIPTION 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;