V_QUERY_BBDW_PROSPECTPLANPARTICIPANT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PLANPARTICIPANTDIMID | int | ||
| PLANPARTICIPANTSYSTEMID | uniqueidentifier | yes | |
| PROSPECTPLANDIMID | int | yes | |
| CONSTITUENTDIMID | int | yes | |
| PLANPARTICIPANTROLE | nvarchar(100) | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_PROSPECTPLANPARTICIPANT] as
select
pp.[PLANPARTICIPANTDIMID],
pp.[PLANPARTICIPANTSYSTEMID],
pp.[PROSPECTPLANDIMID],
pp.[CONSTITUENTDIMID],
pp.[PLANPARTICIPANTROLE]
from BBDW.[DIM_PLANPARTICIPANT] pp
where pp.[PLANPARTICIPANTDIMID] > 0