v_DIM_PLANOUTLINESTEP
Contains informationabout prospect plan outline steps.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PLANOUTLINESTEPDIMID | int | BBDW.[DIM_PLANOUTLINESTEP].[PLANOUTLINESTEPDIMID] | |
| PLANOUTLINESTEPSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PLANOUTLINESTEP].[PLANOUTLINESTEPSYSTEMID] |
| PLANOUTLINENAME | nvarchar(100) | yes | BBDW.[DIM_PLANOUTLINESTEP].[PLANOUTLINENAME] |
| PLANOUTLINESTEPOBJECTIVE | nvarchar(100) | yes | BBDW.[DIM_PLANOUTLINESTEP].[PLANOUTLINESTEPOBJECTIVE] |
| INTERACTIONTYPE | nvarchar(100) | yes | BBDW.[DIM_PLANOUTLINESTEP].[INTERACTIONTYPE] |
| FUNDRAISERROLECODE | int | yes | BBDW.[DIM_PLANOUTLINESTEP].[FUNDRAISERROLECODE] |
| FUNDRAISERROLE | nvarchar(100) | yes | BBDW.[DIM_PLANOUTLINESTEP].[FUNDRAISERROLE] |
| PROSPECTPLANSTATUS | nvarchar(100) | yes | BBDW.[DIM_PLANOUTLINESTEP].[PROSPECTPLANSTATUS] |
| SITEDIMID | int | yes | BBDW.[DIM_PLANOUTLINESTEP].[SITEDIMID] |
Definition
Copy
create view [BBDW].[v_DIM_PLANOUTLINESTEP] as
select
[PLANOUTLINESTEPDIMID],
[PLANOUTLINESTEPSYSTEMID],
[PLANOUTLINENAME],
[PLANOUTLINESTEPOBJECTIVE],
[INTERACTIONTYPE],
[FUNDRAISERROLECODE],
[FUNDRAISERROLE],
[PROSPECTPLANSTATUS],
[SITEDIMID]
from [BBDW].[DIM_PLANOUTLINESTEP];