V_QUERY_RATINGSBATCHEXCEPTIONREPORT

View used for output for Ratings Batch Exception Report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
IMPORTID	nvarchar(36)		Import ID
CONSTITUENTNAME	nvarchar(154)	yes	Constituent name

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  12/17/2008 2:13:08 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=1.7.1271.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RATINGSBATCHEXCEPTIONREPORT AS



            select 
                R.ID,
                R.IMPORTID,
                C.NAME CONSTITUENTNAME
            from 
                dbo.BATCHRATING R
                left outer join dbo.CONSTITUENT C on C.ID=R.IMPORTID