USP_DATALIST_EDUCATIONALHISTORY

                CREATE procedure dbo.USP_DATALIST_EDUCATIONALHISTORY (@CONSTITUENTID uniqueidentifier)
                as
                    set nocount on;

                    select 
                        HISTORY.ID,
                        case when isnull(PROGRAM.PROGRAM,'') = '' then 
                            dbo.UFN_EDUCATIONALPROGRAMCODE_GETDESCRIPTION(HISTORY.EDUCATIONALPROGRAMCODEID)
                        else
                            PROGRAM.PROGRAM
                        end as PROGRAM,
                        INSTITUTION.NAME,
                        case when isnull(DEGREE.NAME,'') = '' then
                            dbo.UFN_EDUCATIONALDEGREECODE_GETDESCRIPTION(HISTORY.EDUCATIONALDEGREECODEID)
                        else
                            DEGREE.NAME
                        end as DEGREE,
                        HISTORY.CLASSOF,
                        HISTORY.CONSTITUENCYSTATUS,
                        HISTORY.ISPRIMARYRECORD,
                        HISTORY.STARTDATE,
                        HISTORY.DATELEFT as ENDDATE,
                        case when INSTITUTION.ISAFFILIATED = 1 and HISTORY.STARTDATE <> '00000000' and HISTORY.DATELEFT = '00000000'
                            then 'Present'
                            else convert(varchar(10),dbo.UFN_DATE_FROMFUZZYDATE(HISTORY.DATELEFT),101)
                        end as ENDDATESTRING,
                        EDUCATIONSTATUS.DESCRIPTION as EDUCATIONHISTORYSTATUS,
                        INSTITUTION.ISAFFILIATED
                    from dbo.EDUCATIONALHISTORY as HISTORY    
                    inner join dbo.EDUCATIONALINSTITUTION as INSTITUTION on HISTORY.EDUCATIONALINSTITUTIONID = INSTITUTION.ID
                    left join dbo.ACADEMICCATALOGPROGRAM PROGRAM on HISTORY.ACADEMICCATALOGPROGRAMID = PROGRAM.ID
                    left join dbo.ACADEMICCATALOGDEGREE DEGREE on HISTORY.ACADEMICCATALOGDEGREEID = DEGREE.ID
                    inner join dbo.EDUCATIONALHISTORYSTATUS EDUCATIONSTATUS on HISTORY.EDUCATIONALHISTORYSTATUSID = EDUCATIONSTATUS.ID
                    where
                        HISTORY.CONSTITUENTID = @CONSTITUENTID
                    order by
                        HISTORY.ISPRIMARYRECORD desc;