USP_BBNC_CONSTITEDUCATIONADDITIONALINFORMATIONDATA

CREATE procedure dbo.USP_BBNC_CONSTITEDUCATIONADDITIONALINFORMATIONDATA(@ID int)
as
begin

    select 
        EDUCATIONADDITIONALINFORMATION.ID,
        EDUCATIONADDITIONALINFORMATION.EDUCATIONALHISTORYID,

        dbo.UFN_ACADEMICCATALOGCOLLEGE_GETNAME(EDUCATIONADDITIONALINFORMATION.ACADEMICCATALOGCOLLEGEID) as ACADEMICCATALOGCOLLEGE,
        dbo.UFN_ACADEMICCATALOGDEGREETYPE_GETNAME(EDUCATIONADDITIONALINFORMATION.ACADEMICCATALOGDEGREETYPEID) as ACADEMICCATALOGDEGREETYPE, 
        dbo.UFN_ACADEMICCATALOGDEPARTMENT_GETNAME(EDUCATIONADDITIONALINFORMATION.ACADEMICCATALOGDEPARTMENTID) as ACADEMICCATALOGDEPARTMENT, 
        dbo.UFN_ACADEMICCATALOGDIVISION_GETNAME(EDUCATIONADDITIONALINFORMATION.ACADEMICCATALOGDIVISIONID) as ACADEMICCATALOGDIVISION, 
        dbo.UFN_ACADEMICCATALOGSUBDEPARTMENT_GETNAME(EDUCATIONADDITIONALINFORMATION.ACADEMICCATALOGSUBDEPARTMENTID) as ACADEMICCATALOGSUBDEPARTMENT,

        dbo.UFN_EDUCATIONALCOLLEGECODE_GETDESCRIPTION(EDUCATIONADDITIONALINFORMATION.EDUCATIONALCOLLEGECODEID) as EDUCATIONALCOLLEGE,
        dbo.UFN_EDUCATIONALDEGREETYPECODE_GETDESCRIPTION(EDUCATIONADDITIONALINFORMATION.EDUCATIONALDEGREETYPECODEID) as EDUCATIONALDEGREETYPE,
        dbo.UFN_EDUCATIONALDEPARTMENTCODE_GETDESCRIPTION(EDUCATIONADDITIONALINFORMATION.EDUCATIONALDEPARTMENTCODEID) as EDUCATIONALDEPARTMENT,
        dbo.UFN_EDUCATIONALDIVISIONCODE_GETDESCRIPTION(EDUCATIONADDITIONALINFORMATION.EDUCATIONALDIVISIONCODEID) as EDUCATIONALDIVISION,
        dbo.UFN_EDUCATIONALSUBDEPARTMENTCODE_GETDESCRIPTION(EDUCATIONADDITIONALINFORMATION.EDUCATIONALSUBDEPARTMENTCODEID) as EDUCATIONALSUBDEPARTMENT

    from
        dbo.CONSTITUENT
    inner join
        dbo.EDUCATIONALHISTORY on CONSTITUENT.ID = EDUCATIONALHISTORY.CONSTITUENTID
    inner join
        dbo.EDUCATIONADDITIONALINFORMATION on EDUCATIONADDITIONALINFORMATION.EDUCATIONALHISTORYID = EDUCATIONALHISTORY.ID
    where 
        CONSTITUENT.SEQUENCEID = @ID
    order by
        EDUCATIONADDITIONALINFORMATION.DATEADDED

end