v_DIM_PURPOSELEVEL
The purpose level dimension contains information about designation levels.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PURPOSELEVELDIMID | int | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELDIMID] | |
| PURPOSELEVELSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELSYSTEMID] |
| PURPOSELEVELNAME | nvarchar(100) | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELNAME] |
| PURPOSELEVELPUBLICNAME | nvarchar(512) | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELPUBLICNAME] |
| PURPOSELEVELDESCRIPTION | nvarchar(255) | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELDESCRIPTION] |
| PURPOSELEVELLOOKUPID | nvarchar(100) | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELLOOKUPID] |
| PURPOSELEVELISENDOWED | bit | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELISENDOWED] |
| PURPOSELEVELENDOWMENTMINAMOUNT | money | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELENDOWMENTMINAMOUNT] |
| PURPOSELEVELENDOWMENTTARGETDATE | datetime | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELENDOWMENTTARGETDATE] |
| PURPOSELEVELENDOWMENTMINAMOUNTMETDATE | datetime | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELENDOWMENTMINAMOUNTMETDATE] |
| PURPOSELEVELISFULLYFUNDED | bit | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELISFULLYFUNDED] |
| PURPOSELEVELISACCEPTINGFUNDS | bit | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELISACCEPTINGFUNDS] |
| PURPOSELEVELISDISBURSINGMONEY | bit | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELISDISBURSINGMONEY] |
| PURPOSELEVELISINCOMETOPRINCIPAL | bit | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELISINCOMETOPRINCIPAL] |
| PURPOSELEVELINCOMETOPRINCIPALPERCENT | decimal(5, 2) | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELINCOMETOPRINCIPALPERCENT] |
| PURPOSELEVELFREQUENCY | nvarchar(30) | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELFREQUENCY] |
| PURPOSELEVELCATEGORY | nvarchar(100) | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELCATEGORY] |
| PURPOSELEVELTYPE | nvarchar(100) | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELTYPE] |
| PURPOSELEVELREPORT1CODE | nvarchar(100) | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELREPORT1CODE] |
| PURPOSELEVELREPORT2CODE | nvarchar(100) | yes | BBDW.[DIM_PURPOSELEVEL].[PURPOSELEVELREPORT2CODE] |
| PURPOSELEVELSITEDIMID | int | yes | BBDW.[DIM_PURPOSELEVEL].[SITEDIMID] |
| SITESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PURPOSELEVEL].[SITESYSTEMID] |
Definition
Copy
CREATE view [BBDW].[v_DIM_PURPOSELEVEL] as
select
[PURPOSELEVELDIMID],
[PURPOSELEVELSYSTEMID],
[PURPOSELEVELNAME],
[PURPOSELEVELPUBLICNAME],
[PURPOSELEVELDESCRIPTION],
[PURPOSELEVELLOOKUPID],
[PURPOSELEVELISENDOWED],
[PURPOSELEVELENDOWMENTMINAMOUNT],
[PURPOSELEVELENDOWMENTTARGETDATE],
[PURPOSELEVELENDOWMENTMINAMOUNTMETDATE],
[PURPOSELEVELISFULLYFUNDED],
[PURPOSELEVELISACCEPTINGFUNDS],
[PURPOSELEVELISDISBURSINGMONEY],
[PURPOSELEVELISINCOMETOPRINCIPAL],
[PURPOSELEVELINCOMETOPRINCIPALPERCENT],
[PURPOSELEVELFREQUENCY],
[PURPOSELEVELCATEGORY],
[PURPOSELEVELTYPE],
[PURPOSELEVELREPORT1CODE],
[PURPOSELEVELREPORT2CODE],
[SITEDIMID] as [PURPOSELEVELSITEDIMID],
[SITESYSTEMID]
from BBDW.[DIM_PURPOSELEVEL]