V_QUERY_BBDW_PROSPECTFUNDINGINTEREST
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PROSPECTFUNDINGINTERESTDIMID | int | ||
| PROSPECTFUNDINGINTERESTSYSTEMID | uniqueidentifier | yes | |
| PROSPECTDIMID | int | yes | |
| FUNDINGTYPE | nvarchar(100) | yes | |
| INTERESTLEVEL | nvarchar(20) | yes | |
| COMMENT | nvarchar(max) | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_PROSPECTFUNDINGINTEREST] as
select
fi.[PROSPECTFUNDINGINTERESTDIMID],
fi.[PROSPECTFUNDINGINTERESTSYSTEMID],
fi.[CONSTITUENTDIMID] [PROSPECTDIMID],
fi.[FUNDINGTYPE],
fi.[INTERESTLEVEL],
fi.[COMMENT]
from BBDW.[DIM_PROSPECTFUNDINGINTEREST] fi
where [PROSPECTFUNDINGINTERESTDIMID] > 0