UFN_PERFORMANCECATEGORYLEVELGRADE_GETGRADES

Returns the grades in a performance category level.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PERFORMANCECATEGORYLEVELID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_PERFORMANCECATEGORYLEVELGRADE_GETGRADES(
    @PERFORMANCECATEGORYLEVELID uniqueidentifier
)
returns table
--with execute as caller

as return(

    select 
        ID,
        GRADETYPECODE,
        TRANSLATIONTABLEID,
        LOWESTVALUENUMERIC,
        HIGHESTVALUENUMERIC,
        LOWESTVALUEGRADE,
        HIGHESTVALUEGRADE
    from 
        dbo.PERFORMANCECATEGORYLEVELGRADE
    where 
        PERFORMANCECATEGORYLEVELID = @PERFORMANCECATEGORYLEVELID
)