UFN_PROSPECTRESEARCHREQUEST_OPENEVENTS

Returns a table containing IDs of all events with an open prospect research request.

Return

Return Type
table

Definition

Copy



            CREATE function dbo.UFN_PROSPECTRESEARCHREQUEST_OPENEVENTS()
            returns table
            as
            return
            (
                select
                    [PROSPECTRESEARCHREQUEST].[EVENTID] as ID
                from
                    [dbo].[PROSPECTRESEARCHREQUEST]
                where
                    [PROSPECTRESEARCHREQUEST].[STATUSCODE] in (0, 1, 2, 3)
            )