UFN_EDUCATIONALHISTORY_GETUNAFFILIATEDADDITIONALINFORMATION

Returns unaffiliated additional education information for a given educational history record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EDUCATIONALHISTORYID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_EDUCATIONALHISTORY_GETUNAFFILIATEDADDITIONALINFORMATION
(
    @EDUCATIONALHISTORYID uniqueidentifier
)
returns table
as
return
(
    select
        ID,
        EDUCATIONALCOLLEGECODEID,
        EDUCATIONALDIVISIONCODEID,
        EDUCATIONALDEPARTMENTCODEID,
        EDUCATIONALSUBDEPARTMENTCODEID,
        EDUCATIONALDEGREETYPECODEID
    from
        dbo.EDUCATIONADDITIONALINFORMATION
    where
        EDUCATIONALHISTORYID = @EDUCATIONALHISTORYID
)