V_QUERY_TIMESHEET

This provides the ability to query timesheet fields.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
VOLUNTEERID	uniqueidentifier		Volunteer
JOBOCCURRENCEID	uniqueidentifier		Job occurrence
HOURSWORKED	decimal(20, 2)		Hours worked
STARTDATE	datetime		Start date
ENDDATE	datetime	yes	End date
NAME	nvarchar(100)	yes	Job name

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:35:33 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_TIMESHEET AS



                select
                    TIMESHEET.ID,
                    TIMESHEET.VOLUNTEERID,
                    TIMESHEET.JOBOCCURRENCEID,
                    TIMESHEET.HOURSWORKED,
                    TIMESHEET.STARTDATE,
                    TIMESHEET.ENDDATE,
                    JOB.NAME
                from dbo.TIMESHEET
                left join dbo.JOBOCCURRENCE on JOBOCCURRENCE.ID = TIMESHEET.JOBOCCURRENCEID
                left join dbo.JOB on JOB.ID = JOBOCCURRENCE.JOBID