UFN_BATCHEDUCATIONALHISTORYUPDATE_GETAFFILIATEDADDITIONALINFORMATION

Returns all affiliated additional information for a given educational history update batch record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHEDUCATIONALHISTORYUPDATEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_BATCHEDUCATIONALHISTORYUPDATE_GETAFFILIATEDADDITIONALINFORMATION(
    @BATCHEDUCATIONALHISTORYUPDATEID uniqueidentifier
) returns table
as
return
(
    select
        ID,
        EDUCATIONADDITIONALINFORMATIONID,
        ACADEMICCATALOGCOLLEGEID,
        ACADEMICCATALOGDIVISIONID,
        ACADEMICCATALOGDEPARTMENTID,
        ACADEMICCATALOGSUBDEPARTMENTID,
        ACADEMICCATALOGDEGREETYPEID
    from
        dbo.BATCHEDUCATIONALHISTORYUPDATEAFFILIATEDADDITIONALINFORMATION
    where
        BATCHEDUCATIONALHISTORYUPDATEID = @BATCHEDUCATIONALHISTORYUPDATEID
);