UFN_EDUCATIONALHISTORY_GETADDITIONALINFORMATION

            CREATE function dbo.UFN_EDUCATIONALHISTORY_GETADDITIONALINFORMATION
            (
                @EDUCATIONALHISTORYID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    ADDITIONALINFORMATION.ID,
                    ACADEMICCATALOGCOLLEGE.NAME as ACADEMICCATALOGCOLLEGE,
                    ACADEMICCATALOGDIVISION.NAME as ACADEMICCATALOGDIVISION,
                    ACADEMICCATALOGDEPARTMENT.NAME as ACADEMICCATALOGDEPARTMENT,
                    ACADEMICCATALOGSUBDEPARTMENT.NAME as ACADEMICCATALOGSUBDEPARTMENT,
                    dbo.UFN_ACADEMICCATALOGDEGREETYPECODE_GETDESCRIPTION(ACADEMICCATALOGDEGREETYPE.ACADEMICCATALOGDEGREETYPECODEID) as ACADEMICCATALOGDEGREETYPE,
                    dbo.UFN_EDUCATIONALCOLLEGECODE_GETDESCRIPTION(ADDITIONALINFORMATION.EDUCATIONALCOLLEGECODEID) as EDUCATIONALCOLLEGECODE,
                    dbo.UFN_EDUCATIONALDIVISIONCODE_GETDESCRIPTION(ADDITIONALINFORMATION.EDUCATIONALDIVISIONCODEID) as EDUCATIONALDIVISIONCODE,
                    dbo.UFN_EDUCATIONALDEPARTMENTCODE_GETDESCRIPTION(ADDITIONALINFORMATION.EDUCATIONALDEPARTMENTCODEID) as EDUCATIONALDEPARTMENTCODE,
                    dbo.UFN_EDUCATIONALSUBDEPARTMENTCODE_GETDESCRIPTION(ADDITIONALINFORMATION.EDUCATIONALSUBDEPARTMENTCODEID) as EDUCATIONALSUBDEPARTMENTCODE,
                    dbo.UFN_EDUCATIONALDEGREETYPECODE_GETDESCRIPTION(ADDITIONALINFORMATION.EDUCATIONALDEGREETYPECODEID) as EDUCATIONALDEGREETYPECODE
                from
                    dbo.EDUCATIONADDITIONALINFORMATION as ADDITIONALINFORMATION
                left join dbo.ACADEMICCATALOGCOLLEGE on ADDITIONALINFORMATION.ACADEMICCATALOGCOLLEGEID = ACADEMICCATALOGCOLLEGE.ID
                left join dbo.ACADEMICCATALOGDIVISION on ADDITIONALINFORMATION.ACADEMICCATALOGDIVISIONID = ACADEMICCATALOGDIVISION.ID
                left join dbo.ACADEMICCATALOGDEPARTMENT on ADDITIONALINFORMATION.ACADEMICCATALOGDEPARTMENTID = ACADEMICCATALOGDEPARTMENT.ID
                left join dbo.ACADEMICCATALOGSUBDEPARTMENT on ADDITIONALINFORMATION.ACADEMICCATALOGSUBDEPARTMENTID = ACADEMICCATALOGSUBDEPARTMENT.ID
                left join dbo.ACADEMICCATALOGDEGREETYPE on ADDITIONALINFORMATION.ACADEMICCATALOGDEGREETYPEID = ACADEMICCATALOGDEGREETYPE.ID
                where
                    EDUCATIONALHISTORYID = @EDUCATIONALHISTORYID
            )