UFN_BATCHEDUCATIONALHISTORYUPDATE_GETEDUCATIONALINVOLVEMENTS

Returns all educational involvements for a given educational history update batch record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHEDUCATIONALHISTORYUPDATEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_BATCHEDUCATIONALHISTORYUPDATE_GETEDUCATIONALINVOLVEMENTS(
    @BATCHEDUCATIONALHISTORYUPDATEID uniqueidentifier
) returns table
as
return
(
    select
        ID,
        EDUCATIONALINVOLVEMENTID,
        EDUCATIONALINVOLVEMENTTYPECODEID,
        EDUCATIONALINVOLVEMENTNAMEID,
        DATEFROM,
        DATETO,
        EDUCATIONALINVOLVEMENTAWARDCODEID,
        COMMENT,
        POSITION
    from
        dbo.BATCHEDUCATIONALHISTORYUPDATEEDUCATIONALINVOLVEMENTS
    where
        BATCHEDUCATIONALHISTORYUPDATEID = @BATCHEDUCATIONALHISTORYUPDATEID
);