UFN_EVENTMANAGEMENTTEMPLATE_GETLEVELS

Returns all levels for a given event management template.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTMANAGEMENTTEMPLATEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_EVENTMANAGEMENTTEMPLATE_GETLEVELS
            (
                @EVENTMANAGEMENTTEMPLATEID uniqueidentifier
            )
            returns table
            as
            return
            (
                select 
                    ID, 
                    NAME,
                    LEVEL,
                    HASREGISTRANTSANDOPTIONS,
                    HASSPEAKERS,
                    HASEXPENSES,
                    HASINVITATIONS,
                    HASDOCUMENTATION,
                    HASTASKSANDCOORDINATORS,
                    HASLODGINGOPTIONS,
                    HASJOBOCCURRENCES,
                    HASAPPEALS,
                    HASCAMPAIGNS
                from 
                    dbo.EVENTMANAGEMENTLEVELTEMPLATE
                where 
                    EVENTMANAGEMENTTEMPLATEID = @EVENTMANAGEMENTTEMPLATEID
            )