UFN_PERFORMANCECATEGORYLEVELSKILLCATEGORY_GETRATINGS

Returns the ratings defined for a Performance Category Level Skill Category

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PERFORMANCECATEGORYLEVELSKILLCATEGORYID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_PERFORMANCECATEGORYLEVELSKILLCATEGORY_GETRATINGS(
    @PERFORMANCECATEGORYLEVELSKILLCATEGORYID uniqueidentifier
)
returns table
as return(

    select
        ID,
        STUDENTSKILLRATINGGROUPID,
        LOWESTSTUDENTSKILLRATINGID,
        HIGHESTSTUDENTSKILLRATINGID
    from dbo.PERFORMANCECATEGORYLEVELSKILLCATEGORYRATING
    where
        PERFORMANCECATEGORYLEVELSKILLCATEGORYID = @PERFORMANCECATEGORYLEVELSKILLCATEGORYID 
)