V_QUERY_RE7_CONSTITUENTACTION

Fields

Field	Field Type	Null
LOCALID	int
CONSTITUENT_LOCALID	int	yes
DATE_DATEID	int	yes
CATEGORY_LOCALID	int
ACTIONCATEGORY	nvarchar(30)	yes
PRIORITY_LOCALID	int
ACTIONPRIORITY	nvarchar(30)	yes
ACTIONCOMPLETEDFLAG	bit
COMPLETEDDATE_DATEID	int	yes
CONTACT_LOCALID	int	yes
DATECHANGED_DATEID	int	yes
STATUS_LOCALID	int	yes
TYPE_LOCALID	int	yes
ACTIONSTATUSLONGDESCRIPTION	nvarchar(100)	yes
ACTIONTYPECODELONGDESCRIPTION	nvarchar(100)	yes
LOCATION_LOCALID	int	yes
ACTIONLOCATION	nvarchar(100)	yes
APPEAL_LOCALID	int	yes
CAMPAIGN_LOCALID	int	yes
FUND_LOCALID	int	yes
IMPORTID	nvarchar(20)	yes
PROPOSAL_LOCALID	int	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  2/6/2025 8:50:24 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RE7_CONSTITUENTACTION AS




select 
  [A].[LOCALID],
  [A].[CONSTITUENT_LOCALID],
  [A].[DATE_DATEID],
  [A].[CATEGORY_LOCALID],
  [AC].[DESCRIPTION] [ACTIONCATEGORY],
  [A].[PRIORITY_LOCALID],
  [AP].[DESCRIPTION] [ACTIONPRIORITY],
  [A].[COMPLETED] [ACTIONCOMPLETEDFLAG],
  [A].[COMPLETEDDATE_DATEID],
  [A].[CONTACT_LOCALID],
  [A].[DATECHANGED_DATEID],
  [A].[STATUS_LOCALID],
  [A].[TYPE_LOCALID],
  [AST].[DESCRIPTION] [ACTIONSTATUSLONGDESCRIPTION],
  [AT].[DESCRIPTION] [ACTIONTYPECODELONGDESCRIPTION],
  [A].[LOCATION_LOCALID],
  [AL].[DESCRIPTION] [ACTIONLOCATION],
  [A].[APPEAL_LOCALID],
  [A].[CAMPAIGN_LOCALID],
  [A].[FUND_LOCALID],
  [A].[IMPORTID],
  [A].[PROPOSAL_LOCALID]
from [dbo].[RE7_ACTION] [A]
left outer join [dbo].[RE7_ACTIONCATEGORYCODE] [AC] on [A].[CATEGORY_LOCALID] = [AC].[LOCALID]
left outer join [dbo].[RE7_ACTIONPRIORITYCODE] [AP] on [A].[PRIORITY_LOCALID] = [AP].[LOCALID]
left outer join [dbo].[RE7_ACTIONSTATUSCODE] [AST] on [A].[STATUS_LOCALID] = [AST].[LOCALID]
left outer join [dbo].[RE7_ACTIONTYPECODE] [AT] on [A].[TYPE_LOCALID] = [AT].[LOCALID]
left outer join [dbo].[RE7_DATEDIMENSION] [AD] on [A].[DATE_DATEID] = [AD].[DATEID]
left outer join [dbo].[RE7_ACTIONLOCATIONCODE] [AL] on [A].[LOCATION_LOCALID] = [AL].[LOCALID];