UFN_GIVINGLEVELPROGRAM_GETLEVELS

This function returns a giving level program's levels given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@GIVINGLEVELPROGRAMID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_GIVINGLEVELPROGRAM_GETLEVELS(@GIVINGLEVELPROGRAMID uniqueidentifier)
        returns table
        as return
            select
                ID,
                NAME,
                MINIMUMAMOUNT,
                SEQUENCE
            from
                dbo.GIVINGLEVELPROGRAMLEVEL
            where
                GIVINGLEVELPROGRAMID = @GIVINGLEVELPROGRAMID;