UFN_EDUCATIONALHISTORY_GETMAJOR

Returns educational major history for a given constituent.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EDUCATIONALHISTORYID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EDUCATIONALHISTORY_GETMAJOR(
                @EDUCATIONALHISTORYID uniqueidentifier
            )
            returns table
            as
            return (
                select
                    ID,
                    EDUCATIONALMAJORCODEID,
                    COMMENT
                from
                    dbo.EDUCATIONALMAJOR
                where
                    EDUCATIONALHISTORYID = @EDUCATIONALHISTORYID
            )