v_DIM_PLANPARTICIPANT
Contains information on plan participants.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PLANPARTICIPANTDIMID | int | BBDW.[DIM_PLANPARTICIPANT].[PLANPARTICIPANTDIMID] | |
| PLANPARTICIPANTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PLANPARTICIPANT].[PLANPARTICIPANTSYSTEMID] |
| PROSPECTPLANDIMID | int | yes | BBDW.[DIM_PLANPARTICIPANT].[PROSPECTPLANDIMID] |
| PROSPECTPLANCONSTITUENTDIMID | int | yes | BBDW.[DIM_PLANPARTICIPANT].[PROSPECTPLANCONSTITUENTDIMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[DIM_PLANPARTICIPANT].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PLANPARTICIPANT].[CONSTITUENTSYSTEMID] |
| PLANPARTICIPANTROLE | nvarchar(100) | yes | BBDW.[DIM_PLANPARTICIPANT].[PLANPARTICIPANTROLE] |
Definition
Copy
create view [BBDW].[v_DIM_PLANPARTICIPANT] as
select
[PLANPARTICIPANTDIMID],
[PLANPARTICIPANTSYSTEMID],
[PROSPECTPLANDIMID],
[PROSPECTPLANCONSTITUENTDIMID],
[CONSTITUENTDIMID],
[CONSTITUENTSYSTEMID],
[PLANPARTICIPANTROLE]
from [BBDW].[DIM_PLANPARTICIPANT];