v_DIM_FUNDINGREQUESTOUTLINESTEP
Contains information about the funding request outline step dimension.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FUNDINGREQUESTOUTLINESTEPDIMID | int | BBDW.[DIM_FUNDINGREQUESTOUTLINESTEP].[FUNDINGREQUESTOUTLINESTEPDIMID] | |
| FUNDINGREQUESTOUTLINESTEPSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_FUNDINGREQUESTOUTLINESTEP].[FUNDINGREQUESTOUTLINESTEPSYSTEMID] |
| FUNDRAISERROLE | nvarchar(19) | yes | BBDW.[DIM_FUNDINGREQUESTOUTLINESTEP].[FUNDRAISERROLE] |
| FUNDRAISERROLECODE | tinyint | yes | BBDW.[DIM_FUNDINGREQUESTOUTLINESTEP].[FUNDRAISERROLECODE] |
| FUNDINGREQUESTOUTLINESTEPOBJECTIVE | nvarchar(100) | yes | BBDW.[DIM_FUNDINGREQUESTOUTLINESTEP].[FUNDINGREQUESTOUTLINESTEPOBJECTIVE] |
| DATEOFFSET | int | yes | BBDW.[DIM_FUNDINGREQUESTOUTLINESTEP].[DATEOFFSET] |
| FUNDINGREQUESTSTAGE | nvarchar(100) | yes | BBDW.[DIM_FUNDINGREQUESTOUTLINESTEP].[FUNDINGREQUESTSTAGE] |
| FUNDINGREQUESTOUTLINENAME | nvarchar(100) | yes | BBDW.[DIM_FUNDINGREQUESTOUTLINESTEP].[FUNDINGREQUESTOUTLINENAME] |
| INTERACTIONTYPE | nvarchar(100) | yes | BBDW.[DIM_FUNDINGREQUESTOUTLINESTEP].[INTERACTIONTYPE] |
| SITEDIMID | int | yes | BBDW.[DIM_FUNDINGREQUESTOUTLINESTEP].[SITEDIMID] |
Definition
Copy
create view [BBDW].[v_DIM_FUNDINGREQUESTOUTLINESTEP] as
select
[FUNDINGREQUESTOUTLINESTEPDIMID],
[FUNDINGREQUESTOUTLINESTEPSYSTEMID],
[FUNDRAISERROLE],
[FUNDRAISERROLECODE],
[FUNDINGREQUESTOUTLINESTEPOBJECTIVE],
[DATEOFFSET],
[FUNDINGREQUESTSTAGE],
[FUNDINGREQUESTOUTLINENAME],
[INTERACTIONTYPE],
[SITEDIMID]
from [BBDW].[DIM_FUNDINGREQUESTOUTLINESTEP];