USP_DATALIST_EDUCATIONHISTORYAFFILIATED

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

                    declare @USEACADEMICCATALOG bit;
                    set @USEACADEMICCATALOG = (select top 1 coalesce(dbo.EDUCATIONALCONFIGURATION.USEACADEMICCATALOG,0) from dbo.EDUCATIONALCONFIGURATION);

                    select
                        HISTORY.ID,
                        INSTITUTION.NAME,
                        STATUS.DESCRIPTION 'EDCUATIONALHISTORYSTATUS',
                        case when (@USEACADEMICCATALOG = 1) then PROGRAM.PROGRAM else dbo.UFN_EDUCATIONALPROGRAMCODE_GETDESCRIPTION(HISTORY.EDUCATIONALPROGRAMCODEID) end 'PROGRAM',
                        case when (@USEACADEMICCATALOG = 1) then DEGREE.NAME else dbo.UFN_EDUCATIONALDEGREECODE_GETDESCRIPTION(HISTORY.EDUCATIONALDEGREECODEID) end 'DEGREE'
                    from
                        dbo.EDUCATIONALHISTORY as HISTORY    
                        inner join dbo.EDUCATIONALINSTITUTION as INSTITUTION on HISTORY.EDUCATIONALINSTITUTIONID = INSTITUTION.ID
                        inner join dbo.EDUCATIONALHISTORYSTATUS as STATUS on HISTORY.EDUCATIONALHISTORYSTATUSID = STATUS.ID
                        left join dbo.ACADEMICCATALOGPROGRAM as PROGRAM on HISTORY.ACADEMICCATALOGPROGRAMID = PROGRAM.ID
                        left join dbo.ACADEMICCATALOGDEGREE as DEGREE on HISTORY.ACADEMICCATALOGDEGREEID = DEGREE.ID
                    where
                        (HISTORY.CONSTITUENTID = @CONSTITUENTID) and
                        (INSTITUTION.ISAFFILIATED = 1)
                    order by
                        HISTORY.ISPRIMARYRECORD desc,
                        HISTORY.CLASSOF desc;