UFN_EDUCATIONALHISTORY_GETAFFILIATEDADDITIONALINFORMATION_FORUPDATEBATCH

This function returns the affiliated 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_GETAFFILIATEDADDITIONALINFORMATION_FORUPDATEBATCH (
    @EDUCATIONALHISTORYID uniqueidentifier
) returns table
    as return
        select
            EAI.[ID] EDUCATIONADDITIONALINFORMATIONID,
            EAI.[ACADEMICCATALOGCOLLEGEID] ACADEMICCATALOGCOLLEGEID,
            EAI.[ACADEMICCATALOGDIVISIONID] ACADEMICCATALOGDIVISIONID,
            EAI.[ACADEMICCATALOGDEPARTMENTID] ACADEMICCATALOGDEPARTMENTID,
            EAI.[ACADEMICCATALOGSUBDEPARTMENTID] ACADEMICCATALOGSUBDEPARTMENTID,
            EAI.[ACADEMICCATALOGDEGREETYPEID] ACADEMICCATALOGDEGREETYPEID
        from
            dbo.[EDUCATIONADDITIONALINFORMATION] EAI
        where
            EAI.[EDUCATIONALHISTORYID] = @EDUCATIONALHISTORYID;