V_QUERY_TIMESHEETBATCHEXCEPTIONREPORT

View used for output for Timesheet Batch Exception Report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
CONSTITUENTNAME	nvarchar(154)	yes	Constituent name
JOBOCCURRENCE	nvarchar(30)	yes	Job occurrence
HOURSWORKED	decimal(20, 2)		Hours worked
STARTDATE	datetime		Start date
ENDDATE	datetime	yes	End date
KEYNAME	nvarchar(100)		Key name
FIRSTNAME	nvarchar(50)		First name
MIDDLENAME	nvarchar(50)		Middle name

Definition

Copy

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



                select
                    BATCHTIMESHEET.ID,
                    dbo.UFN_CONSTITUENT_BUILDNAME(BATCHTIMESHEET.VOLUNTEERID) as [CONSTITUENTNAME],
                    dbo.UFN_JOBOCCURRENCE_GETDESCRIPTION(BATCHTIMESHEET.JOBOCCURRENCEID) as [JOBOCCURRENCE],
                    BATCHTIMESHEET.HOURSWORKED,
                    BATCHTIMESHEET.STARTDATE,
                    BATCHTIMESHEET.ENDDATE,
                    CONSTITUENT.KEYNAME,
                    CONSTITUENT.FIRSTNAME,
                    CONSTITUENT.MIDDLENAME
                from dbo.BATCHTIMESHEET
                inner join dbo.CONSTITUENT on CONSTITUENT.ID = BATCHTIMESHEET.VOLUNTEERID