v_DIM_PROSPECTFUNDINGINTEREST
Contains information about prospect funding interests.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PROSPECTFUNDINGINTERESTDIMID | int | BBDW.[DIM_PROSPECTFUNDINGINTEREST].[PROSPECTFUNDINGINTERESTDIMID] | |
| PROSPECTFUNDINGINTERESTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PROSPECTFUNDINGINTEREST].[PROSPECTFUNDINGINTERESTSYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[DIM_PROSPECTFUNDINGINTEREST].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PROSPECTFUNDINGINTEREST].[CONSTITUENTSYSTEMID] |
| FUNDINGTYPE | nvarchar(100) | yes | BBDW.[DIM_PROSPECTFUNDINGINTEREST].[FUNDINGTYPE] |
| INTERESTLEVEL | nvarchar(20) | yes | BBDW.[DIM_PROSPECTFUNDINGINTEREST].[INTERESTLEVEL] |
| COMMENT | nvarchar(max) | yes | BBDW.[DIM_PROSPECTFUNDINGINTEREST].[COMMENT] |
Definition
Copy
create view [BBDW].[v_DIM_PROSPECTFUNDINGINTEREST] as
select
[PROSPECTFUNDINGINTERESTDIMID],
[PROSPECTFUNDINGINTERESTSYSTEMID],
[CONSTITUENTDIMID],
[CONSTITUENTSYSTEMID],
[FUNDINGTYPE],
[INTERESTLEVEL],
[COMMENT]
from [BBDW].[DIM_PROSPECTFUNDINGINTEREST];