UFN_CONSTITUENT_MAPFROM_TIMESHEET

Maps a timesheet to the constituent who owns it.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@TIMESHEETID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENT_MAPFROM_TIMESHEET
            (
                @TIMESHEETID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @CONSTITUENTID uniqueidentifier;
                select @CONSTITUENTID = VOLUNTEERID from dbo.TIMESHEET where ID = @TIMESHEETID;
                return @CONSTITUENTID;
            end