USP_DATALIST_EDUCATIONALHISTORY_ADDITIONALINFORMATION

            CREATE procedure dbo.USP_DATALIST_EDUCATIONALHISTORY_ADDITIONALINFORMATION(@EDUCATIONALHISTORYID uniqueidentifier)
            as
                set nocount on;

                declare @ISAFFILIATED bit;
                declare @USEACADEMICCATALOG bit;

                select
                    @ISAFFILIATED = INSTITUTION.ISAFFILIATED
                from
                    dbo.EDUCATIONALINSTITUTION INSTITUTION
                inner join dbo.EDUCATIONALHISTORY EDUCATION on INSTITUTION.ID = EDUCATION.EDUCATIONALINSTITUTIONID
                where
                    EDUCATION.ID = @EDUCATIONALHISTORYID;

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

                select 
                    ID,
                    case when ((@ISAFFILIATED = 1) and (@USEACADEMICCATALOG = 1)) then ADDITIONALINFORMATION.ACADEMICCATALOGCOLLEGE else ADDITIONALINFORMATION.EDUCATIONALCOLLEGECODE end 'COLLEGE',
                    case when ((@ISAFFILIATED = 1) and (@USEACADEMICCATALOG = 1)) then ADDITIONALINFORMATION.ACADEMICCATALOGDIVISION else ADDITIONALINFORMATION.EDUCATIONALDIVISIONCODE end 'DIVISION',
                    case when ((@ISAFFILIATED = 1) and (@USEACADEMICCATALOG = 1)) then ADDITIONALINFORMATION.ACADEMICCATALOGDEPARTMENT else ADDITIONALINFORMATION.EDUCATIONALDEPARTMENTCODE end 'DEPARTMENT',
                    case when ((@ISAFFILIATED = 1) and (@USEACADEMICCATALOG = 1)) then ADDITIONALINFORMATION.ACADEMICCATALOGSUBDEPARTMENT else ADDITIONALINFORMATION.EDUCATIONALSUBDEPARTMENTCODE end 'SUBDEPARTMENT',
                    case when ((@ISAFFILIATED = 1) and (@USEACADEMICCATALOG = 1)) then ADDITIONALINFORMATION.ACADEMICCATALOGDEGREETYPE else ADDITIONALINFORMATION.EDUCATIONALDEGREETYPECODE end 'DEGREETYPE'
                from 
                    dbo.UFN_EDUCATIONALHISTORY_GETADDITIONALINFORMATION(@EDUCATIONALHISTORYID) as ADDITIONALINFORMATION