UFN_EDUCATIONALHISTORY_GETUNAFFILIATEDADDITIONALINFORMATION_FORUPDATEBATCH

This function returns the unaffiliated additional information for a given educational history for the update batch.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EDUCATIONALHISTORYID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_EDUCATIONALHISTORY_GETUNAFFILIATEDADDITIONALINFORMATION_FORUPDATEBATCH (
    @EDUCATIONALHISTORYID uniqueidentifier
) returns table
    as return
        select
            EAI.[ID] EDUCATIONADDITIONALINFORMATIONID,
            EAI.[EDUCATIONALCOLLEGECODEID] EDUCATIONALCOLLEGECODEID,
            EAI.[EDUCATIONALDIVISIONCODEID] EDUCATIONALDIVISIONCODEID,
            EAI.[EDUCATIONALDEPARTMENTCODEID] EDUCATIONALDEPARTMENTCODEID,
            EAI.[EDUCATIONALSUBDEPARTMENTCODEID] EDUCATIONALSUBDEPARTMENTCODEID,
            EAI.[EDUCATIONALDEGREETYPECODEID] EDUCATIONALDEGREETYPECODEID
        from
            dbo.[EDUCATIONADDITIONALINFORMATION] EAI
        where
            EAI.[EDUCATIONALHISTORYID] = @EDUCATIONALHISTORYID;