V_QUERY_BBDW_PLANNEDGIFT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PLANNEDGIFTDIMID | int | ||
| PLANNEDGIFTSYSTEMID | uniqueidentifier | yes | |
| CONSTITUENTDIMID | int | yes | |
| FINANCIALTRANSACTIONFACTID | int | yes | |
| SUBTYPE | nvarchar(100) | yes | |
| OTHERSUBTYPE | nvarchar(100) | yes | |
| VEHICLE | nvarchar(50) | yes | |
| STATUS | nvarchar(25) | yes | |
| EXPECTEDMATURITY | int | yes | |
| ISREVOCABLE | bit | yes | |
| ISANONYMOUS | bit | yes | |
| ISLIVINGTRUST | bit | yes | |
| GIFTISCONTINGENT | bit | yes | |
| GIFTVALUEISNOMINAL | bit | yes | |
| TOTALGIFTAMOUNT | money | yes | |
| ORIGINALGIFTAMOUNT | money | yes | |
| ORIGINALGIFTDATE | datetime | yes | |
| ORIGINALGIFTDATEDIMID | int | yes | |
| RECOGNITIONAMOUNT | money | yes | |
| NETPRESENTVALUE | money | yes | |
| REALIZEDAMOUNT | money | yes | |
| REMAINDERMANPERCENT | decimal(6, 5) | yes | |
| REMAINDERVALUE | money | yes | |
| REMAINDERVALUEDATE | datetime | yes | |
| REMAINDERVALUEDATEDIMID | int | yes | |
| PROBATESTATUS | nvarchar(50) | yes | |
| PROBATEDATE | datetime | yes | |
| PROBATEDATEDIMID | int | yes | |
| CURRENCYSYSTEMID | uniqueidentifier | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_PLANNEDGIFT] as
select
pg.[PLANNEDGIFTDIMID],
pg.[PLANNEDGIFTSYSTEMID],
pg.[CONSTITUENTDIMID],
pg.[FINANCIALTRANSACTIONFACTID],
pg.[SUBTYPE],
pg.[SUBTYPE] as [OTHERSUBTYPE],
pg.[VEHICLE],
pg.[STATUS],
pg.[EXPECTEDMATURITY],
pg.[ISREVOCABLE],
pg.[ISANONYMOUS],
pg.[ISLIVINGTRUST],
pg.[GIFTISCONTINGENT],
pg.[GIFTVALUEISNOMINAL],
pg.[TOTALGIFTAMOUNT],
pg.[ORIGINALGIFTAMOUNT],
pg.[ORIGINALGIFTDATE],
pg.[ORIGINALGIFTDATEDIMID],
pg.[RECOGNITIONAMOUNT],
pg.[NETPRESENTVALUE],
pg.[REALIZEDAMOUNT],
pg.[REMAINDERMANPERCENT],
pg.[REMAINDERVALUE],
pg.[REMAINDERVALUEDATE],
pg.[REMAINDERVALUEDATEDIMID],
pg.[PROBATESTATUS],
pg.[PROBATEDATE],
pg.[PROBATEDATEDIMID],
c.[CURRENCYSYSTEMID]
from BBDW.[DIM_PLANNEDGIFT] pg
outer apply BBDW.[DIM_CURRENCY] c
where c.[ISORGANIZATIONCURRENCY] = 1