UFN_BATCHEDUCATIONALHISTORYUPDATE_GETUNAFFILIATEDADDITIONALINFORMATION

Returns all unaffiliated 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_GETUNAFFILIATEDADDITIONALINFORMATION(
    @BATCHEDUCATIONALHISTORYUPDATEID uniqueidentifier
) returns table
as
return
(
    select
        ID,
        EDUCATIONADDITIONALINFORMATIONID,
        EDUCATIONALCOLLEGECODEID,
        EDUCATIONALDIVISIONCODEID,
        EDUCATIONALDEPARTMENTCODEID,
        EDUCATIONALSUBDEPARTMENTCODEID,
        EDUCATIONALDEGREETYPECODEID
    from
        dbo.BATCHEDUCATIONALHISTORYUPDATEUNAFFILIATEDADDITIONALINFORMATION
    where
        BATCHEDUCATIONALHISTORYUPDATEID = @BATCHEDUCATIONALHISTORYUPDATEID
);