v_DIM_FUNDINGREQUEST
contains information about funding requests.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FUNDINGREQUESTDIMID | int | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGREQUESTDIMID] | |
| FUNDINGREQUESTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGREQUESTSYSTEMID] |
| FUNDINGPLANMANAGERCONSTITUENTDIMID | int | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGPLANMANAGERCONSTITUENTDIMID] |
| FUNDINGPLANMANAGERCONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGPLANMANAGERCONSTITUENTSYSTEMID] |
| FUNDINGPLANNAME | nvarchar(150) | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGPLANNAME] |
| FUNDINGPLANDESCRIPTION | nvarchar(500) | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGPLANDESCRIPTION] |
| FUNDINGNEEDAMOUNT | money | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGNEEDAMOUNT] |
| FUNDINGPLANNEEDEDDATEDIMID | int | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGPLANNEEDEDDATEDIMID] |
| FUNDINGPLANNEEDEDDATE | datetime | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGPLANNEEDEDDATE] |
| FUNDINGPLANDEPARTMENT | nvarchar(100) | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGPLANDEPARTMENT] |
| FUNDINGPLANPROGRAM | nvarchar(100) | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGPLANPROGRAM] |
| FUNDINGPLANISACTIVE | bit | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGPLANISACTIVE] |
| SITEDIMID | int | yes | BBDW.[DIM_FUNDINGREQUEST].[SITEDIMID] |
| SUBMITTEDDATEDIMID | int | yes | BBDW.[DIM_FUNDINGREQUEST].[SUBMITTEDDATEDIMID] |
| SUBMITTEDDATE | datetime | yes | BBDW.[DIM_FUNDINGREQUEST].[SUBMITTEDDATE] |
| REQUESTEDAMOUNT | money | yes | BBDW.[DIM_FUNDINGREQUEST].[REQUESTEDAMOUNT] |
| AWARDEDAMOUNT | money | yes | BBDW.[DIM_FUNDINGREQUEST].[AWARDEDAMOUNT] |
| FUNDINGREQUESTCOMMENT | nvarchar(500) | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGREQUESTCOMMENT] |
| PRIMARYMANAGERCONSTITUENTDIMID | int | yes | BBDW.[DIM_FUNDINGREQUEST].[PRIMARYMANAGERCONSTITUENTDIMID] |
| PRIMARYMANAGERCONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_FUNDINGREQUEST].[PRIMARYMANAGERCONSTITUENTSYSTEMID] |
| SECONDARYMANAGERCONSTITUENTDIMID | int | yes | BBDW.[DIM_FUNDINGREQUEST].[SECONDARYMANAGERCONSTITUENTDIMID] |
| SECONDARYMANAGERCONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_FUNDINGREQUEST].[SECONDARYMANAGERCONSTITUENTSYSTEMID] |
| FUNDINGREQUESTSTAGE | nvarchar(100) | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGREQUESTSTAGE] |
| FUNDINGREQUESTSTATUS | nvarchar(100) | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGREQUESTSTATUS] |
| FUNDINGREQUESTTYPE | nvarchar(100) | yes | BBDW.[DIM_FUNDINGREQUEST].[FUNDINGREQUESTTYPE] |
Definition
Copy
create view [BBDW].[v_DIM_FUNDINGREQUEST] as
select
[FUNDINGREQUESTDIMID],
[FUNDINGREQUESTSYSTEMID],
[FUNDINGPLANMANAGERCONSTITUENTDIMID],
[FUNDINGPLANMANAGERCONSTITUENTSYSTEMID],
[FUNDINGPLANNAME],
[FUNDINGPLANDESCRIPTION],
[FUNDINGNEEDAMOUNT],
[FUNDINGPLANNEEDEDDATEDIMID],
[FUNDINGPLANNEEDEDDATE],
[FUNDINGPLANDEPARTMENT],
[FUNDINGPLANPROGRAM],
[FUNDINGPLANISACTIVE],
[SITEDIMID],
[SUBMITTEDDATEDIMID],
[SUBMITTEDDATE],
[REQUESTEDAMOUNT],
[AWARDEDAMOUNT],
[FUNDINGREQUESTCOMMENT],
[PRIMARYMANAGERCONSTITUENTDIMID],
[PRIMARYMANAGERCONSTITUENTSYSTEMID],
[SECONDARYMANAGERCONSTITUENTDIMID],
[SECONDARYMANAGERCONSTITUENTSYSTEMID],
[FUNDINGREQUESTSTAGE],
[FUNDINGREQUESTSTATUS],
[FUNDINGREQUESTTYPE]
from [BBDW].[DIM_FUNDINGREQUEST];