v_DIM_BUSINESSUNIT
Stores information about business units
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| BUSINESSUNITDIMID | int | BBDW.[DIM_BUSINESSUNIT].[BUSINESSUNITDIMID] | |
| BUSINESSUNITSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_BUSINESSUNIT].[BUSINESSUNITSYSTEMID] |
| BUSINESSUNIT | nvarchar(100) | yes | BBDW.[DIM_BUSINESSUNIT].[BUSINESSUNIT] |
| BUSINESSUNITISACTIVE | bit | yes | BBDW.[DIM_BUSINESSUNIT].[BUSINESSUNITISACTIVE] |
| BUSINESSUNITSEQUENCE | int | yes | BBDW.[DIM_BUSINESSUNIT].[BUSINESSUNITSEQUENCE] |
Definition
Copy
create view [BBDW].[v_DIM_BUSINESSUNIT] as
select
[BUSINESSUNITDIMID],
[BUSINESSUNITSYSTEMID],
[BUSINESSUNIT],
[BUSINESSUNITISACTIVE],
[BUSINESSUNITSEQUENCE]
from [BBDW].[DIM_BUSINESSUNIT];