USP_DATALIST_WEALTHINFORMATIONDASHBOARDEDUCATIONALINVOLVEMENTS

This datalist returns a constituent's educational involvements that are used by the prospect research dashboard.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent ID
@ISVISIBLE	bit	IN	Is visible

Definition

Copy



                    create procedure dbo.USP_DATALIST_WEALTHINFORMATIONDASHBOARDEDUCATIONALINVOLVEMENTS
                    (
              @CONSTITUENTID uniqueidentifier,
              @ISVISIBLE bit = 1
          )
          as
          set nocount on;

          if @ISVISIBLE = 1
            begin
                select
                    EDUCATIONALINVOLVEMENTTYPECODE as [TYPE],
                     NAME,
                     DATEFROM,
                     DATETO,
                     INSTITUTION,
                     EDUCATIONALINVOLVEMENTAWARDCODE as AWARD
                from
                    dbo.UFN_EDUCATIONALINVOLVEMENT_GETLIST() INVOLVEMENT
                where
                    INVOLVEMENT.CONSTITUENTID = @CONSTITUENTID;
            end