V_QUERY_PDACCOUNTSEGMENTMAPPINGBATCHEXCEPTIONREPORT
View used for output for Account Segment Mapping Batch Exception Report.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| SEGMENTTYPE | nvarchar(100) | Segment type | |
| SEGMENTNAME | nvarchar(512) | yes | Segment name |
| SEGMENTVALUE | nvarchar(100) | Segment value |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:35:54 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PDACCOUNTSEGMENTMAPPINGBATCHEXCEPTIONREPORT AS
select
T1.ID,
T2.DESCRIPTION as SEGMENTTYPE,
LONGDESCRIPTION as SEGMENTNAME,
T3.SHORTDESCRIPTION as SEGMENTVALUE
from dbo.BATCHPDACCOUNTSEGMENTMAPPING T1
inner join dbo.PDACCOUNTSTRUCTURE T2 on T1.PDACCOUNTSTRUCTUREID = T2.ID
inner join dbo.PDACCOUNTSEGMENTVALUE T3 on T1.PDACCOUNTSEGMENTVALUEID = T3.ID