v_DIM_APPEAL
The Appeal dimension contains information about the appeal.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| APPEALDIMID | int | BBDW.[DIM_APPEAL].[APPEALDIMID] | |
| APPEALSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_APPEAL].[APPEALSYSTEMID] |
| APPEALNAME | nvarchar(100) | yes | BBDW.[DIM_APPEAL].[APPEALNAME] |
| APPEALDESCRIPTION | nvarchar(300) | yes | BBDW.[DIM_APPEAL].[APPEALDESCRIPTION] |
| APPEALGOAL | money | yes | BBDW.[DIM_APPEAL].[APPEALGOAL] |
| APPEALISACTIVE | bit | yes | BBDW.[DIM_APPEAL].[APPEALISACTIVE] |
| APPEALCATEGORY | nvarchar(100) | yes | BBDW.[DIM_APPEAL].[APPEALCATEGORY] |
| APPEALREPORTCODE | nvarchar(100) | yes | BBDW.[DIM_APPEAL].[APPEALREPORTCODE] |
| APPEALSTARTDATE | datetime | yes | BBDW.[DIM_APPEAL].[APPEALSTARTDATE] |
| APPEALSTARTDATEDIMID | int | yes | BBDW.[DIM_APPEAL].[APPEALSTARTDATEDIMID] |
| APPEALENDDATE | datetime | yes | BBDW.[DIM_APPEAL].[APPEALENDDATE] |
| APPEALENDDATEDIMID | int | yes | BBDW.[DIM_APPEAL].[APPEALENDDATEDIMID] |
| SITESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_APPEAL].[SITESYSTEMID] |
Definition
Copy
CREATE view [BBDW].[v_DIM_APPEAL] as
select
[APPEALDIMID],
[APPEALSYSTEMID],
[APPEALNAME],
[APPEALDESCRIPTION],
[APPEALGOAL],
[APPEALISACTIVE],
[APPEALCATEGORY],
[APPEALREPORTCODE],
[APPEALSTARTDATE],
[APPEALSTARTDATEDIMID],
[APPEALENDDATE],
[APPEALENDDATEDIMID],
[SITESYSTEMID]
from
BBDW.[DIM_APPEAL]