v_DIM_PROCESS
Stores information about various processes
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PROCESSDIMID | int | BBDW.[DIM_PROCESS].[PROCESSDIMID] | |
| PROCESSSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PROCESS].[PROCESSSYSTEMID] |
| PROCESSNAME | nvarchar(100) | yes | BBDW.[DIM_PROCESS].[PROCESSNAME] |
| PROCESSDESCRIPTION | nvarchar(255) | yes | BBDW.[DIM_PROCESS].[PROCESSDESCRIPTION] |
| PROCESSTYPECODE | tinyint | yes | BBDW.[DIM_PROCESS].[PROCESSTYPECODE] |
| PROCESSTYPE | nvarchar(50) | yes | BBDW.[DIM_PROCESS].[PROCESSTYPE] |
Definition
Copy
create view [BBDW].[v_DIM_PROCESS] as
select
[PROCESSDIMID],
[PROCESSSYSTEMID],
[PROCESSNAME],
[PROCESSDESCRIPTION],
[PROCESSTYPECODE],
[PROCESSTYPE]
from [BBDW].[DIM_PROCESS];