USP_DATALIST_CONSTITUENTPROFILEDASHBOARDEDUCATIONALHISTORY

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

                        if @ISVISIBLE = 1
                        begin
                            declare @USEACADEMICCATALOG bit;                        
                            select top 1
                                @USEACADEMICCATALOG = EC.USEACADEMICCATALOG
                            from
                                dbo.EDUCATIONALCONFIGURATION EC;

                            set @USEACADEMICCATALOG = coalesce(@USEACADEMICCATALOG,0);

                            select
                                INSTITUTION.NAME,
                                HISTORY.ISPRIMARYRECORD,
                                case when @USEACADEMICCATALOG = 1 and INSTITUTION.ISAFFILIATED = 1 then ACADEMICCATALOGPROGRAM.PROGRAM else dbo.UFN_EDUCATIONALPROGRAMCODE_GETDESCRIPTION(HISTORY.EDUCATIONALPROGRAMCODEID) end as PROGRAM,
                                EDUCATIONALHISTORYSTATUS.DESCRIPTION as CONSTITUENCYSTATUS,
                                HISTORY.CONSTITUENCYSTATUSCODE as CONSTITUENCYSTATUSCODE,
                                case when @USEACADEMICCATALOG = 1 and INSTITUTION.ISAFFILIATED = 1 then ACADEMICCATALOGDEGREE.NAME else dbo.UFN_EDUCATIONALDEGREECODE_GETDESCRIPTION(HISTORY.EDUCATIONALDEGREECODEID) end as DEGREE,
                                HISTORY.STARTDATE,
                                case HISTORY.CONSTITUENCYSTATUSCODE 
                                    when 2 then HISTORY.DATELEFT
                                    when 3 then HISTORY.DATEGRADUATED
                                    else null
                                end as ENDDATE,
                                dbo.UFN_EDUCATIONALHISTORYLEVELCODE_GETDESCRIPTION(HISTORY.EDUCATIONALHISTORYLEVELCODEID) as EDUCATIONALHISTORYLEVELCODE,
                                case when HISTORY.CLASSOF = 0 then '' else cast(HISTORY.CLASSOF as nvarchar(4))    end as CLASSOF,
                                case when HISTORY.PREFERREDCLASSYEAR = 0 then '' else CAST(HISTORY.PREFERREDCLASSYEAR as nvarchar(4)) end as PREFERREDCLASSYEAR,
                                dbo.UFN_EDUCATIONALAWARDCODE_GETDESCRIPTION(HISTORY.EDUCATIONALAWARDCODEID) as EDUCATIONALAWARD,
                                dbo.UFN_EDUCATIONALSOURCECODE_GETDESCRIPTION(HISTORY.EDUCATIONALSOURCECODEID) as EDUCATIONALSOURCE,
                                HISTORY.EDUCATIONALSOURCEDATE,
                                HISTORY.COMMENT,
                                dbo.UFN_EDUCATIONALHISTORY_ADDITIONALINFORMATIONLIST(HISTORY.ID) as ADDITIONALINFORMATION
                            from
                                dbo.EDUCATIONALHISTORY as HISTORY
                            inner join dbo.EDUCATIONALINSTITUTION as INSTITUTION on HISTORY.EDUCATIONALINSTITUTIONID = INSTITUTION.ID
                            inner join dbo.EDUCATIONALHISTORYSTATUS on HISTORY.EDUCATIONALHISTORYSTATUSID = EDUCATIONALHISTORYSTATUS.ID
                            left join dbo.ACADEMICCATALOGPROGRAM on HISTORY.ACADEMICCATALOGPROGRAMID = ACADEMICCATALOGPROGRAM.ID
                            left join dbo.ACADEMICCATALOGDEGREE on HISTORY.ACADEMICCATALOGDEGREEID = ACADEMICCATALOGDEGREE.ID
                            where
                                HISTORY.CONSTITUENTID = @CONSTITUENTID
                            order by
                                HISTORY.ISPRIMARYRECORD desc, HISTORY.CLASSOF desc;
                        end