UFN_CONSTITUENTBATCH_GETEDUCATIONUNAFFILIATEDADDITIONALINFORMATION

Returns unaffiliated additional education information for a given constituent batch.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHCONSTITUENTID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_CONSTITUENTBATCH_GETEDUCATIONUNAFFILIATEDADDITIONALINFORMATION
(
    @BATCHCONSTITUENTID uniqueidentifier
)
returns table
as
return
(
    select
        ID,
        EDUCATIONALCOLLEGECODEID,
        EDUCATIONALDIVISIONCODEID,
        EDUCATIONALDEPARTMENTCODEID,
        EDUCATIONALSUBDEPARTMENTCODEID,
        EDUCATIONALDEGREETYPECODEID
    from dbo.BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION
    where
        BATCHCONSTITUENTID = @BATCHCONSTITUENTID
)