USP_DATALIST_CONSTITUENTPROFILE_EDUCATIONALINVOLVEMENTS

CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILE_EDUCATIONALINVOLVEMENTS
(
    @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