V_QUERY_PDACCOUNTSEGMENTMAPPINGBATCHEXCEPTIONREPORT2
View used for output for Account Segment Mapping Batch Exception Report by Account System.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| ACCOUNTSYSTEM | nvarchar(50) | Account System | |
| 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:36:00 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PDACCOUNTSEGMENTMAPPINGBATCHEXCEPTIONREPORT2 AS
select
T1.ID,
T4.NAME as ACCOUNTSYSTEM,
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
inner join dbo.PDACCOUNTSYSTEM T4 on T2.PDACCOUNTSYSTEMID = T4.ID