V_QUERY_BBDW_SPONSORSHIPOPPORTUNITYPROJECT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SPONSORSHIPOPPORTUNITYPROJECTDIMID | int | ||
| SPONSORSHIPOPPORTUNITYPROJECTSYSTEMID | uniqueidentifier | yes | |
| SPONSORSHIPOPPORTUNITYPROJECTNAME | nvarchar(100) | yes | |
| SPONSORSHIPOPPORTUNITYPROJECTDESCRIPTION | nvarchar(255) | yes | |
| STARTDATEDIMID | int | yes | |
| STARTDATE | datetime | yes | |
| ENDDATEDIMID | int | yes | |
| ENDDATE | datetime | yes | |
| SPONSORSHIPGOAL | money | yes | |
| SPONSORSHIPOPPORTUNITYPROJECTSTATUS | nvarchar(115) | yes | |
| SPONSORSHIPREASON | nvarchar(100) | yes | |
| SPONSORSHIPOPPORTUNITYPROJECTCATEGORY | nvarchar(100) | yes | |
| DESIGNATIONDIMID | int | yes | |
| SPONSORGOAL | int | yes | |
| CURRENCYSYSTEMID | uniqueidentifier | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_SPONSORSHIPOPPORTUNITYPROJECT] as
select
sop.[SPONSORSHIPOPPORTUNITYPROJECTDIMID],
sop.[SPONSORSHIPOPPORTUNITYPROJECTSYSTEMID],
sop.[SPONSORSHIPOPPORTUNITYPROJECTNAME],
sop.[SPONSORSHIPOPPORTUNITYPROJECTDESCRIPTION],
sop.[STARTDATEDIMID],
sop.[STARTDATE],
sop.[ENDDATEDIMID],
sop.[ENDDATE],
sop.[SPONSORSHIPGOAL],
sop.[SPONSORSHIPOPPORTUNITYPROJECTSTATUS],
sr.[SPONSORSHIPREASON],
sop.[SPONSORSHIPOPPORTUNITYPROJECTCATEGORY],
sop.[DESIGNATIONDIMID],
sop.[SPONSORGOAL],
c.[CURRENCYSYSTEMID]
from [BBDW].[DIM_SPONSORSHIPOPPORTUNITYPROJECT] sop
left join [BBDW].[DIM_SPONSORSHIPREASON] sr on sop.[CLOSEDSPONSORSHIPREASONDIMID] = sr.[SPONSORSHIPREASONDIMID] and sop.[CLOSEDSPONSORSHIPREASONDIMID] <> 0
outer apply BBDW.[DIM_CURRENCY] c
where c.[ISORGANIZATIONCURRENCY] = 1 and sop.[SPONSORSHIPOPPORTUNITYPROJECTDIMID] > 0