V_QUERY_BBDW_PURPOSELEVEL
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PURPOSELEVELSYSTEMID | uniqueidentifier | yes | |
| PURPOSELEVELDIMID | int | ||
| PURPOSELEVELNAME | nvarchar(100) | yes | |
| PURPOSELEVELLOOKUPID | nvarchar(100) | yes | |
| PURPOSELEVELPUBLICNAME | nvarchar(512) | yes | |
| PURPOSELEVELTYPE | nvarchar(100) | yes | |
| PURPOSELEVELDESCRIPTION | nvarchar(255) | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_PURPOSELEVEL] as
select
[PURPOSELEVELSYSTEMID],
[PURPOSELEVELDIMID],
[PURPOSELEVELNAME] as [PURPOSELEVELNAME],
[PURPOSELEVELLOOKUPID] as [PURPOSELEVELLOOKUPID],
[PURPOSELEVELPUBLICNAME] as [PURPOSELEVELPUBLICNAME],
[PURPOSELEVELTYPE] as [PURPOSELEVELTYPE],
[PURPOSELEVELDESCRIPTION] as [PURPOSELEVELDESCRIPTION]
from BBDW.[DIM_PURPOSELEVEL]
where [PURPOSELEVELDIMID] > 0