v_DIM_SOURCE
This describes all data sources being fed into the Data Warehouse. By default there is only 1 which is BBEC and this pulls some info from the INSTALLATIONINFO table.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SOURCEDIMID | int | BBDW.[DIM_SOURCE].[SOURCEDIMID] | |
| SOURCESYSTEMID | nvarchar(100) | yes | BBDW.[DIM_SOURCE].[SOURCESYSTEMID] |
| SOURCENAME | nvarchar(100) | yes | BBDW.[DIM_SOURCE].[SOURCENAME] |
| SOURCESHORTNAME | nvarchar(20) | yes | BBDW.[DIM_SOURCE].[SOURCESHORTNAME] |
| SOURCEVERSION | nvarchar(25) | yes | BBDW.[DIM_SOURCE].[SOURCEVERSION] |
| ORGNAME | nvarchar(100) | yes | BBDW.[DIM_SOURCE].[ORGNAME] |
| FISCALYEARDAYMONTHSTART | nvarchar(5) | yes | BBDW.[DIM_SOURCE].[FISCALYEARDAYMONTHSTART] |
| FISCALYEARMONTHSTART | tinyint | yes | BBDW.[DIM_SOURCE].[FISCALYEARMONTHSTART] |
| MAINTRANSACTIONTYPE | nvarchar(25) | yes | BBDW.[DIM_SOURCE].[MAINTRANSACTIONTYPE] |
| MAINTRANSACTIONSTARTDATE | datetime | yes | BBDW.[DIM_SOURCE].[MAINTRANSACTIONSTARTDATE] |
| MAINTRANSACTIONENDDATE | datetime | yes | BBDW.[DIM_SOURCE].[MAINTRANSACTIONENDDATE] |
| EARLIESTREPORTDATE | datetime | yes | BBDW.[DIM_SOURCE].[EARLIESTREPORTDATE] |
| LATESTREPORTDATE | datetime | yes | BBDW.[DIM_SOURCE].[LATESTREPORTDATE] |
| CURRENTFISCALYEARSTARTDATE | datetime | yes | BBDW.[DIM_SOURCE].[CURRENTFISCALYEARSTARTDATE] |
| CURRENTFISCALYEARENDDATE | datetime | yes | BBDW.[DIM_SOURCE].[CURRENTFISCALYEARENDDATE] |
| LASTREFRESHDATE | datetime | yes | BBDW.[DIM_SOURCE].[LASTREFRESHDATE] |
Definition
Copy
create view [BBDW].[v_DIM_SOURCE] as
select
[SOURCEDIMID],
[SOURCESYSTEMID],
[SOURCENAME],
[SOURCESHORTNAME],
[SOURCEVERSION],
[ORGNAME],
[FISCALYEARDAYMONTHSTART],
[FISCALYEARMONTHSTART],
[MAINTRANSACTIONTYPE],
[MAINTRANSACTIONSTARTDATE],
[MAINTRANSACTIONENDDATE],
[EARLIESTREPORTDATE],
[LATESTREPORTDATE],
[CURRENTFISCALYEARSTARTDATE],
[CURRENTFISCALYEARENDDATE],
[LASTREFRESHDATE]
from [BBDW].[DIM_SOURCE];