v_DIM_PLANNEDGIFT
Stores information about planned gifts.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PLANNEDGIFTDIMID | int | BBDW.[DIM_PLANNEDGIFT].[PLANNEDGIFTDIMID] | |
| PLANNEDGIFTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PLANNEDGIFT].[PLANNEDGIFTSYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[DIM_PLANNEDGIFT].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PLANNEDGIFT].[CONSTITUENTSYSTEMID] |
| FINANCIALTRANSACTIONFACTID | int | yes | BBDW.[DIM_PLANNEDGIFT].[FINANCIALTRANSACTIONFACTID] |
| FINANCIALTRANSACTIONSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PLANNEDGIFT].[FINANCIALTRANSACTIONSYSTEMID] |
| PROSPECTPLANDIMID | int | yes | BBDW.[DIM_PLANNEDGIFT].[PROSPECTPLANDIMID] |
| SUBTYPE | nvarchar(100) | yes | BBDW.[DIM_PLANNEDGIFT].[SUBTYPE] |
| VEHICLE | nvarchar(50) | yes | BBDW.[DIM_PLANNEDGIFT].[VEHICLE] |
| STATUS | nvarchar(25) | yes | BBDW.[DIM_PLANNEDGIFT].[STATUS] |
| EXPECTEDMATURITY | int | yes | BBDW.[DIM_PLANNEDGIFT].[EXPECTEDMATURITY] |
| ISREVOCABLE | bit | yes | BBDW.[DIM_PLANNEDGIFT].[ISREVOCABLE] |
| ISANONYMOUS | bit | yes | BBDW.[DIM_PLANNEDGIFT].[ISANONYMOUS] |
| ISLIVINGTRUST | bit | yes | BBDW.[DIM_PLANNEDGIFT].[ISLIVINGTRUST] |
| GIFTISCONTINGENT | bit | yes | BBDW.[DIM_PLANNEDGIFT].[GIFTISCONTINGENT] |
| GIFTVALUEISNOMINAL | bit | yes | BBDW.[DIM_PLANNEDGIFT].[GIFTVALUEISNOMINAL] |
| TOTALGIFTAMOUNT | money | yes | BBDW.[DIM_PLANNEDGIFT].[TOTALGIFTAMOUNT] |
| ORIGINALGIFTAMOUNT | money | yes | BBDW.[DIM_PLANNEDGIFT].[ORIGINALGIFTAMOUNT] |
| ORIGINALGIFTDATEDIMID | int | yes | BBDW.[DIM_PLANNEDGIFT].[ORIGINALGIFTDATEDIMID] |
| ORIGINALGIFTDATE | datetime | yes | BBDW.[DIM_PLANNEDGIFT].[ORIGINALGIFTDATE] |
| RECOGNITIONAMOUNT | money | yes | BBDW.[DIM_PLANNEDGIFT].[RECOGNITIONAMOUNT] |
| NETPRESENTVALUE | money | yes | BBDW.[DIM_PLANNEDGIFT].[NETPRESENTVALUE] |
| REALIZEDAMOUNT | money | yes | BBDW.[DIM_PLANNEDGIFT].[REALIZEDAMOUNT] |
| AUTOCALCULATEREALIZEDAMOUNT | bit | yes | BBDW.[DIM_PLANNEDGIFT].[AUTOCALCULATEREALIZEDAMOUNT] |
| REMAINDERMANPERCENT | decimal(6, 5) | yes | BBDW.[DIM_PLANNEDGIFT].[REMAINDERMANPERCENT] |
| REMAINDERVALUE | money | yes | BBDW.[DIM_PLANNEDGIFT].[REMAINDERVALUE] |
| REMAINDERVALUEDATEDIMID | int | yes | BBDW.[DIM_PLANNEDGIFT].[REMAINDERVALUEDATEDIMID] |
| REMAINDERVALUEDATE | datetime | yes | BBDW.[DIM_PLANNEDGIFT].[REMAINDERVALUEDATE] |
| PROBATESTATUS | nvarchar(50) | yes | BBDW.[DIM_PLANNEDGIFT].[PROBATESTATUS] |
| PROBATEDATEDIMID | int | yes | BBDW.[DIM_PLANNEDGIFT].[PROBATEDATEDIMID] |
| PROBATEDATE | datetime | yes | BBDW.[DIM_PLANNEDGIFT].[PROBATEDATE] |
Definition
Copy
create view [BBDW].[v_DIM_PLANNEDGIFT] as
select
[PLANNEDGIFTDIMID],
[PLANNEDGIFTSYSTEMID],
[CONSTITUENTDIMID],
[CONSTITUENTSYSTEMID],
[FINANCIALTRANSACTIONFACTID],
[FINANCIALTRANSACTIONSYSTEMID],
[PROSPECTPLANDIMID],
[SUBTYPE],
[VEHICLE],
[STATUS],
[EXPECTEDMATURITY],
[ISREVOCABLE],
[ISANONYMOUS],
[ISLIVINGTRUST],
[GIFTISCONTINGENT],
[GIFTVALUEISNOMINAL],
[TOTALGIFTAMOUNT],
[ORIGINALGIFTAMOUNT],
[ORIGINALGIFTDATEDIMID],
[ORIGINALGIFTDATE],
[RECOGNITIONAMOUNT],
[NETPRESENTVALUE],
[REALIZEDAMOUNT],
[AUTOCALCULATEREALIZEDAMOUNT],
[REMAINDERMANPERCENT],
[REMAINDERVALUE],
[REMAINDERVALUEDATEDIMID],
[REMAINDERVALUEDATE],
[PROBATESTATUS],
[PROBATEDATEDIMID],
[PROBATEDATE]
from [BBDW].[DIM_PLANNEDGIFT];