UFN_MARKINGCOLUMN_GETTERMS

Get the terms associated with a marking column record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@MARKINGCOLUMNID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_MARKINGCOLUMN_GETTERMS(
    @MARKINGCOLUMNID uniqueidentifier
)
returns table
as return
    (select 
        MARKINGCOLUMNTERM.ID, 
        MARKINGCOLUMNTERM.TERMNAMECODEID,
        case when GRADEASSOCIATIONS.MARKINGCOLUMNTERMID is not null then 1 else 0 end 'HASGRADEASSOCIATION',
        GRADEASSOCIATIONS.ENROLLEDINOTHERTERMS
    from 
        dbo.MARKINGCOLUMNTERM
    left outer join dbo.UFN_MARKINGCOLUMN_GETGRADEDTERMS(null) GRADEASSOCIATIONS 
        on MARKINGCOLUMNTERM.ID = GRADEASSOCIATIONS.MARKINGCOLUMNTERMID       
    where 
        MARKINGCOLUMNTERM.MARKINGCOLUMNID = @MARKINGCOLUMNID
)